Fractile and Set Analysis - Date range

[stevegimbrollmt]

Hi guys

Is it possible to do this set anaylsis in a  fractile

e.g. =fractile(IF(KPI_CHT='GGR', CHT_VALUE),.8)

and I want to add a 30day bracket in it like this

{<[kpi_date]={">=$(=date((created_date)-30))<=$(=date((created_date)))"} }

thanks a lot!

Steve

[klausskalts]

My guess is that this might work:

{<

[kpi_date]={">=$(=max(date((created_date))-30)),<=$(=max(date((created_date))))"}

>}

But remember that you will still have to face some issues regarding re-use of fields in dimensions etc .....

[stevegimbrollmt]

thanks for your reply, but how does this effect the fractile function?

I am using this in a graph for a percentage line.

I want the fractile to change also based on date range, is that possible?

[danielrozental]

Steve, why don't you try posting a sample application so we can help you.

Something like this should work

fractile(

{<

[kpi_date]={">=$(=max(date((created_date))-30)),<=$(=max(date((created_date))))"},

KPI_CHT={'GGR'}

>} CHT_VALUE, 0.8)

[stevegimbrollmt · Accepted solution]

Hi guys, just to let you know that this was solved by doing something like this

=fractile({$<KPI_CHT={'GGR'}, RUNDATE_CHT={'>=$(=v_30_Days)<=$(=RUNDATE_DTL)'}>}CHT_VALUE, .8)

thanks a lot for your help guys