Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to use this expression:
count(total<TIMESTAMP,COUNTRY> distinct ID)
The problem is that I want to use it in a dashboard whose dimesions are TIMESTAMP and a calculated dimension COUNTRY-CITY
Do you know how can I get the result of that expression using calculated dimensions?,
maybe calculating the dimension in the script? (I don't know how to do it)
Thanks,
David
Would always recommend to create a dimension in the script, like
LOAD
*,
COUNTRY & '-' & CITY AS CITY_id
FROM ....;
HTH
Peter