New Topic

Community Topic Question Report Builder

David Registro

APAC SD Team

Assigned

Category Report Builder

Product Version 7.3

Ability to use dimensions for colour in stacked column charts

Jonathan Allen shared this question ago

Answered

Stacked column charts expect a metric value for the "Colour" field. It would be very useful to have the ability to use dimensions here. There is a discrepancy in behavior since this is possible when using an "Auto Chart", but not when using a Stacked Vertical Column chart directly. For example, see attached AutoChart.png and StackedVertChart.png. The auto chart version is missing some formatting options and axis settings, so it is not fully functional.

It is possible to create a stacked vertical chart if the source table is a crosstab report, but that is very limiting. We do not want to always create a crosstab in order to have a stacked column/bar chart.

Files:

The same question

Replies (2)

David Registro ●

Hi Jonathan,

Thanks for the detailed info.

I think what you're after is already possible with a Trellis chart.. secretly this is what 'Auto Charts' are usually based off.

See screens below as example:

0daf613a918263260353c26bd419c472

a25a883d961e97652d1b589ccb29752a

Hope this covers what you're after, and if not, please let me know.

Thanks,

David

Reply URL

Jonathan Allen ●

Thanks David - yep that was what I was looking for! Didn't realize it was a Trellis chart that Auto Chart was making.

Reply URL

David Registro ●

No problems at all, yeah you wouldn't usually pick it up unless someone told you.

Thanks for the feedback in any case :)

Regards,

David

URL

Sumit Kulkarni ●

Hi David,

I understand that Trellis chart is useful to display Stacked column charts, however, Trellis and Auto chart version is missing label option which very crucial for our requirement. Is there a way we can display the labels on Trellis chart.

Thank you!

Best Regards,

Sumit K

URL

David Registro ●

Not as yet Sumit, your best option is to use a JS chart.

In saying this, tooltips/labels are something that will be revisited in the future.

Thanks,

David

URL