Example Calculated Columns
Examples of calculated column expressions
Data in dashboards can be augmented with calculated columns. Each dataset will contain a section for calculated columns. Calculated columns can be written and modified with PostgreSQL-flavored SQL.
Navigating to a dataset
In order to view and edit metrics and calculated expressions, perform the following steps:
- Sign into plaidcloud.com and navigate to dashboards
- From within visualize.plaidcloud.com, navigate to Data > Datasets
- Search for a dataset to view or modify
- Modify the dataset by hovering over the
coalesce (useful for converting nulls to 0.0, for instance)
divide, with a hack for avoiding DIV/0 errors
Note: A better way to do this would be to check for a null or zero denominator and then coalese to zero rather than attempting the division.
CASE WHEN "Field_A"= 'Foo' THEN max(coalesce("Value_A",0.0)) - max(coalesce("Value_B",0.0)) END
Last modified July 08, 2022 at 2:29 PM EST: little tweak to 1 page (cfb877a)