How to make Stacked Vertical column chart?

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.

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

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.

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;

Output:

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

Output:

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

Hi Nathan,

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

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