Thanks for this wonderful solution but when I filter data by timestamp, let say last 7 days, person D do not have any data for last 7 days so his row become blank (show empty rows and columns is on). Table really needs to show crosses where people haven't expressed that emotion rather than hiding the rows and columns.
Is there any way to display crosses where we have empty rows due to data filtered out.
I understand this is quite a tricky problem but do have solution to fix this?
i have created a parameter with name Select Week
Created calculated field with name T/F (copy)
ISNULL(LOOKUP(SUM(IF DATEDIFF('week',[Timestamp],[Select Week]) = 0 THEN [Number of Records] END),0))
please check attached workbook sheet 3
test.twbx 36.3 KB