2 Replies Latest reply on Jul 16, 2018 7:24 AM by Edward Ostrovsky

    Interactive dashboard with customization fields

    Edward Ostrovsky

      I am trying to figure out the percentages of clients who have signed up above certain thresholds for a time period of choosing.

       

      The thresholds below are provided as examples, but I would like to have the ability to input whatever threshold I like:

      % of clients >= $100 in May 2018

      % of clients >= $500 in June 2018

      % of clients >= $1200 YTD

      % of clients >= $2000 in 2017

       

      Sample data:

       

      user_idregistration_dateamount
      a3/1/2018100
      b4/2/2018300
      c5/3/2018600
      d5/4/2018900
      e6/5/20181100
      f6/6/20181300
      g9/7/20172000

       

      How would I create an interactive sheet that allows me to input my own threshold so that it spits out the % of clients above that threshold, and input a time period of my choosing?