how to I get dates on the x axis to order form Jan- Dec?
Comments
-
Add the date field that represents your X-axis value to the Sort criteria in edit mode, select Ascending, and depending on your card you'll need to determine whether it's No Aggregation or which Aggregation to use. Most likely, No Aggregation.
If the date value you are uising is not a Date data type, then you may want to consider fixing that through your data load process, or creating a Beast Mode calc using a CASE function to map Jan-Dec text values to a numeric sortable value, and drop that into the Sort criteria.
**Say thank you by clicking the 'thumbs up'
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"1 -
Hi there!
Thank you! So yes my Data isn`t date typed and cannot be due to the compariosn between 2016 and 2015 data. I was wondering if you could give a more detailed description on how to get beast mode to sort these values the way I am asking.
Thank you so much your help has been great thus far!
0 -
Can you post an example of the format that your date field values are showing? Do they look like properly formatted dates, but they didn't pickup a date data type during import, or are they representative of dates but not in a date format (ex: 20160720).
**Say thank you by clicking the 'thumbs up'
**Be sure to select the answer that represents the best solution and mark as "Accept as Solution"0 -
If you're dealing with a handful (less than 20) labels, you can write a case statement in beast mode that orders them appropriately. For example
case
when `frustrating_date_field` = 'JanTwentySixteen' then 1
when `frustrating_date_field` = 'FebTwentySixteen' then 2
etc...
end
You can then sort on this beast mode (ascending) while leaving your date field in the x axis.
On the other hand you can use the like function if you have too many labels to categorize one-by-one, but still have a pattern. For example
case
when `frustrating_date_field` like '%JanTwentySixteen%' then 1
when `frustrating_date_field` like '%FebTwentySixteen%' then 2
etc...
end
1 -
@rileyallison, tagging you to check out the latest replies.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive