Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a table and I would like that the filtre does not apply to some of the columns of the table and the other ones which are the measures that it appplies the filtre.
So in context it is, I have a table with information about two different types of courses and I have a herarchy of bosses which the bottom bos is responsable of a worker who is doing the course, so there might be some bosses which has no workers who are doing the type course 1 but still when I filtre by type course 1 I want that this boss appears but with all zeros.
Hello there,
If the Boss is not related to the course he is going to be out of the filter and won't be displayed.
I am not sure if you can work this around.
EX: In this data below, Daniel will not be displayed when selected Course A or B, because his is not related to this course.
Load * inline [
Name, Cases, Course
Mark, 0, A
John, 20, A
Marco, 21, A
John,2, B
Marco, 10, B
Mark, 40, B
Daniel, 10, C
]
If you add his name having a relation with this courses, than, he is going to be displayed after selecting the data:
Load * inline [
Name, Cases, Course
Mark, 0, A
John, 20, A
Marco, 21, A
John,2, B
Marco, 10, B
Mark, 40, B
Daniel, 10, C
Daniel, ,A
Daniel, ,B
]
try to avoid Join if you dont want to see Daniel
or use Qualifier and pull from single table1.Name and Table2.Name