Forum Discussion
hoffsquig
3 years agoRegular Visitor
table value doesn't match card value for simple measure
Hey all. this "issue" is driving me crazy. I have a measure that contains an IF statement. It is set to 0 or 1 depending if the measure meets a goal. These rates are calculated by month with a r...
hoffsquig
3 years agoRegular Visitor
So, I guess I dont know how to accomplish this. The real issue is that my time series line chart doesn't match the Gauge. The gauge is based on a measure
FleetHealthRating = (MCGood + AttritionGood + TNMCMGood) / 3.
I place the same FleetHealthRating measure in a line chart, and the monthly values (context?) dont match. I dont understand context all too well, but it feels like the two should at least match, even if they're wrong overall.
I thought the table in the question would above help me work around it, but I'll abandon that idea. See below.
hoffsquig
3 years agoRegular Visitor
it's clearly all context issues on some of my measures. I'll double check them all. I probably didn't use the calculate function correctly