Hello Siraj Samsudeen,
Does the attached get you close to the desired view in a Dashboard? See Dashboard 1
I utilized the calculation:
If window_min(sum([Net Score]))=Sum([Net Score]) then "Selected" end
In the primary data source and then select this as a filter to show only "Selected" with the Attribute and the Recommendation on the Rows shelf. Then put both views in a common dashboard.
Hope this helps,
Thanks a lot for your response and the pointers to getting this computed in Tableau.
Comparing your calculation to my calculation, the only change I need to do in my calculation is to return the same value 'Selected' instead of returning Attribute value. However, after doing and placing that field as a filter, I realized that I did not get the output you got. Then I have looked into the table calculation compute using setting, and it is set to Table down in your view. Since there is nothing on the down area of table, 'Attribute' and 'Recommendation' are both acting as partitioning fields. But if I set the computer using to 'Attribute' only in your view, all the 13 recommendations are displayed. To demonstrate this, I have added the filter field that you have created to the view to see and it returns 'Selected' only for all values. I am not sure why the addition of 'Recommendation' to the partitioning changes the results - can you please help me understand this? Also is there any impact of having the fields from a blended source in table calculation? I am attaching your TWBX file with the changes I have done to Sheet5.
Finding the lowest score_pvdh.twbx 108.5 KB
Hi Patrick, did you get a chance to look at this? I would appreciate your response.