Ad-hoc report expression

[vijetas42]

Hi all,

Currently i am having one issue with my Ad-hoc report, I am having 2 metrics like,Impressions and Impressions_P25_54 when i write condition on both the metric at that time if I select single value then it works fine for Impressions but when i select Impressions_P25_54 then it will display Impressions too. and if i select both the metrics then it displays only Impressions_P25_54 not Impressions .In this case how to write expression.

Thanks

[robert_mika]

Could you attached your app or screenshot?

[ankit777]

Hi,

What conditions are you using?

[vijetas42]

Hi,

due to company policies i could not attach screenshot.but i can tell what are the expression i am using,

SubStringCount(Concat([TV]),'|'),'Impressions')=1 and GetSelectedCount(TV)>0 and same for

SubStringCount(Concat([TV]),'|'),'Impressions_P25_54')=1 and GetSelectedCount(TV)>0

[ankit777]

Hi,

considering [TV] field has two values only='Impressions'  and 'Impressions_P25_54'

Use following conditions:

1.    [TV]='Impressions'  or getselectedcount(TV)=2

2.    [TV]= 'Impressions_P25_54'  or getselectedcount(TV)=2

[settu_periasamy]

Try this

SubStringCount(Concat(Distinct [TV]),'|'),'Impressions') and GetSelectedCount(TV)>0

SubStringCount(Concat(Distinct [TV]),'|'),'Impressions_P25_54') and GetSelectedCount(TV)>0

Below link would be helpful.

Customizable Straight Table