Forum Discussion

V24's avatar
V24
Helper I
2 years ago
Solved

Table visualisation filtering data

I have 3 tables: Global , Local , checklist . 1 global projects can have many local projects. 1 local projects can have many checklists. When I use the table visualisation It is only showing the projects which have data in  global, local and checklist table. I somehow managed to show data from global and local and the global projects with no data in local are being shown blank which is great. But when I add the checklist to the table visual it is filtering out and only  those projects which have data in all the 3 tables are being shown . I want to show all the projects and if they have no data in local and checklist I want it shown blank.

8 Replies

  • Hello V24 ,

     

    click on the project field and tick the show items with no data option 

     

    • V24's avatar
      V24
      Helper I

      Hi Idrissshatila thanks, tried your solution, it does show all the projects when the data is only related to global and local when I put the checklist data the data is getting filtered and only the data having items in checklist is being shown. What do i do?

      • Idrissshatila's avatar
        Idrissshatila
        Super User

        V24 ,

         

        can you show us how your data is structured and your scenario, I can't help you without knowing the structure of your model.

  • Hey I am able to get all the data even when I add checklist data, but somehow even if I have data for certain columns it is not being shown. Ex if I have deployment lead in my datatable for all the projects it is not being shown in the table visual for all the projects it is showing for the ones with data in local and checklist