Thanks a lot for your quick reply. My apologies, my question was unclear. I need to aggregate the data by weekday in the view. I would like to show the sum of all actions for each weekday. My issue is that when I do this, as there are no actions in the records for Saturday and Sunday, the columns do not show up, even when using "Show Missing Values".
Thanks a lot for your help.
Yep, find my approach based on "scaffolding" below and stored in attached workbook version 9.3
Scaffolding for dummy's;) add a datasource with all required values (mon-sunday). Bring this datasource in as first which will be declared as "primary datasource".
Blend your datasource with all transaction data and blend it based on weekdays....
Scaffolding.twbx 30.6 KB