Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there
Does anyone know how to add a computed field to an existing bar chart. I.e i have an input tax bar, I plan to add an output tax bar next to the bar chart (I have data for both tables), now I want to create an additional bar called nett which is composed of Output-Input is this possible?
Using no dimensions and three expressions, this should be possible:
=Sum(InputTax)
=Sum(OutputTax)
=column(1)-column(2)
Using no dimensions and three expressions, this should be possible:
=Sum(InputTax)
=Sum(OutputTax)
=column(1)-column(2)
Hi thanks for the response, last question if you can help ![]()
I have a list of customers and I want to show various customer information in a pie chart but im getting an error stating that pie chart cannot display negative values or zeros
Ok, what's your question then?
I want to spilt customers (valid and non valid) on a pie chart, but I get the error "The chart is not displayed because it contains only negatives or zero values" when I created my valid and non valid measures. and tried to use the total customers as my dimension.
If you have issues like that, you need to post the dimension and expressions used in your charts, any settings you have modified and potentially some details about your data model.
Most of the time the easiest way tpo provide these informations is attaching a small sample QVW to your post.