Creating a date range in Beast Mode

Raj_Rawat_84

Hi Community

So I have 6 months data, which i need to present in weekly using bar graph. When i do so its giving me as Week 1, Week 2 ..etc , but we need with a date range like from 1 Jan to 7 Jan

Can anyone please help me to create a beast mode to fix this issue

ColemenWilson

You can also switch the axis to be displayed as a date by going to: Admin > Company Settings > Company Overview > Cards > Week display > Week Dates (1/15/2001)

This will change all cards graphed by week to show as a date instead of week number.

If you don't want to do that, you can change from Week number to a custom date format by: Chart Properties > Category scale (x) > Date output format

I also like @trafalger solution if you want a range. The risk there is that sorting could get jacked up since it will be a string and may require additional formatting to sort properly.

If you are graphing by week, in my opinion the end date of the week isn't really needed.

trafalger

you could do like a CONCAT(MIN(YourDate), '-', MAX(YourDate)).

nmizzell

Hey Raj

Simply create an excel sheet with two columns:

1. every day sequentially that you want to include in your data.
2. The grouping for each of the days.

Add this excel sheet to your domo dataset and join your other data onto it to get values for the days and weeks with your custom grouping

trafalger

https://community-forums.domo.com/main/discussion/comment/96886#Comment_96886

If you're going to go this route, use the Domo Date Dimension so you don't have to keep updating the spreadsheet and calculate the groupings dynamically.

nmizzell

Here is an example dataset with the custom week grouping:

Feel free to change the week group from 1,2,3,… to whatever you want to be displayed on your bar chart.

nmizzell

week grouping.xlsx

ColemenWilson

You can also switch the axis to be displayed as a date by going to: Admin > Company Settings > Company Overview > Cards > Week display > Week Dates (1/15/2001)

This will change all cards graphed by week to show as a date instead of week number.

If you don't want to do that, you can change from Week number to a custom date format by: Chart Properties > Category scale (x) > Date output format

I also like @trafalger solution if you want a range. The risk there is that sorting could get jacked up since it will be a string and may require additional formatting to sort properly.

If you are graphing by week, in my opinion the end date of the week isn't really needed.

trafalger

https://community-forums.domo.com/main/discussion/comment/96891#Comment_96891

Whoa, I didn't know there was a Date output format there!