Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?