Sorting Series AND Date (X Axis)
I'm trying to have the series' legend sorted alphabetically (which almost every other system automatically does) AND show the dates on the X axis in order (January before February before March...) (which should be pretty standard).
I can't seem to figure this out. My chart either sorts the legend alphabetically but puts the months in random order, or it puts the dates in order but doesn't sort the series.
Any thoughts? Thanks
Comments
-
Hi,
Anyone can help out with this request?
Thanks,
0 -
You should be able to move multiple fields into the "Sorting" section of the analyzer. If you put your data field first and then add your series under it, does that accomplish what you want to do? Can you show me a screenshot of your analyzer if you are still having trouble?
0 -
Thanks ST_-Superman-_,
I tried it both ways, sorting by the data series first and then by date (this puts the series in alphabetical order, but the months are Feb, mar, Jan, Apr, May, Jun) and the other way around, date first and then by the data series. That puts the months in the right order, but the series is not in alphabetical order. See below.
and
Thank you.
0 -
Is your Date field formatted as a Date? I'm sorry, I couldn't view the image that you attached.
1
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 636 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 701 Automate
- 182 Apps
- 457 APIs & Domo Developer
- 52 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive