6 Replies Latest reply on Aug 13, 2018 1:01 PM by pablo.escalera

    Need to count distinct names by week

    pablo.escalera

      Hi!

      I have a dataset that includes columns for NAME, LOGIN DATE. There is an entry for NAME+LOGIN DATE every time NAME has logged in. I am trying to create a stacked bar chart that displays as a percentage the count of distinct logins of NAME that have logged in per week of LOGIN DATE. 

      I created a calculated field:

      COUNTD([Name])/TOTAL(COUNTD([Name]))

      and placed it in the Rows shelf and week(login date) in columns, it gets me close but not exactly what I need.

      Would appreciate any direction!

      Thanks!