Skip to content

    • Beast Mode

    Beast Mode

    Creating a date range in Beast Mode

    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:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      edited June 2024 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

    • Coach

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

    • 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

    • Coach
      edited June 2024
      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.

    • 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.

    • Contributor
      week grouping.xlsx
    • Coach
      edited June 2024 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

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

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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories