TOTAL in calculated dimensions

[#1]

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

[prieper]

Would always recommend to create a dimension in the script, like

LOAD

*,

COUNTRY & '-' & CITY    AS CITY_id

FROM ....;

HTH
Peter