Table calculations make it easy to create metrics on the fly (for example, aggregating the data in your table over some window, or getting a running total of a column).
+ Table calculation
in the Results
tab of the Explore view:
${table_name.field_name}
.
format
tab.
Format types | Description | Raw value | How it might look like in Lightdash |
---|---|---|---|
Default | Default format for the table calculation result | 0.75 | 0.75 |
Percent | Converts numbers into a percentage | 0.75 | 75% |
Currency | Adds currency symbol and default locale format | 1234.1234 | $ 1234.12 |
Number | Formats number with prefix and suffix | 123.1234 | Speed: 123.12 km/h |