No Data to display

[varunreddy]

Hi All,

I have a calculated dimension. If the filter doesn't match the calculation, the report is displaying "No data to display". I want to change the content to be "Please select apprpriate Date".

Can anyone please guide me?

Calculation Used:

=Aggr(Only({<[Pull Type] = {'M'}> + <[As of Date] = {"$(vmaxDate)"}>} [As of Date]),[As of Date] )

If I select date other than maximum date, calculation dimension is getting failed. Is there a way to disregard the filter? If no, then is there a way to change the error message?

Cheers,

Varun

[manojkulkarni]

You can set Error Messages for calculation conditions .  General Tab of Chart Properties - Error Messages - Set required Message for calculation condition unfulfilled.

[sinanozdemir]

Hi Varun,

In the general tab of the chart properties, you can customize the error message and the calculation conditions:

In terms of ignoring filters, you can add 1 in the set analysis:

=Aggr(Only({1<[Pull Type] = {'M'}> + <[As of Date] = {"$(vmaxDate)"}>} [As of Date]),[As of Date] )

[varunreddy]

Hi Sinan,

I only want to ignore [As of Date]

[varunreddy]

I tried, but it is not working. As this is calculation condition, it is not working. Any help?

Regards,

Varun

[#6]

are you sure you are changing the correct message.  Tjhere are many messages in the list and you have to select the one you want to change

[varunreddy]

Hi Adam,

I only have these options

Tried to change for each and every option. But yhis is not working

[varunreddy]

Hi Sinan,

Can you send any sample?

Regards,

Varun