YoY Percentage Delta Calculation in Nested Bar Charts

user19789
user19789
in Magic ETL

Hello,

 

Is there a way to calculate on the fly the percentage delta within a nested bar chart? Instead of displaying year's totals, I would like to disply the perscentage deltas in the graph below.

 

Any ideas?

 

TestData.jpg

 

Thanks!

 

 

Comments

  • Cartergan
    Cartergan Contributor

    You can do a beast mode calculation finding the delta between the two years and use that as your Y value. You can than change the format of the number to display as a percentage. Let me know if this works for you!

  • user19789
    user19789

    I have tried two of the examples online (c-p/p), but not joy:

     

    (SUM(CASE WHEN YEAR(`CloseDate`) = YEAR('NOW') THEN `OpportunityAmount__c` ELSE 0 END)-SUM(CASE WHEN YEAR(`CloseDate`)= YEAR(DATE_SUB('NOW', INTERVAL 1 YEAR))AND month(`CloseDate`) <= month('NOW') THEN `OpportunityAmount__c` ELSE 0 END)) / SUM(CASE WHEN YEAR(`CloseDate`)= YEAR(DATE_SUB('NOW', INTERVAL 1 YEAR)) AND month(`CloseDate`) <= month('NOW') THEN `OpportunityAmount__c` ELSE 0 END)

  • user19789
    user19789

    I believe there is not really a way to do what I want to do using this type of graph.

     

    Agree?

Categories