Forum Discussion
Percentage does not equal numerator / denominator
I need some help with a %. There are three objects here. One % on a card, one showing the numerator & denominator, and a text box with a target. 488 / 1185 = 41.2%....not 43%. I've validated they are...
Anonymous change the topN filter and manually select the filter value.
I put those two items in a table and got what I would expect. It appears to be an issue with the card object that shows the 43%.
Anonymous change the topN filter and manually select the filter value.
I went to change the Timeseries_DT filter to basic filtering (which defaulted to the earliest date). I changed to the last date, and it didn't change. That's strange. I poked around and the issue is that most tables have a "Timeseries_DT" field that is the date of every row. Somehow, the % card was pulling from another table's "Timeseries_DT" column. I made it the correct one, and it works!
Thank you for helping me back up and work this issue out!