Forum Discussion

Cyprix's avatar
Cyprix
Frequent Visitor
9 years ago
Solved

Matrix Help

Hello Everyone,   I am trying to track a list of rooms and wether or not they were cleaned on each day of the week. My two matrix visuals looks like this.     As you can see the table on the...
Need Help
  • Cyprix's avatar
    Cyprix
    9 years ago

    I was able to fix my problem, I needed to create 2 additional tables one with a list of rooms and one with the days in the week, and draw the relation ship from those tables to my data. Then use my newly created tables as my data for my matrix and when I selected show items with no data, it populated and now my problem is fixed.

     

    Thank you all for the help and responses.

Cyprix's avatar
Cyprix
Frequent Visitor
9 years ago

I tried to remove my slicer and use page level filters but the problem is still there. If any room or day has no entry data for the time period it is left from my visual even when show items with no data is selected.

Cyprix's avatar
Cyprix
Frequent Visitor
9 years ago

I was able to fix my problem, I needed to create 2 additional tables one with a list of rooms and one with the days in the week, and draw the relation ship from those tables to my data. Then use my newly created tables as my data for my matrix and when I selected show items with no data, it populated and now my problem is fixed.

 

Thank you all for the help and responses.