Embedded Analytics automatically hides columns that contain no value

[former_member784354]

Hello, team!

I have a problem while creating a table. My table consists of different measurements (columns) and a list of participants (rows). Columns are sorted in a custom order. Some of participants have NULL values in one or more columns.

When I enable filter by participant that has these NULL values, columns automatically disappear from the view.

The question is how can I fix the column so that it is visible even with NULL value? The option 'Null suppression ' does not make the difference.

[Ajit_K_Panda]

Hi Ivan,

By looking at the images, i think you are using measurement name in columns. When you are filtering, some measurements are not there for that particular participant (manager). Hence the column disappears.

2 ways to fix this

1. always generate that particular measurement for all participants (managers)
   Cons for this approach: Unnecessary Entries in Commissions
2. Create Restricted Measure calculation for each measurement
   

   

   Cons for this approach: In future, if new measurement rules are created, then again calculation column needs to be added

Thanks, Ajit

[former_member784354]

Thank you, that solves the problem

[former_member779889]

Hi, ajitkpanda !

Where to find the Calculation Editor?

[Ajit_K_Panda]

Hi Lyubov,
Screenshot for your reference.

Thanks, Ajit