2 Replies Latest reply on Dec 8, 2018 8:06 PM by Christopher Swanson

    Distinct Count with Multiple Date Range Filters

    Christopher Swanson

      Hi Everyone,

       

      I've got a large collection of event data, and I want to count the number of distinct user ids for a few time ranges.  Basically I'm trying to answer the questions:

      How many unique users in the last hour?:

      How many unique users in the last day?

      ... 3 days?  7 days?  30 days?

       

      And I want to take those values and plot them such that I can visualize the curve, so as to project total unique users in a longer period.

       

      Any advice on how I'd do this?  Am I better off using a different tool (eg python) to calculate it first, and just use Tableau to plot the result?

       

      Thanks!

      Chris