2 Replies Latest reply on Apr 8, 2017 10:49 AM by Glenn Kuly

    Calculatings Number of Weekdays In A Month Using a Parameter

    Glenn Kuly

      I am trying to calculate total monthly sales per weekday (and hour), using a parameter to select a chosen month.

       

      Thanks to Tom W  for demonstrating how to achieve this by using a filter to select the month, as shown below. But I'm stuck on how I can use a parameter rather than a filter. Using a CASE statement or IF [Date (Month/Year)] = [Date (Months)] THEN COUNTD([Date1]) END isn't possible (i.e. mixing aggregate and non-aggregate elements).

       

      Can someone suggest an approach that will work? I've attached a sample workbook (Tableau Desktop 10.1).

       

      -- Glenn

       

      Untitled.png

       

      calculate the number of each weekday in a chosen month