Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show two measure in bar chart.
i want to differentiate the Actual and Forecast value in one single bar chart with different color and Budget value in second bar with same color
Dataset:
one dimension and three measure
Dimension : Month-year
Measure : sum(Actual), sum(budget),sum(Forecast)
First six months i have to show actual value and next 6 months i have to forecast value in same bar (this i have achieved already,not in color code ), sum(Budget) is same for all 12 months.
Month Year | Actual | Budget | Forecast |
Apr-2019 | 2.80 | 3.07 | 2.45 |
May-2019 | 2.74 | 3.07 | 2.45 |
Jun-2019 | 2.93 | 3.07 | 2.45 |
Jul-2019 | 2.98 | 3.07 | 2.44 |
Aug-2019 | 3.03 | 3.07 | 2.44 |
Sep-2019 | 4.43 | 3.07 | 2.44 |
Oct-2019 | 3.07 | 2.97 | |
Nov-2019 | 3.07 | 2.97 | |
Dec-2019 | 3.07 | 2.97 | |
Jan-2019 | 3.07 | 3.18 | |
Feb-2019 | 3.07 | 3.18 | |
Mar-2019 | 3.07 | 3.18 |
Actual view :
Expected view in bar chart:
Basically i want to differentiate the Actual and Forecast value in one single bar chart with different color.
Can you please share the qvf
I create something like what you want.
First I created a new field, Revenue, based on Actual, or if no value, Forecast.
Then I create a Flag field called Actual which was 1, if Revenue contained Actual and 0 if it was based on Forecast.
Then to show the values you can use set analysis to create 3 measures which each have a different colour.
Can you please share the qvf
Thank you.