How to handle - 'This Selection generated no data'

aditya12345 — Wed, 10 Jan 2018 10:41:14 GMT

Hi All,

We are using a Bar chart with

Measure -

(

Count(Distinct {<[Is Engaged Flag?]={1}>} PartyMonthID)

Count(Distinct total [Party ID])

)

Dimension - 1) Month Year

2) Channel Type

For certain selections, the 'numerator' in above expression Count(Distinct {<[Is Engaged Flag?]={1}>} PartyMonthID) results into 'This selection generated no data for this chart' as for these selection [Is Engaged Flag?] is null (which is the business logic) and because of this our chart dimension appears as '-' instead of showing the corresponding Month Year and also the chart color also become off. Refer to the image attached.

We tried using the Alt(Count(Distinct {<[Is Engaged Flag?]={1}>} PartyMonthID), Count(Distinct {$-<[Is Engaged Flag?]={'*'}>} PartyMonthID) ) to deal with Null values, but is this the best way to handle the situation or there is another better approach and an underlying fact which we are missing out.

It would be great if anyonecould help us in this regards.

Thanks in advance,

Aditya

topic How to handle - 'This Selection generated no data' in App Development

How to handle - 'This Selection generated no data'