5 Replies Latest reply on Aug 1, 2018 4:57 AM by Mehmet Mecikoglu

    Number of count in a partition

    Mehmet Mecikoglu

      Hello there,

       

      I'm relatively new to tableau and trying to make calculation using LOD expressions. I will try to explain the problem as clear as possible since i cant share the data im working with, sorry about that. I have User IDs and logtimes, whenever a user login a new log will be created. What i'm trying to do is to find min log time for each ID, so i can find new users coming each day.

       

       

      What i did so far was to create a calculated field to group IDs:

       

      Calculation 1: { INCLUDE [UserID]: MIN([logtime])} should return to min date for each ID so I can group up IDs by dates.

       

      When i put Calculation 1 and UserID in the row field I get bunch of IDs group by dates, exactly what I'm looking for. However, when I try to count these ID's tableau returns to number of whole rows in the table, not the number of rows in the partition (which shoud be date i guess). I also tried Size function but it also returned number of whole rows, not the size of the partition.

       

      Hope this explains the situation,

       

      Thanks in advance