LinkedIn
Twitter
Hi @MultiTech_Visions, thanks for your answer!
I had a couple more Number type columns (which did not appear) however the columns I want to aggregate are dates (aggregating rows with the same date).
From your question I did some testing and figured out they had to be Number type.
I changed my columns to be number type (value of 1 on each row I want to stack) however I now have to figure out how to set the vertical axis to the column that I want.
Is it possible?
My data set now looks like the image below.
I want to stack columns K and L in a per-month count basis.
An example of the graph I want is further below.
How do I do that?
Data set:
Example chart (I want the red bars to be decomposed into green and red):
Thanks for helping!
Just for a quicker solution, have you checked out the histogram type of charts? They allow you to do aggregate grouping type things kind of like what you’re wanting.
To your actual question: in the space where you select the colums to chart, did you include both K and L?
In this image I only see one column to show:
and that’s “Did_Not_Pay COUNT”.
Hi @MultiTech_Visions,
I am currently using histogram chart but for one column which contains the month in stake (type date). It is the image I shared above.
When I try to add more columns in the histogram I get this:
I can not get it to accumulate over month (like the red histogram graph above)
The configuration I used to obtain this (undesirable) result is the following:
How can I get the chart to be ‘over months’ based on 2 stacked columns ? (1 bar for each mobth, composed of 2 stacked colours)
