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
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 465 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有