Customize the This chart contains no data or This report contains no data messages

Hello Mike - this is something we would like to see also. Customized page when no results are returned.

Thank you

Hi Michelle,

Thanks for reaching out. I've gone ahead and added you to the client list in our internal task of those who'd like to see this functionality implemented. No further updates on this as of yet but every comment and vote helps!

Regards,

Mike

Hi Mike,

I know this thread is about customising the no data message and there is currently no functionality for this. Is there any functionality at all for simply hiding the message or a bit like in Excel with IFERROR? I have a report which in some months has data and in some not and would like it to either show 0, or blank if no data exists.

Thanks

Chester

Hi Chester,

Thanks for reaching out. I think there may be some confusion about where in the application the 'No results returned' message is located. This is what that looks like:

I'm not sure why it would be desirable to display a 0 there instead of 'No results returned', but if you just need to change the text or make it blank, if you utilize custom css (literally just create a css file and put it in the '.../customcss' folder as per linked Wiki entry) you should be able to change the "No results returned." text by altering the "largeGreyErrorText" div class:

If you're talking about changing data at the data level on a per row/column basis, this can be accomplished via Calculated Fields. Something like

CASE WHEN column1 IS NULL then '' ELSE column1 END

CASE WHEN column1 IS NULL then '0' ELSE column1 END

Regards,

Mike

Hi Mike,

I understand, I have misunderstood the thread. What I'm trying to work out is if I have a report on a dashboard which is a simple number report reporting on volumes of items at a location and for arguments sake one month there aren't any and therefore the table Data Source for this (in our case the SQL Server) doesn't have an entry for the specific 'Set Analysis' the report on the dashboard returns "This chart currently contains no data." Is there anyway to set what this says, or default to 0 for example?

Thanks

Chester

Hi Chester,

There's no way to default the Set Analysis value to '0'. Being able to do so is dependent on the data you're actually using and how it's being configured in the analysis setup.

However, you should be able to hide this in much the same way as described above, by hiding the div.chartCustomError class in a custom css file:

Hopefully this helps.

If you have any other questions regarding this, please open a new trouble ticket to discuss further so we can accurately track separate issues.

Regards,

Mike

Thanks for your help Mike.

Chester

Hi Chester,

You're welcome!

Regards,

Mike

Hi Mike,

Wanted to ask one thing, if we make changes in css file will it reflect the same change in all the reports where there will be no results?

i just want the same statement to be displayed on single report. Is it possible?

Thanks,

Sayali

Hi Sayali,

Since this relates to styling, this change would be applied globally, unless you can find some HTML to point to or styling specific to that report in the CSS, which I strongly suspect would not be possible.

Regards,

Mike

Hi Dan,

Thanks for reaching out. There are no further updates on this as of yet, but I've noted in the internal enhancement request that this request has been received internally numerous times on your end. I do like this idea, so hopefully we can get some traction on this real soon.

Regards,

Mike

Hi Mike,

Thanks for the update.

Best,

-Dan

Hi Dan,

You're welcome!

Regards,

Mike

Hello Mike Sheehan

Is there a way to prevent show the image and text when a row limit is enabled in a report I can do it directly in yellowfin UI with custom CSS but when the report is exported to PDF the warning legend and image persists.

The max row limit has been reached.

Data may have been truncated.

Hi Rodrigo, at this point in time there is not way to remove this message from the report or PDF natively . Apologies for the inconvenience this has caused, though I will ensur to keep you posted on any updates.

Regards,

David

Hi David,

Thank you very much for the support, I will be attentive for future updates on this topic.

Regards

Hi David,

Hope you well.

Is there any update with regards to removing the message from PDF export?

Kind regards,

Mikayla

Hi Mikayla,

Mark here from the EMEA Support Team. David no longer works for Yellowfin, hence my response... With this no updates, movement or options to have said feature, nor can we have this message removed from the PDF as of yet.

Regards,

Mark