So I have a data set that looks basically like this:
And I want to produce a card that counts the number of chats, emails, web, and text tickets by date, but also the number of calls by date. Then I need to sum up all interaction types by date.
So for the above example, I would want this as the output:
Can anyone provide some tips on how I might achieve this with cards? Do I need to create a custom data set to somehow pivot this data into this format? How would you deal with the multiple date columns?