Adding data for days of the week for multiple weeks.

Goodeman · June 19

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.

david_cunningham · June 25

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 · June 25

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.

Goodeman · June 25

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

Adding data for days of the week for multiple weeks.

Best Answer

Answers

Categories