Set Analysis

[sspawar88]

Hello Friends,

Here I'm trying to calculate the Percentage of Temperature in Drill down Approach.(Year-Month-Week-Day-Created_date)

i'm using the following Set analysis

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

Count(total{$<param_name={'Temperature'}>}param_value)*100

But it wont work as my expectation.

Which changes i have to make in it so that it can applicable for all Year-Month-Week-Day-Created_date?

Note : Created_date field consist thousands of records which generate after few minutes in a day

Formula Description-- Requirement is for Count of Tempe which is below -1 (i.e. -2,-3,-4...) upon Total Temperature (i.e. ...1,0,-1...all values) .

here i came across problem at created_date. it gives value like 0.001 on all data point.

is it correct?

if it is not correct what is the valid way to calculate it correctly for such temperature database.

please suggest from your experience !!

[Anonymous]

I think created_date is time stamp and you are simply converting it to Date()

Make sure you have correct time format and then use floor () to get the date

See example -

The Date Function

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

Count({1<param_name{'Temperature'}>}param_value)*100

Thanks

BKC