0 Replies Latest reply: Jun 26, 2015 9:01 AM by Andrew Maton RSS

    Showing relative value of a percentage in a bar chart

      Hi - I have two values and a date dimension - Invited Renewals and Successful Renewals.  Successful will always be lower than invited, similar to that below:

       

      Date           Invited Renewals  Successful Renewals

      Mar  2015          400                    350

      Feb  2015          350                     297

      Jan   2015          410                    323

       

       

      I want to be able to show them as a stacked chart - I've been trying to show overlapping, relative, as a percentage, but I can't seem to find something that quite fits.  I've tried to get Successful as a percentage of Invited and show that, but the only way I can seem to be able to it is by taking Successful from Invited, and staking that on top of Successful - This gives me a cumulative amount of correct 'Invites' but obviously the numbers are all wrong when you mouse over - or does a fast change to a table. An image of that version is below: it looks right but its wrong! 

       

      In a perfect world I want to show a bar for  Invited Renewals, but be able to see Successful Renewals as  chunk of that. I cant add it on as a line in a combo, as I am also showing a conversion percentage metric (not shown).  I also don't want to make it a !00% stacked!  On mouseover in the chart below it might say  'Invited Renewals 400   Successful Renewals 350', rather than the current situation, where it says  'Invited Renewals 350 Successful Renewals 50' to get the cumulative figure to be right!

       

      Bar.PNG

      Any ideas?

       

      Cheers


      Andrew