I have a dashboard that pulls in data from 13 different sheets. In most cases everything is updating as expected; however there are two sheets in which the number on the dashboard displays differently than on the sheet itself. The calculation I am using takes the number of widgets, multiplies it by a per unit cost and then displays the total amount. I have 303 widgets at a cost of $0.167 per widget, which should total $50.60. On the sheet this is what displays, but on the dashboard it shows as $49.39. If I bring just this sheet onto an empty dashboard it calculates fine. It's almost as if Tableau isn't calculating the same when multiple sheets are brought in. The filters and everything are the same. There is seemingly no reason these two values should be different.
Appreciate any suggestions or help anyone can provide.
DASHBOARD VIEW
SHEET VIEW
Just burnt an hour or more on this same thing. My sheet shows a simple LOD calculation totaling 77; going to the dashboard shows 34... if I remove and replace the sheet, it's back to 77. If I publish to Tableau Public, it reverts to 34. It's as if some underlying formulae aren't being updated.
In my case, FWIW, There's
govt_as_c_anyplans which is
if([govt_as_c_ngovtplans]>0) THEN 1
ELSE 0
END
And govt_as_c_ngovtplans is
{FIXED [Govt Longname]: countd([as_response_id])}
I'll flag one annoyance I have seen is weird handling of the underlying named tables in the related table model. The renames of inner tables - especially of common tables that are linked twice (e.g. "strategies" and "categories" are the same table, but I can't link auth_detail and fin_detail to the SAME table - it's purely a tree). This creates some weird naming habits in the formulae....
Does this help? Same issue, here.
-Mike
