10 Replies Latest reply on May 29, 2014 12:22 PM by Matt Lutton

    How do I calculate percentages between different measures

    Renata Kuczynska

      The data consists of records with status types and dates, transaction ids(sourceAppID) , province and agent name. I need to know the count of apps in each status - easy to do and what is the proportion between each status - so, for example if I have 100 apps and 50 commits the next column I would like to see is the approval ratio of 50%. I have managed to do it once, based on some post but the visual is not good and I had to hide the status data - used it as a filter and have a made a mess of it. Worst of all can't replicate it for funded over commits.

      The workbook attached has sample data and the dashboard has an image from excel where I have created a final result sample. Thank you for your help.