Problems with Window Ranking Function
I am working in a CFD chart , to measure scrum metrics through the year for different squads.
For one specific Squad, the chart is changing the date order when presents on Area chart, as you can see on the image below.
Analising the scenario, it´s possible to identified that for this squad i had only information to one specific data category. Cause this, Domo was sorting the collumns in a wrong way.
Just to clarify , the numbers in the x-scale represent the week number, the category represent the momento when the status was moved on Scrum.
How can i fix this problem to avoid that Domo, change the order on Week Numbers when don´t have any number ?
I am using Window Ranking Function on Beast Mode and setting Sorting on Totals as expected to use in CFD.
The image above is from another Squad when the process works fine.
Regards Genival Junior