nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Stiltsoft support

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):

Thu 3-1.png

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.

All comments

Stiltsoft support

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):

Thu 3-1.png

Stiltsoft support

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

Thu 4-1.png

We can filter the rows with zeroes out:

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

Thu 4-2.png

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

Thu 4-3.png

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

filter

table

chart