Adding data for days of the week for multiple weeks.

Options
Goodeman
Goodeman Member
edited June 19 in Charting

I am trying to recreate the below that I do in Excel. These are call counts pulled in from counting the "add timestamp field". I also created a day of the week and every 30 mins in beast mode.

Best Answer

  • david_cunningham
    Answer ✓
    Options

    Something like this is going to be fairly difficult to do in a single card. Reason being is that the way you would have to structure your data would be very particular to this individual visualization.

    Rather than trying to create a single visualization, I would recommend splitting it out into several cards that you can then display side by side (one for each day of the week).

    You can achieve this using a pivot table card. Note that if you want to have time on rows like you show above, you'll need to handle the formatting/grouping in your ETL. You'll also want to define a sort order for the time. I would recommend using military time to make this easier.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Answers

  • david_cunningham
    Answer ✓
    Options

    Something like this is going to be fairly difficult to do in a single card. Reason being is that the way you would have to structure your data would be very particular to this individual visualization.

    Rather than trying to create a single visualization, I would recommend splitting it out into several cards that you can then display side by side (one for each day of the week).

    You can achieve this using a pivot table card. Note that if you want to have time on rows like you show above, you'll need to handle the formatting/grouping in your ETL. You'll also want to define a sort order for the time. I would recommend using military time to make this easier.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • Goodeman
    Goodeman Member
    Options

    Thank for the response David! I will experiment with both options.