Creating a date range in Beast Mode

Raj_Rawat_84
Raj_Rawat_84 Member
in Beast Mode

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

Screenshot 2024-06-27 at 10.37.22 PM.png

Tagged:

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited June 27 Answer ✓

    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

    Screenshot 2024-06-27 at 11.14.28 AM.png

    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.

    If I solved your problem, please select "yes" above

Answers

  • trafalger
    trafalger Coach

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

  • nmizzell
    nmizzell Contributor

    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
    trafalger Coach
    edited June 27
    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
    nmizzell Contributor

    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
    nmizzell Contributor
    week grouping.xlsx

  • ColemenWilson
    ColemenWilson Coach
    edited June 27 Answer ✓

    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

    Screenshot 2024-06-27 at 11.14.28 AM.png

    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.

    If I solved your problem, please select "yes" above

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

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

Categories