Show message to user when Pie chart is not displayed

[KMTek]

Hi,

When I am using the macro "Chart from Table" (Table Filter and Charts from Stiltsoft) to generate a Pie chart from a table, and this one contains only zeros, the chart is not being displayed.

Our intention is to display only the chart to users, not the table. Is it possible to show, at least, an message (a bit like the macro Chart does - "No data available")?

Thank you,

Vitor

[Stiltsoft support · Accepted solution]

Hi @KMTek ,

It is possible to customize your warning message if there is no any source table (for example, you build a chart using the Jira Issues macro and there are no suitable issues):

But if you just have zeros in your table, then they are treated like common numbers (null is also a value, you have valid data in your source table). So, there is no any possibility to display messages for such cases. 

[Stiltsoft support]

And, as an afterthought, maybe the following workaround with a Table Transformer will suit your needs:

We can filter the rows with zeroes out:

SELECT * FROM T*
WHERE 'Issues' NOT LIKE "0"

Then the Chart from Table macro "thinks" that there is no any source data, so you can use the customized message:

Maybe this helps your case.

[KMTek]

Hi,

Thanks a lot.

I didn't have the latest version, where the "Customize no table found message" is. After updating the app, the solution presented by you works like a charm. :)

Cheers,

Vitor

[KMTek]

And I leave here the suggestion to customise the message when a table is not found, or if all the values in a table are zeros, which is specially relevant when the table is hidden. No chart, no table, confused users. :)

An alternative could be showing the table if no chart is displayed. At least, the users will know that all values are zero.

Thanks.