Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI! 🙂
I need a help with ma set analysis:
What i want is, that i want from all Teammembers the average of there sale.
I have a table where i have the teammember, calenderWeek, Win, Loose.
I want the average from win / (win+loose).
The average over all teammeber i calcualte with the following statement:
sum({1}aggr(
(((count({$<[KW]={"<=$(=Getfieldselections(CW)) >=$(vCWTD)"}>} Win))
/
(
(count({$<[KW]={"<=$(=Getfieldselections(CW)) >=$(vCWTD)"}>} Loose))
+((count({$<[KW]={"<=$(=Getfieldselections(CW)) >=$(vCWTD)"}>} Win)))
))),
(CW)))/13
The Variable vCWTD calculates for me 12 weeks back depend on the selected CalenderWeek - for example if 201920 is selected vCWTD would be 201908.
In a diagram i have the average of there sale calcuted with the following expression:
=
(count({$<[KW]={"<=$(=Getfieldselections(CW)) >=$(vCWTD)"}>} Win))
/
(
(count({$<[KW]={"<=$(=Getfieldselections(CW)) >=$(vCWTD)"}>} Loose))
+((count({$<[KW]={"<=$(=Getfieldselections(CW)) >=$(vCWTD)"}>} Win)))
)
The dimension is this chart is the CalenderWeek (CW).
Now what i want is, i want to know the average per teammemeber - but i dont know how i can get it.
Thanks in advance for your help. 🙂
Hi,
Do you have a qv example to upload here?
Thanks