Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts!
i have an external contact table , an internal contact table and a table about their meeting time .
external contact table has a contactID linked to meeting table
internal contact table has a employeeid linked to meeting table, and i tagged some employees with leader and i only want to show them below.
not all contactids are in the meeting table, not all employees are showing in the meeting table either.
if i do not check the include null values, it will show like this below, if i check it will not show external contact 3.
i want to show external contact 3 and also not want to see the null value at the last column.
how do i do that?
thanks for your help
internal contact1 | internal contact2 | internal contact3 | internal contact4 | - | |
external contact 1 | june-2-2022 | ||||
external contact 2 | aug-4-2023 | ||||
external contact 3 | - | - | - | - | - |
Yes, it's possible. But it may not be trivial and will probably need some efforts. Quite important is to understand the various kinds of NOTHING - their cause and effects - to decide how to handle them. Very helpful for the matter are the explanations here:
thank you for that link.
i am asking visualization wise, is it possible to show external contact 3 if i uncheck include nulls for internal contact in pivot table.
or another ay to ask is how to keep external contact 3 while not showing null on the internal contacts?
I think there should be a possibility to do it only within the UI - but rather not with the default-properties and/or without adjustments to the dimensions and expressions. Probably only by the use of calculated dimensions which could become quite tricky and complex and which have often serious side-effects in regard to the usability and the performance.
From a general point of view such tasks should be better resolved within the data-model as within the UI. Therefore I suggest to start there.