Here's one idea: Let's say the # of fans is stored in a Fans field. Then to calculate the number of days that you have data for, you'd do something like WINDOW_SUM(COUNT([Fans])). If you have your Category on the Rows shelf, the default calculation of Table (Across) will get you a count of all days with data per page, and partitioned by the Category.
Thanks so much!
Hi there, I have faced the same challenge. I came up with a Tableau model that is very close to an Excel pivot table and wrote a tutorial here: https://assemblinganalytics.com/post/tableau-pivot-table-element-build-an-excel-pivot-table-in-tableau/
The trick is to use interchanging columns leveraging parameters. This is a result I have in production and users do like it, you can of course further enhance by:
- Making more pleasing to the eyes
- Adding charts and graphs using the dashboard actions