1 Reply Latest reply: Jul 12, 2014 7:51 AM by Stefan Wühl RSS

    Create Chart expression that ignores the dimension

      Hi all,

      I have a graph with the following structure:

      Dimension - Hour

      Expression - Count(distinct SalesDate)

      The problem is the following: In my chart, I get in each Hour the number of distinct days that a sale occured in the appropriate hour.

      My goal is: to get the total number of days according to the filter. If I filter 12/07/14 and 11/07/14 I want to Expression in the chart to be 2 in every one of the hours ignoring wether or not a sale occured in that hour.

      Can anyone help me?

      My failed attempts: count(total distinct(SalesDate)) -failed because filtering one specific dates will not change this count

                                   count(distinct {<Hour=>} SalesDate) - failes becuse the values are the same as in Count(distinct SalesDate).

       

      Thanks!!!!