Forum Discussion
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
- IdrissshatilaSuper User
- V24Helper 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?
- IdrissshatilaSuper 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.
- V24Helper I
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