How to make Stacked Vertical column chart?

Steven Sun shared this question 3 months ago
Answered

Hi,

I'm trying to make a stacked vertical column chart for the first time, to compare two totals of the data, I've chosen stacked vertical column chart but the vertical field only allow one single measures/data. Can anyone help advise me?

Comments (1)

photo
1

Hello Steven,

Thank you for reaching out to us.

When using a stacked vertical column you are limited to one measurement on the vertical axis, this is then stacked or grouped by the color selection.

Based upon the screenshot provided a vertical column chart would allow you to set the Year on your horizontal, month for the color and both values can be graphed.

I hope this helps, please let me know if you have any further questions.

Kind regards,

Nathan Goddard

photo
1

Hi Nathan,

Thanks for your kind advice, I've tried below but it should not be this way.

'Based upon the screenshot provided a vertical column chart would allow you to set the Year on your horizontal, month for the color and both values can be graphed. '

How about no Color and two metrics(if I can convert the measures into metrics) and FY in Horizontal?

I've searched through all guides document but found no definition of measures, can you help quote it for me?

At data side, both sum of data are metrics, but in chart they're called measures and not allowed in the same field, If so how can I make a stacked column chart? please advise me further. thanks.

photo
1

Continued

At data side, if I remove one sum aggregation(though it's not allowed), it's still measure in Chart. Found no way to accomplish the stacked column

photo
1

Continue again,

Just found if I put all aggregated data in the row, they can be added together into the same field of the chart, and their type became metrics. Is this the difference between metrics and measures? still confused.

photo
1

Hi Steven,

Thank you for getting back to me.

Sorry for any confusion caused, metrics and measures are the same.

A metric is defined as fields that retrieve numeric data that are the result of calculations on data in the database. Metrics tend to be dynamic: the values they return depend on the dimensions they are used with. For example, if you include Person and Age in a query, Age per person is calculated.

The limitation for these charts you are using only occur when your data is in a cross tab format, so for example, below I have created a report that shows Year, Month and 2 Sum values.

If I set this as a cross tab then I can only add a single value into the the vertical axis of the stacked column chart;

/45ee344bbeb2b44648a4b3c950d6ca53

Output:

/c8189ecee1484b3dbe7f1028c643fa26


Whereas if I set this as a normal report then these limitations are removed;

/d647913ffc771d995ccde8d508f900bd

Output:

/9e672b56634b325b7a79264b911feed1

As you can see this allows me to place both value fields into the vertical axis, the only limitation is setting the color to Year as color fields cannot be applied to this chart when using multiple series.

I hope this makes sense, please let me know if you have any further questions.

Kind regards,

Nathan Goddard

photo
1

Hi Nathan,

I think I'm clear with this issue now. Thank you very much!

photo
1

Hi Steven,

You are very welcome. I have marked this question as answered but if you do have any further questions please do not hesitate to ask.

Kind regards,

Nathan Goddard

photo