Hi! 🙂
I have a question ..
I have the following table:
CalenderWeek, TicketStatus, TicketID
201901 Loose 39182819
201902 Loose 2389192
201903 Win 9293982
201904 Loose 1092830
201905 Win 182038
201906 Win 129392
201907 Win 12983838
Now i have a bar chart .. in the bar chart the dimension is CalenderWeek and in the expressions i have the following:
=count({$<[KW]={"<=$(=Getfieldselections(KW)) >=$(vKWTD)"}, TicketStatus={"Win"}>} TicketID)
=count({$<[KW]={"<=$(=Getfieldselections(KW)) >=$(vKWTD)"}, TicketStatus={"Loose"}>} TicketID)
The Variable vKWTD calculates for me the 6 weeks for example i choose the kw 201907, vKWTD would be 201901.
THan i have an expression where i calculate a rate for the weeks:
=(count({$<[KW]={"<=$(=Getfieldselections(KW)) >=$(vKWTD)"}, TicketStatus={"Win"}>} TicketID))
/ ((count({$<[KW]={"<=$(=Getfieldselections(KW)) >=$(vKWTD)"}, TicketStatus={"Win"}>} TicketID)) + (count({$<[KW]={"<=$(=Getfieldselections(KW)) >=$(vKWTD)"}, TicketStatus={"Loose"}>} TicketID)))*100
Now what i want is the first value of the top quartile of this rate within this 6 weeks .. but i dont know how i could do it.
Can you help me?