4 Replies Latest reply: Jul 15, 2015 2:57 AM by Sahir Ahmed RSS

    HELP! Create a CAGR KPI or representation for multiple charts in Sense

      Hi guys!

      I am creating an app that contains multiple barcharts presenting different company measures on the same dimension which is date shown in the last 6 months. So all charts have the same dates. However I would like to show the CAGR (compound anual growth rate) but over the last 6 months. Now I know how to calculate the CAGR but because all of the charts have different measures I must manually feed the formula in to subtitles or something for representing it. Is there any way too have like a KPI dashboard that adjust the CAGR for every time i click on of the bar charts? If not is there any other smart way to represent this nicely, any tips are welcome. Thanks!

       

      // Sahir