Results tables can be useful for finding specific numbers or checking out your data, but it’s usually easier to see trends and make sense of your data using charts.
column_i_want_to_group_by
, then in your chart configuration choose your x-axis, group dimension, and the new table calculation as your y-axis.
100% Stacked Bar Charts are useful when you need to visualize how the composition of a metric changes over time, or how the composition changes across different groups.
series
tab of the Configure
space.
donut
toggle to switch between a traditional pie and donut chart.
Data orientation
switch to specify which orientation you would like to use.
When rows
is selected, each row of your data represent one step. The first column in the data will be treated as the labels for the steps, and you can choose which numeric column to treat as the value of the step.
When columns
is selected, you should have a numeric column for each step you want to display. Only the first row of data will be represented and the column names will be used as the step labels. Non-numeric columns will be ignored.
column
section of your table configuration. This will change the dimension from having its values populate the rows values of your table, to having it populate the column values of your table.
show metrics as rows
in the table configuration.
Show column totals
or Show row totals
in the chart configuration panel. The column totals in your results and table visualizations are calculated using the underlying data from your table, not only the values that are visible in the table.
count
and sum
metric types.count_distinct
metric type, you can sometimes get totals that are smaller than if you sum up the values seen in the table.
For example, if you count the distinct number of devices that viewed pages on our website each month, it would look something like this:
Anonymous device count
column, the value you get is much higher than the total shown in the table. This is because the same device can view pages on our website across many months. So, when you add up the values in the table, you’ll be counting some devices more than once.
Lightdash uses a SQL query to calculate the distinct number of devices across all of the months so we avoid double-counting devices.
Why are my totals higher?
There are two reasons why this could be happening:
count_distinct
!Show subtotals
in the chart configuration panel.
Profit
column red when a row is less than $10,000Revenue
column green when it is greater than the Target revenue
column.Partner name
column orange when the Total orders
column is greater than 1,000.+ Add
under the reference lines option, then configure your reference line in the drop-down.
You can:
position
are the coordinates of the legend on your chart. They can either be numbers or percent. We suggest using %.top
= 70, bottom
= 30, left
= 5%, right
= 5%