3 Replies Latest reply on Apr 4, 2017 11:35 AM by Joshua Milligan

    "Show Empty Rows" for dates showing all dates outside of filter

    David Lam

      I have a very simple text table that has locations across the top, dates on the left and counts as the values.

       

      I have current year and current month filters so that the data always shows this month. What I want is to show all days within the month even if there are no counts. Quick research pointed me towards "Show Empty Rows" but the problem is I am getting all missing dates. For example, today is the 4th day of April. I should see just April days (1 - 30) but instead get all days in the data set (1-28 for Feb, 1-31 for March, etc)