Forum Discussion
Till
Resolver II
8 years agoGoals without average
Hallo Community,
i have a question about a goal calculation.
I have two Excel tables. One with a AHT (average handling Time and name of a topic) and the other table with goals for the AHT an the topic. (Topic 1 and Topic 2).
I join the tabels like the picture.
The aht measure is sum(aht[cht])/sum(aht[anzahl])
now i take a matrix and set the fields aht und goals
Now I have the problem that I can only calculate an average value for the goals.
What am i doing wrong?
Thanks for help.
Till
Till,
Based on the above, you may set cross filter direction to 'Both' in the Edit relationship dialog.
2 Replies
- v-chuncz-msft
Community Support
Till,
Based on the above, you may set cross filter direction to 'Both' in the Edit relationship dialog.
- Till
Resolver II
Thanks, an sorry for the late request.
It works