Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field called Opp Create Year
I want to make a bar chart that shows a bar for $$ each month in 2017, with another bar next to each month for the same period in 2016
I put a sample below of what I was able to put together. I have two expressions in the chart:
=sum({<[Upsell ARR (converted)]={">0"}, [Opp Created Year] = {'2017'}>}[Upsell ARR (converted)])
=sum({<[Upsell ARR (converted)]={">0"}, [Opp Created Year] = {'2016'}>}[Upsell ARR (converted)])
I am close but this is not what I want. I would like to see the January 2016 bar next to the January 2017 bar and so on ..
Any help is appreciated!
In order for this to work, you would need to use month numbers/names (not month-year) for your dimension - you can get this value by using the Month() function.
May be sort it by Month field.
Didnt work. Thank you though
In order for this to work, you would need to use month numbers/names (not month-year) for your dimension - you can get this value by using the Month() function.
Good catch! Thank you very much