It could be possible, but i think it depends on how your data is structured. Could you elaborate a bit on what data you need to calculate your percentiles on?
I agree with Roger, it will in part depend on the structure of your data. I would also recommend having a look at the following post, as it may get you closer to what you are trying to achieve:
Get the 95th Percentile of a range of Values in a Peformance Equation
Can you provide some more context around what you are specifically trying to get to with the required percentile calculations?
Hi John and Roger,
John I have gone through the document above, however the issue is that I need to calculate 90 and 80 percentiles.
As far as the structure is concerned, the element has instantaneous water flow going to a filter and Raw Water Turbidity and Filter Water Turbidity are measured associated to the flow.
The event frame works on cycles of filtration; start trigger when Backwash = 0 and EndTrigger when Backwash = 1
The attributes that I am calculating are: Avg, Min and Max turbidity for events. similarly I need to calculate 90 and 80 percentile for the events.
I hope the above information would be useful to be able to suggest possible solutions to the problem. However, feel free to let me know should you need further information.
Retrieving data ...