I have a line chart that shows the overall total plus the individual items that make up that total. a filter contains each item to filter on.
when i select an item from that filter, i get that item, PLUS, an unwanted zero value of another item. I have unchecked "include Zero Values", i have set up a dynamic range for min/max as 10% of the min value to not display yet it still shows up, I have tried a if() to suppress the value, manually set the value to a number with num() in case it is not being read as a number, divided by 1, divided by 0, to just see if it'll show an error, and even if that value is 0, set to null. All have not done the trick.
I added a screenshot that shows a filtered item (purchase) and the resulting 0 (cost of service).
This is a basic expression, too.
total_transaction for item Purchase = sum({<ITEM={"Purch"}>}Amount)
total_transaction= sum(Amount)
Another line chart that displays the correct behavior is an average.
Total_Transaction for item purchase = sum({<ITEM={"Purch"}>}Amount) / sum(Amount)
even after recreating this line chart, adding on that divisor portion to the end, it does not do the needed behavior.
Any idea to why this is occurring?
Everything not saved will be lost
— Nintendo Quit screen message
