Single value cells
Call out the top-level results of your projects and contextualize them with comparisons to related data.
With their larger font and distinct tile format these cells are helpful for summarizing the big takeaways of your data analysis.
Single value cell configuration
To configure a Single value cell select the cog icon in the upper right of the cell. In the Value field select the value you'd like to display. Only variables of numeric type can be referenced in a Single value cell, which means that the output of a SQL cell cannot be referenced directly in a Single value cell. To use the result of SQL cell query that returns a dataframe with a single value, define a variable to hold the value with the following code snippet:
value_to_display = dataframe_name['column_name']
value_to_display variable will show up as an available input for a Single value cell.
Optionally, you can compare the main value against another data point by toggling on the Show comparison option. Via the Type dropdown menu you can show an absolute comparison or percent change between the main value and the comparison value.