Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Total can be used the way you have. Are you not getting the output you are expecting?
It seems right ...
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.
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
Great