Plots with text
How to use text layers in Count
If you add a Text layer, you will be able to add a column to the text axis:
You can also click the text axis to adjust the text display settings:
By default, a Text layer will show 'abc' at every point on the visual if no column is placed on the text axis:
Once a column is placed on the text axis, the default text will be replaced by the contents of the column:
To create visuals with annotations, try mixing Text layers with other layer types:
To change the text displayed on the visual, just alter the SQL query. For example, if you wanted to use the power of visualisation to subtly denote your approval, you could generate a new column to place on the text axis:
1
select
2
avg(Profit) as avg_profit,
3
avg(Sales) as avg_sales,
4
case
5
when avg(Profit) >= 80 then concat(State, ' 🎉')
6
when avg(Profit) < 80 then concat(State, ' 😥')
7
end as text
8
from
9
sales_table
10
group by
11
State
Copied!
Copy link