Chart from Table filtering

Manouil Gioulountas

I am using a chart from table macro to present my table data visually. My table has some merged cells.

The issue is that when the user clicks on items in the chart that represent data from the singular rows, the (what should be) joint content from the merged cells is not shown in the filtered source table results.

It is hard to explain in words.

Examples:

 

 

Is this a known issue and is there a workaround to fix it? T

Thank you

Stiltsoft support

Hi @Manouil Gioulountas ,

As for now, it's expected behavior for the macro. But we've created a ticket for our roadmap and linked your question to it. Once the feature is implemented, we'll notify you here.

Meanwhile, you may use the following workaround: reuse your merged table if required with the help of the Table Excerpt/Table Excerpt Include macros and place the Table Transformer macro before the Chart from Table macro,

Don't change the default SQL query inside the Table Transformer macro. The macro will help you to get rid of merged cells automatically and the filtration within the Chart from Table macro will be done as expected.