I am attempting to build a freeform table in CJA that tracks how many events where disposition = sent a specific person had per day, over a week or month.
I have created a derived field which accurately does this using logic: case when disposition = sent, set = 1, then summarizing on person.
If I pull the derived dimension into a freeform table with the date range being a week (ex 9/1-9/7), then it will accurately tell me how many people had 1, 2, 3, etc sent dispositions over the course of the whole week. The problem is, I want to see specifically, how many sent dispositions a person had per day, and then see multiple days over the course of the week in the same table (see screenshot attached for context of what I want the table to look like, with day as the rows and the columns being possibilities of number of sent dispositions). However, when I do this, instead of aggregating a person's sent dispositions over the specific days, it is aggregating them over the week set in the date range.
Is there a way I can have this derived field apply to only one day, while also seeing it within the same table as other days?
