Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I have the following table, I want to generate a bar chart where for each year I can see a single bar, including both Cash and Credit.
Today I only see this:
you can either tick Aggregate column A:
or use QUERY to group years and output table directly from QUERY:
"select Col1, sum(Col3)
where Col1 is not null
group by Col1
label sum(Col3)''", 0)
or add the 2nd series and aggregate column A:
Required, but never shown