2 Replies Latest reply on Dec 11, 2013 1:31 PM by Benjamin Fox

    Static count with dimensional slice

    Benjamin Fox

      I'm having trouble putting the pieces together, but feel like this should be pretty simple. What I'd like to do is add the first row of initial attempts and then from that total count (1678789) get a percent from all other successes on each row. Then I'd like to make that a stacked bar graph showing that x% passed when it was first ran, Y% of total attempts passed on 1st renewal etc... It should get pretty close to 100%

      Picture explanation.jpg

      I'm basically trying to keep a global count, while dicing that count into dimensions. I'm thinking the table calculations is my best bet, but I can't figure out how to add one in and use the total count.

       

      I've attached some data, and a picture to try to show what I'm looking to do. Anyone have any suggestions?

      Thank you!