4 Replies Latest reply on Sep 11, 2018 7:47 AM by Eoghan Lyons

    % of Appearances in Period

    Eoghan Lyons

      I'm looking to calculate the percentage of appearances of a variable in a time period. I attach a workbook as an example.

       

      Using the sheet share as an example, and the viz in tooltip. I have made a chart of week to week points of top 15 products sold each day for the month of January. Hovering over the blue point in December 31, 2017 for a second, we see the average rank of those products and how often they appear at that rank. For example, Apple1 appears at Rank 1 for 2 of the days in that week.

       

      Is there a way of showing the percentage of days observed where this appears? E.g. 2 divided by 7 = 28%.

       

      Many thanks.