Forum Discussion
NickTeam17
6 years agoFrequent Visitor
Median value calculation
I am calculating the median value for some weekly game sales in the table below: Game Week 1 Week 2 Week 3 Week 4 Week 5 Worms 2 4 6 8 10 The Escapists 3 6 9 12 15 Overcoo...
- 6 years ago
NickTeam17 - If you unpivot your week columns so that you end up with:
Game,Week,Value
Then you can create a single measure to calculate your median and then you would put Game and Median into a visual together.
Greg_Deckler
6 years agoCommunity Champion
NickTeam17 - If you unpivot your week columns so that you end up with:
Game,Week,Value
Then you can create a single measure to calculate your median and then you would put Game and Median into a visual together.