Aggregation with Fractile in Chart Expression not working

joybratas1 — Fri, 14 Oct 2022 08:40:15 GMT

Hi Community,

I have been struggling in creating a logic for my table as well as Map expression.

My expression looks somewhat like

sum(aggr({index= {"<=$(vIndex) >"} Fractile(hours, 0.95) ,index))

My aim is to sum the 95th percentile hours for each index that is greater than (vIndex)

But this don't work.

Please help me in this.

Re: Aggregation with Fractile in Chart Expression not working

Mario_De_Felipe — Mon, 24 Oct 2022 06:47:30 GMT

The right format for your expression is: sum(aggr(Fractile({<index= {"<=$(vIndex)"}>} hours, 0.95) ,index))