It looks like the LOD is aggregating over a number of records - I see that Duration is a calculated field - are you picking up multiple records with that caclutaion and aggregating them with avg or max or something else -
if so try taking repalcing the Sum(duration) in your LOD expression with the detailed forumla in your Duration formula
Let me know if this helps
The Duration field is a DATEDIFF in months between two dates. I tried to add it in the LOD expression and same result.
Vanessa - this would be easier if you shared your workbook as a twbx file with the data included - or at least a protion of the data
The way the LOD expression works is that it creates a permutation of the the 2 dimensions that precede the colon (:) and then aggregates them by what follows the colon - in your case you are creating permutations of Name and Rank - then you are Summing the "Duration(s)" at that level -
You then put the cacluation on the vis and it will be aggrgated again if there are multiples at that point - you have made it discrete and it is a little difficult to see what is going on from the image
I cannot upload the data because they are company's property so I cannot upload a workbook. The datasources are multiple tables from a database and are joined with a primary key between them. The Name and Rank are from different tables and duration is calculated from dates given in also different table.How can I make tableau not aggregate the total of durations (Years in Rank)?