4 Replies Latest reply: Apr 18, 2017 11:20 AM by Dave Melillo RSS

    YoY Analysis in Bar Chart

    Dave Melillo

      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!

       

      Q12345.PNG