2 Replies Latest reply: May 18, 2017 4:58 AM by Luis Carmona Martínez RSS

    Count distinct Stores Openend per Day - Regardless of Time Dimension

    Luis Carmona Martínez

      Hi,

       

      I have a dataset of sales from different Stores and those related to the customers ID, product Id and so on... and I need to be able to SUM the number shops that have made any sales per day. 

       

      I have 100 Stores (Maximum)

       

      If I use the function COUNT (Distinct "Store Name) the result will depend on the dimension, so:

       

      For this Example supose that The month only have "3 Days"

       

      Day    Month  Count (Disntinct "Store Names")

       

      1          1         100

      2          1         95

      3          1         80

       

      If I take out Dimension Day from the above table, then  Count (Distinct "Store Names") will take account the month as a whole and the result will be 100.

       

      Month  Count (Disntinct "Store Names")

      1         100

      1         95

      1         80

       

      Expected Result:

       

      - I need to get the sume of Number Stores Open Every Day:  100 +95 +80    Regardless of the dimension I use, I need this function to be limitd to count per day dimension.

       

      Any help???