3 Replies Latest reply on Jul 10, 2018 12:06 PM by Deepak Rai

    How do you fill in missing data to display zeroes, instead of not showing a value at all?

    Phil R

      I am trying to display all values between the lowest and highest value, so that they can be displayed as zeroes in a viz. In the attached workbook, I need to display a value for 3, 6, 7, 8, and show zeroes for those values.

      Background on the data: I have user_ids that visit a website, so there is a visit_date and visit_count:

         

      user_idvisit_datevisit_count
      12346/21/20181
      12346/2/20181
      12346/15/20183
      55547/9/20181
      55546/25/20181
      55546/15/20181
      55546/16/20181

       

      I created two calculations:

      1.) c_Total Visit Count for User ID = {FIXED [User Id] : SUM([Visit Count])}    <<< This gets converted to a discrete dimension, because I want to 'bucket' the member counts by these values.

      2.) c_Distinct User ID Count = COUNTD([User Id]) <<< This is the measure getting 'bucketed' by the Total Visit Count.

       

      Thanks!