This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Measures are metrics aggregated across the selected data set, while
computed dimensions apply logic to the data at each row level, and are
then grouped at the grain of the look (which you could then calculate
measures against). Typically you would us...
jwp: lumn as a date is much faster than converting it to a string. I
wouldn’t be surprised if this is true for all databases; it is
definitely true for Snowflake. Here’s an example: select
date_trunc(‘month’,d), count(1) from foo group by 1vsselect
t...