1 of 1 people found this helpful
Take Date out of the level of detail and the sort works fine.
Thanks for the tip - but date is required at level of detail to make the daily scores accurate.
Team scores are adjusted depending upon how many team members completed the challenge in any one day.
IF SUM([Raw Score - Change Scenery]) >= 2 THEN [Team Challenge Scores for 2 or more]
ELSEIF SUM([Raw Score - Change Scenery]) >= 1 THEN [Team Challenge Scores for 1 only]
If you aggregate across all days then the team scores reduce to a maximum of 5 - which is the value of the [Team Challenge Scores for 2 or more] parameter.
Is there some sort of Window_sum i can use in the situation to sort by a table calc?
Did you ever get a solution to this? I am finding that the Tableau sorting is not as intuitive as I'd like. We'd like user's to add / remove multiple metrics on the fly and sort as needed. Every time I try to sort based on metric values and there is more than one dimension and more than one metric the sorting results dont look sorted. I've looked at the Tableau cbt for sorting and I tried a couple of things, but no luck.
Anyways, I was wondering what kind of workable solution that you came up with.
Alas, no solution for problem above. Had to live with a manual sort and republish every day during the competition.
I did however come across something recently that has helped with a different sorting challenge.
This article from freakalytics shows how to sort dimensions within dimensions to sort independently within levels.