sum with dimension

[asilvaroli]

Good morning,

I have a problem with a bar graph and a sum

I have to add the exact answers for each candidate by category of question and typology.

Types can be:

ancient history,

Medieval history,

Mathematical analysis,

grammar

,etc

I would like the chart to give me a unique column for the HISTORY type, including the ancient and medieval ones.

How can I do?

[balar025]

Hi,

Can you please sample data or app or result?

Regards,

Ravi balar

[asilvaroli]

of course

For example, my data is provided as follows:

I would like to make the following chart

All the history fall into the typology of history

[Sergey_Shuklin]

Hello, Alessandra!

Stacked Bar Chart with three dimensions STUDENT, CATEGORY, TYPOLOGY and expressions with specific answers don't bring an expected result?

[asilvaroli]

no because I would like a graph like this:

one dimension no three dimensions .

I hope I'm well explained

[balar025]

Hello Sergey,

Sorry to say but Bar chart works on max 2 dimensions.

Regards,

Ravi Balar

[balar025 · Accepted solution]

Hi,

Please find attached app.

Regards,

Ravi Balar

[Sergey_Shuklin]

You can concatenate CATEGORY and TYPOLOGY in the script with "-" separator.

After that you will be able to draw such chart.

[asilvaroli]

thank you