Total keyword in set analysis?

[sspawar88]

Hi Community,

here i'm using this Set analysis for WEST region with the help of Total keyword

but have a doubt that this expression could be fail after loading millions record.

Can i using Total keyword in set analysis..is it right way?

Count({$<param_name={'Temperature'},param_value={'<=-1'},region_name={'WEST'}>}param_value)/

Count(total{$<param_name={'Temperature'},region_name=,param_value=>}param_value)

Count of temperature less than -1 (-1,-2,-3..onward) for west region upon total values count for all region

[sunny_talwar]

Total can be used the way you have. Are you not getting the output you are expecting?

[alexandros17]

It seems right ...

[swuehl]

Basically, the TOTAL qualifier is not used within the set expression, it's a qualifier to the aggregation function Count().

It will only make sense when used in a chart with dimensions or advanced aggregation.

I believe it won't fail after loading millions of records.

[sspawar88]

Hi Sunindia,

basically i'm using this expression in Bar chart.

it works fine.

but i was not confident for this one. but now damn sure

[sunny_talwar]

Great