I am using Tableau 10.5 and I have a duplicated dataset. Tableau is aggregating the dataset. The data is dynamic and it has same set of data for the same dates. I need to uniquely pick the values based on Time Commitment i.e. if on 19th May, 2019 there are two values for Time Commitment then it should give a result set as 1.4(1+0.4) instead of 2.8. Find the attached Tableau workbook and dataset.
Problem:
Below is the outcome needed:
6 answers
Hi Ankit
you need to include "Time Commitment" in LOD in your calculation field as shown below\
only unique:{ FIXED [Resource Name],[Assignment ID],[Project Name],[Date],[Time Commitment] : MAX([Time Commitment])}Attached twbx and new revised dataset with additional entries
Hope something like this helps
GP
