This content has been marked as final.
Show 1 reply

Re: Strange problem creating new grouping table based off of resident table
Izzy Bromberg Apr 10, 2013 3:26 AM (in response to Izzy Bromberg)So I realized how to solve this.
As I said the original query in the load script was correct. The problem was that I needed the query to be dynamic and update based upon the dimensions choosen.
Here is what I did to solve the problem.
For the dimesnsion of my chart I used the following formula:
=aggr(
if(sum(sdk_syncs) <= 50000,'050K',
if(sum(sdk_syncs) > 50000 and sum( sdk_syncs) <=200000,'50K  200K',
if(sum(sdk_syncs) > 200000 and sum(sdk_syncs) <=500000,'200K  500K',
if(sum(sdk_syncs) > 500000 and sum(sdk_syncs) <=1000000,'500K  1M',
if(sum(sdk_syncs) > 1000000,'> 1M','blank'
))))),
application_key
)
Then as an expression I used a count distinct of the application_key.