Problems with Window Ranking Function
Dear friends,
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
Best Answer
-
Do you have anything in the sorting section of the chart properties? When your x-axis is not a date, Domo usually needs something in the sorting section to ensure that the x-axis is sorted in the way that you would want it to.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
Do you have anything in the sorting section of the chart properties? When your x-axis is not a date, Domo usually needs something in the sorting section to ensure that the x-axis is sorted in the way that you would want it to.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Hi @MarkSnodgrass ,
I included to fields, one of then has the order to show de category ( Done, FimDev, IncioDev, Criado )on the chart and the other i try to include the weeknumber.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive