topic Re: How to find TAT between two dates, for top complaints in App Development

How to find TAT between two dates, for top complaints

abc_18 — Sat, 16 Nov 2024 18:28:39 GMT

Hello Everyone,

I have to find the name of top raised complaints, where no of the issues reported are highest.

I am using below formula which gives me the name of Complaints which count is highest.

=FirstSortedValue(comp_name, -Aggr(Count(complaint_id),comp_name)) gives me O/P as 'Machine not working'

To calculate TAT in general, I am using below expression, where TAT I have calculated in script itself (difference between two dates).

round(Avg({<status={'X'}, Tableflag={'abc'}, date={">=$(=Date(Yearstart(Today(),0,4),'YYYY-MM-DD'))"}>} TAT))

Now I have to calculate TAT for highest raised complaint ('Machine not working'), how to do that.

I am facing issue while trying to combine above two formulas.

Please suggest, urgently need help on this.

Regards

abc_18 — Thu, 18 Jun 2020 07:30:30 GMT

SerhanKaraer — Thu, 18 Jun 2020 10:23:21 GMT

Hello abc,

You can filter comp_name with the highest comp_name.

round(Avg({<status={'X'}, Tableflag={'abc'}, date={">=$(=Date(Yearstart(Today(),0,4),'YYYY-MM-DD'))"},

comp_name={"$(=FirstSortedValue(comp_name, -Aggr(Count(complaint_id),comp_name)))"}

>} TAT))

To simplify expression text, you can use variables as this:

round(Avg({<status={'X'}, Tableflag={'abc'}, date={">=$(=Date(Yearstart(Today(),0,4),'YYYY-MM-DD'))"},

comp_name={"$(HighestCompVariable)"}

>} TAT))

abc_18 — Thu, 18 Jun 2020 12:41:42 GMT

Thank you very much for your help, working as expected.

Regards