Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bar graph which shows the sum(Sales) for each country . Now I want two additional bars for each dimension that shows the average(Sales) and Max(Sales) for a specific country. however, adding (Max)sales or Avg (Sales) as an additional measure is giving the same value for all the Dimension(country), and not the average and max for that specific Dimension(Country).
I just created a matching bar chart and I am getting the expected result - each bar behaves as per the formula within. You may need to share a sample app or otherwise specify what's going on within your app in order to help pinpoint the issue.
First bar =(Sum({<[Country={'ProductNAme'}>}Salesvalue)) - Total for a specific product name
second bar = Max({$<[Country]>}Salesvalue)- Max of all the products for the specific country
Thirdbar = Avg({$<[Country]>}(Salesval)) Average of all the products for the specific country.
The first a bar gives the correct value, however average(third bar ) and max bar is giving me an incorrect answer
If you remove the set analysis from your second two bars, you should get the average and max for the country assuming that is your dimension for the chart.