6 Replies Latest reply on Nov 7, 2017 1:37 AM by Roisha Pal

    Bullet Chart

    Roisha Pal

      Hi Guys ,

       

      Attached is two excel one with sales person name, sales amount,created date, closed date, stage etc and second file has target amount. I am doing left join based on person. We dont have target for 2016 only 2017 I have target. I need to show in bullet chart sales amount and target amount in ref line by dimension person and year. Also need to show remaining sales%.

      Could anyone help me to create this as I am unable to show remaining sales% together in same chart?

       

      I have added different stages to data and I am getting double target displayed if i drag stage to color