Hi Team,
I am not sure if this question has been asked earlier,
I have a sql query to build a bar chart in Apex.
My query looks like this,
select sdsas.AGE_GROUP, div.DIVISION_NAME, sum(sdsas.COVID_19_DEATHS) as death_count
from COVID19_DEATHS_SEX_AGE_STATE sdsas, state st, division div
where sdsas.state = st.state_name
and sdsas.AGE_GROUP <> 'All Ages'
and st.DIVISION_ID = div.DIVISION_ID
group by div.DIVISION_NAME, sdsas.AGE_GROUP;
I want to show a bar chart with value as death_count and I also want 2 fields as labels, which is Divison_name(9 distinct values) Age_group(10 distinct values).
To better explain. Each division value has 10 Age groups(dis) and so on.
Division 1: 1-10(Age_group)
Division 2 : 1-10(Age_group)
I have a sum based on each age group under that division.
Ant help would be appreciated.