change 'No data to display' message

[#1]

Hi all,

I have a chart which calculates the next expression:

count ({<RT_REJECTED={'No'}>} SUBSCRIBER_KEY)

when the calculation equals 0, I have the No data to display message.

I tried to alter the message in the objects general tab in errors, with no success.

can you please assist?

Thanks,

Boris

[salto · Accepted solution]

Hello,

In the chart's calculation condition (General tab) write this:

count ({<RT_REJECTED={'No'}>} SUBSCRIBER_KEY) >0

And then, click the error messages button below, customize the Calculation Condition error message as you wish it to be.

Hope this helps.

[#3]

Hi Salto,

I'm looking into a similar solution, though I have two expressions.

Would it be possible to achieve the same using the Calculation Condition field, joining the following two expressions with AND or OR?

=if(GetSelectedCount(%Market)=1,sum([Actual Volume (HL) W+1])/MostRecentYear_TotalVol)

=if(GetSelectedCount(%Market)=1,sum([TotalGM_perSKU])/MostRecentYear_TotalGM)

Thanks for your help!

Mel