Hello there. I have this LOD calc:
({ INCLUDE [Current Serial Number]: (MAX([DELTA HOURS])*0.82)/(sum([Number of Records]))})
I get good values:
But when i remove the Serial numbers and put as calc Avg(LODCALC), i do not get the averages, i get a higher value. What am i missing?
Without seeing the exact details (i.e. a packaged workbook), it is difficult to be precise. However, the INCLUDE LoD is affected by the fields in the view. If they change, the result will change. It is probably giving you "averages," just not the averages of the values you expect.
If you attach a packaged workbook (.twbx), we can probably help more. If you have confidential data, please see Anonymize your Tableau Package Data for Sharing |Tableau Support Community.
