Forum Discussion

Zack92's avatar
Zack92
Icon for Helper III rankHelper III
2 years ago

How to show all the dates?

Hello,

I have a matrix table with dates as column headers, but some dates are missing. I really want to display all the dates, even if there's no data for some of them. Any ideas on how I can make this happen?

 

Thank you

Need Help
Show and Tell
Tips and Tricks

5 Replies

  • Irwan's avatar
    Irwan
    Icon for Super User rankSuper User
    2 years ago

    hello Zack92 

     

    select your down arrow in column value, there should be an option "Show items with no data". If there is no option in Date, it might be in down arrow in 'OffDays'.

     

     

    Hope this will help you.

    Thank you.

  • Zack92's avatar
    Zack92
    Icon for Helper III rankHelper III
    2 years ago

    Irwan 

    Thank you for the quick repose, when I do that it will show me all the dates even though I have a filter current month.

    Any idea why is that? 

     

    • Irwan's avatar
      Irwan
      Icon for Super User rankSuper User
      2 years ago

      hello Zack92 

       

      try to do visual filter on this visual instead of in this page. let see if that solve the issue.

       

      here is an example of what i usually do, visual filter because i only want to filter certain visual (not the page)

       

       

      Thank you.

  • Zack92's avatar
    Zack92
    Icon for Helper III rankHelper III
    2 years ago

    Irwan  Thank you for the response, I've got this filter set up for August, but there are a couple of days missing - like the 20th and the 22nd because there's no data for those days. The thing is, when I use your method to show items with no data, it just throws away the filter and shows me everything, all the dates, and I just want to see what's happening this month. I am not sure why it does ignore the current month's filter