Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm trying to do a price analysis on actual vs agreed prices.
So I would like the dimension to be a range of prices and the expression to count the qty of products sold at that price.
I used the class function to calculate the range for the dimension: class(salesvalue/salesqty, vRange).
I'd like to have 2 expressions as bars:
count(salesvalue/salesqty)
count(agreedvalue/agreedqty)
I can't get the 2nd expression to appear on the chart. I'm assuming it's because of my dimension since I only used salesvalue/salesqty to determine the range for the dimension.
Any help would be much appreciated. Thanks!
all the fields in the same table? if they are in different tables, is there any link between the tables?
share a sample app, then it would be easy to suggest rather than guessing...
Do you have a sample you can share?
I somehow managed to get the second expression to show but it's not showing the correct data.
Please check the attachment above ^
Thanks!