Calculated Fractile

[Anonymous]

Hi,

I have a good working Fractile Reference Line in a scatter chart:

=Fractile(Aggr(COUNT(DISTINCT{$<ivStat={1}>} Account#),StaffName),0.95)

However, when I select/filter by staff name, the reference line moves.

What I would like to happen is that the reference line stays and a pointer to the staffname to appear. So I could see the staffname performance in reference to the 95% fractile..

Thanks

[Anil_Babu_Samineni]

Perhaps This

=Aggr(Fractile(COUNT({$<ivStat={'1'}>} DISTINCT Account#),StaffName),0.95)

[Anonymous]

Hi Anil,

Thanks for your response:

The Fractile() function needs the 0.95 parameter. However, I did switch positions, including the parameter, but it did not work.

[sunny_talwar · Accepted solution]

So you are looking for a way to ignore selection in staffname field?

=Fractile({<StaffName>}Aggr(COUNT(DISTINCT{$<ivStat={1}, StaffName>} Account#),StaffName),0.95)

[Anonymous]

That's right Sunny.

Your suggestion makes sense, but its not working.

Thanks

[jonathandienst]

I agree with Sunny - you need to override the relevant fields in Fractile() to prevent the Aggr() being reduced by that selection. That is what is happening at the moment and is why your reference line is changing. It also needs to be overridden inside the Aggr().

If necessary, change the field name (StaffName) to the correct name (or names) from your application.

[Anonymous]

Sunny ( and J.D.) , thanks very much - you were correct. I had to apply this methodology also to my dimensions/expressions.

Thanks!!