So I have a group that is based off of object type and each group returns the elapsed time for that object type in a function. I have included two function (the bottom is the group but relies on the top function). When i put in a pthpercentile(90, {@elapsed time in minutes} function it calculate a total percentile for all values where I just want to calculate by group to see object group a 90th percentile and object group b 90th percentile. any ideas?



@elapsed time:

DateDiff ("s",{table.startdate} ,{table.enddate} )


and


@elapsed time in minutes:

Truncate({@elapsed time} / 60)
+
Remainder ({@elapsed time},60)/100

so the group name is another function. I put in pthpercentile(90, {@elapsed time in minutes}, GroupName ({@type})) and it says error this field cannot be used as a group condition field...so closer...but any ideas?

ok another part to this question. That fixed that report but i have another similar report i am trying to do the same thing but i have 3 groups each a sub of each other. I am trying to say if you are in group a1, b1 and c1 then what is the 90th percentile and a1, b1 and c2 then that one and a1, b2 and c1 that 90th and so on and so forth.

So group one is @zone group 2 is table.source and group 3 is table.type So I am looking for the pthpercentile of @elapsed time within that zone that was initiated by that source for that type. Does that make better sense?

yes.