Forum Discussion
Is this a bug?
I have a short post on this topic, perhaps it will help you get through it:
Well, for the table component, it looks like you are 153710.05 off (lower). It's all about context. The waterfall chart has the correct total by my calculation. The important thing to remember about the table visualization is that with measures, it is not simply totaling the individual components but rather re-evaluating the measure in the context of all rows. I do not believe that is how the waterfall chart works because of the type of visual display it renders, that wouldn't make sense. So, if you have some negative numbers in your data, your table visualization would account for those and possibly throw off your numbers whereas with the waterfall chart it would not? Can't be certain without the raw data.
Hello,
Thank you for your time.
That's right because a label with the measure has the same value as the table. But I have another measure that works in reverse mode. The total (label too) is bigger for the table than the waterfall chart. Querying the data in the source database with the filters that affects context (only year and proyection), both cases the right values are shown in the waterfall chart component:
Thanks.
I have a short post on this topic, perhaps it will help you get through it:
Thanks a lot, this is just my case.
