Months in card not in order
I have a card for filled positions and it was working all fine. All of a sudden after updating Dec yesterday, the order of the months changed to a random order. I tried sorting the month, but it still did not correct. Any help is much appreciated.
Thanks,
Gunjan
Best Answers
-
You should create two beast modes, one that will be used for displaying the month name in the pivot table and one for the sorting.
Create a beast mode called MonthName that contains a formula like this: MONTHNAME(`Offer Accepted`) and drag this into your columns field.
Create another beast mode called MonthNumber that contains a formula like this MONTH(`Offer Accepted`) and drag this into your sorting section.
This should get it to display how you want.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
To clarify, the issue is that you're having is that your beast mode is always returning NULL now as the
MONTH
function returns a number 1-12 based on the month.MONTHNAME
returns the name of the month. Instead of using a case statement to attempt to compare the value to the month names just use MONTH(`Offer Accepted`)**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
@Gunjan ideally you would group the table by month and the COLUMNS would include a date rather than text as you are doing.
Saying that if you added a beastmode with a case statement like
case when month = 'Jan' then 1
when month = 'Feb' then 2
etc etc
If you stick that in the order by rather than the String month it may work.
0 -
This is likely because you're sorting based on the Year first and also the month by name. You'll want to sort by the numerical version of the month first and then the year.
You can use the
MONTH
function to get the month number. Alternatively you can use theLAST_DAY
to get the last day of a month and sort on that instead of the year and the month.LAST_DAY(`DATE`)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi,
Thanks for your reply ..:-)
I changed my beastmode to
Case when MONTH(`Offer Accepted`) = 'Jan' then 1
when MONTH(`Offer Accepted`) = 'Feb' then 2
Now my table looks like this. LOL! Not sure what am I doing wrong
0 -
You should create two beast modes, one that will be used for displaying the month name in the pivot table and one for the sorting.
Create a beast mode called MonthName that contains a formula like this: MONTHNAME(`Offer Accepted`) and drag this into your columns field.
Create another beast mode called MonthNumber that contains a formula like this MONTH(`Offer Accepted`) and drag this into your sorting section.
This should get it to display how you want.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
To clarify, the issue is that you're having is that your beast mode is always returning NULL now as the
MONTH
function returns a number 1-12 based on the month.MONTHNAME
returns the name of the month. Instead of using a case statement to attempt to compare the value to the month names just use MONTH(`Offer Accepted`)**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**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
- 108 Community Announcements
- 4.8K Archive