Tips & Tricks

Practical hints for perfecting your queries

I need to change the date formatting in my results
You can change the format of most date/time fields from data sources by using the advanced setting "TIME_DIMENSION_FORMAT_???" -where the ??? is t...
Thu, 12 Apr, 2018 at 12:31 PM
I have "null" results that I would like to appear as number zeroes (0)
To get 0 values, even though you get blank results in your query, write "blanks_to_zeroes" in to advanced settings:
Tue, 21 Mar, 2017 at 5:14 PM
Refreshing License Info
In the case that your license has been updated or upgraded, you may need to do the following to refresh the license account information. Click on your ac...
Mon, 11 Jun, 2018 at 6:35 PM