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
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 511 Automate
- 114 Apps
- 389 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive