Forum Discussion

joaoantunes's avatar
joaoantunes
Frequent Visitor
6 years ago
Solved

Matrix Table show lines without Data

Hello,

 

I need help with my matrix table.

So, i have a table that haves the users on the lines, dates on the collumns and tasks on the cells.

As you can see here: 

 

In this print im filtering the only to Month Mar Week 2 and i only can see 4 lines (users) because the others don't have any taks that week.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

In this second print you can see that im already using the option "Show empy values" on owners (and also on all other fileds, not on Project Name because i don't have that option). In this print you can see that i've selected the next month and now i have one more owner:

 

 

I have two tables, the one with all the dates and the one with the tasks, the connection works fine:

 

So, basically what i need its to have all owners names even if they don't have any task for that week/month/day... Like it was always static showing always all the owners.

 

How can i make it?

 

Exemple of the desired result:

 

PS i don't mind if appears blank or "null" or "0" or something...

 

Thanks

  • Ok, so my own solution for this problem 😛

     

    I've created a new table that haves all Owners/users and its connected to my Tasks table.

     

    This way im able to have all users on the matrix even if they don't have anything on the lines.

     

    thanks anyway!!!

1 Reply

  • joaoantunes's avatar
    joaoantunes
    Frequent Visitor

    Ok, so my own solution for this problem 😛

     

    I've created a new table that haves all Owners/users and its connected to my Tasks table.

     

    This way im able to have all users on the matrix even if they don't have anything on the lines.

     

    thanks anyway!!!