Creating a date range in Beast Mode

Options

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

Tagged:

Best Answer

  • ColemenWilson
    edited June 27 Answer ✓
    Options

    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.

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

Answers

  • trafalger
    Options

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

  • nmizzell
    nmizzell Contributor
    Options

    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
    Options

    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
    Options

    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
    Options
  • ColemenWilson
    edited June 27 Answer ✓
    Options

    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.

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

  • trafalger
    Options

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