
1. Re: Calculation logic needed
Michel Caissie Aug 2, 2016 3:01 PM (in response to Jessy Cool)Jessy,
You will have to make a calculated field for each of your column .Each one sums the number of rows where the rating value correspond to the column rating.
see in the attached
Michel

ratings count scenario.twbx 14.6 KB


2. Re: Calculation logic needed
Nick Zhao Aug 2, 2016 3:19 PM (in response to Michel Caissie)I think the OP meant counting the entries of distinctive ratings on distinctive days. For example, rating 1 on the first day gets 3 counting.
See the attached.

ratings count scenario.twbx 17.9 KB


3. Re: Calculation logic needed
Michel Caissie Aug 3, 2016 8:23 AM (in response to Nick Zhao)Nick,
I have a tendency to overcomplicate things, thanks for putting me back on track
And though my solution returns the expected values, it's much more simple to simply convert Ratings as Discret values as you did. Actually I would even convert is as a Dimension.
Here is a little addon, to add a zero where you have missing data. By adding an index on the detail shelf Tableau will generate the missing marks.