1 Reply Latest reply on Jun 27, 2017 7:01 PM by arvindgarg

    Need to show a single KPI to represent total subscribers signing up in last 30 days

    Sanisa Bhushan

      I have a table with rows of certain email id (email ids of people subscribing to our product) and their respective start date (start date of subscribing)

      The table looks some thing like this:

      Email
      Startdate (dd/mm/yyyy)

      m.dr***@keh***.de

      24/04/2017

      michael@*****.name

      9/05/2017

      christin*****@me******.ch

      12/05/2017

      evangelos*******@gmail.com

      7/06/2017

      gerald*****@web.de

      10/06/2017

      anka*****@gmx.de

      12/06/2017

      prie*******@gmx.de

      12/06/2017

      dor*****@web.de

      18/06/2017
      digi****@springer.com25/06/2017

       

       

      Let's say my 30-day cycle is from 27th May to 25th June.

      Now I want to single KPI (one single number) representing count of email id in last 30 days which should be '6'.

       

      I followed the following steps:

      1. I created a calculated parameter count_email:  COUNT([Email])

      2. dragged the dimension 'Startdate' to columns and changed it to day

      3. dragged the count_email measure to rows and added quick table calculation of 'RUNNING TOTAL'

      4. dragged the dimension 'Startdate' to filters -> selected relative filters -> to last 30 days

       

      It shows me a line graph like this (the numbers are the actual numbers):

       

      Screen Shot 2017-06-27 at 3.01.55 PM.png

      Although I only want one single number i.e. 3864 which is the sum of total number of subscription on 31st day.

      I want to include this KPI in my dashboard.

       

      Something like this:

      Screen Shot 2017-06-27 at 3.04.59 PM.png

      And if I hover over the 31st day value i.e. 3864 and select 'keep only' it shows me a number which is the count of only 31st day and not sum till 31st day.

      Screen Shot 2017-06-27 at 3.08.01 PM.png

      Screen Shot 2017-06-27 at 3.08.04 PM.png

      How can I achieve what I want?

       

      P.S. I am not allowed to share the workbook.