Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Good morning. A very simple question, may be I am doing something elementary wrong.
I have a container within which there are two bar charts. When I apply filters, the chart heading in the second chart disappears. This happens only for the second chart and only where there is no data. Screen shot attached. The top charts without filters applied and the bottom with the filters.
The "Show Title in Chart" box is checked under Properties>General.
Thanks,
Karthik
When there is no data, the chart title will not be availble.
Thanks Sindhu! Is there no way of keeping the alignment of the cyclic group icon as it is?
Because, the cyclic group icon moves to the top in the second chart when the applied filters have no data but stays the same in the first chart, which kind of looks awkward!
as I know, there is no way. But you can hide the chart based on the chart expression.
Karthik,
You can handle by throwing an error message when the chart don't have data when you apply filter. The chart title will remain as it is irrespective of data presence. Find the settings in the below screenshot and look at the attached example.
Thanks Shankar.
I tried it but it didn't work unfortunately. My Expressions section has the following formula.
Expression:
=Num(count({<Response={'No'}>} Questions)/Count({<Response={'Yes', 'No'}>} Questions), '0.00%')
Calculated Condition: =IF(count({<Response={'No'}>} Questions)/Count({<Response={'Yes', 'No'}>} Questions)=0,0,1)
Window Title and Chart Title = IF(count({<Response={'No'}>} Questions)/Count({<Response={'Yes', 'No'}>} Questions)=0, 'No Data To Display', ' Questions Answered "No" - (%)')
Error Message: =IF(count({<Response={'No'}>} Questions)/Count({<Response={'Yes', 'No'}>} Questions)=0, 'No Data')
The Error Message is working, so the formula seems to be right. The same formula appears in both Window Title and Chart Title but they disappear when there is no data. Not sure what is wrong.
can you share your application?
please share your app
Hi Shakar and Avinash,
Sorry, it is the personal edition. Do you think it will still work?
Thanks,
Karthik
Yes, you can still upload.