How to retain table structure even if values corresponding to dimension are not there ?

[shekhar_analyti]

Hi All ,

How to retain table structure even if values corresponding to dimension are not there ?

On Selection 1:

On selection 2 :

The reason for 2nd observation is that we do not have data for 2nd case .

Hence in such cases i want the i want table structure to be retained like we have in 1st scenario with data populated as 0 for , call and meet .

But the below expression is not working

IF(Isnull(Count(DISTINCT{<MT={'Call'}>} ActionPoints)),0,Count(DISTINCT{<MT={'Call'}>} ActionPoints))

Thanks & Regards

Shekar

[sunny_talwar]

CITI is not one of the options within MG... so I am unable to replicate the issue by selecting different MGs

[sunny_talwar]

For the three MGs I see this

[shekhar_analyti]

Hi Sunny Bhai ,

Actually i purposefully added CITI under MG using inline load , apart from normal load from excel .
The purpose to add CITI was to replicate scenario 2 .

However you can add any name under MG which should not have entry in excel MG column .

Please let me know , if i was able to explain myself .

[sunny_talwar · Accepted solution]

Not sure why the original chart doesn't work... but tried to create a copy of the chart and it seems to be working

[shekhar_analyti]

Sunny Bhai , currently i do not have license copy . Requesting you to please share expression or step to achieve above .

[sunny_talwar]

Just copy and pasted into a new chart with following expressions

Count(DISTINCT{<MT={'Call'}>} ActionPoints) + Sum(0)

Count(DISTINCT{<MT={'Meet'}>} ActionPoints) + Sum(0)

Count(DISTINCT{<MT={'Conf'}>} ActionPoints) + Sum(0)