Sorting a flex table on Total without affecting graph column date order
I have created a flex table that shows changes over time in the graph column, with another column to show series total. I want to be able to sort the series with the highest quantity at the top.
The issue is whenever I do this it causes my graph column to show the dates in the wrong order. So for example, if I have a graph that shows monthly data, instead of July, August, September, when I sort on Totals the graph will show September,July, August.
The Sort option seems to be effecting both the whole graph and the graph column, which is causing this issue.
Is there any way to sort the Flex Table without throwing off the graph column?
Comments
-
Hi @user11128,
You should be able to achieve this by sorting by date field first, then sort by the series total using an aggregation on SUM/COUNT/AVG as per your requirement
Cheers,
Eric
1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 87 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive