2 Replies Latest reply on Jun 14, 2016 4:09 AM by Ankit Agarwal

    Count Number of Days in Month, Quarter, Year

    Ed Kukec

      Hi All,

       

      I have a calculated field that essentially is a numerator divided by a denominator and the denominator ends up being the number of days in a time period. I have a filter that people can aggregate information for Yearly, Quarterly and Monthly but whenever I get new data loaded into our database we always get one new month so the denominator for the monthly is always okay but when I have incomplete years and quarters the denominator isn't correct so I was wondering if Tableau has the ability to count the number of distinct days in a time period, ie year, quarter and monthly? My numerator might be 0 for a month, quarter or year but I always need the denominator to count the correct number of days in that time period.

       

      Any thoughts?

       

      Thanks,

      Ed