Hi All -
Version 24.2.11
I have a table with the following structure
id varchar2(10) PK,
transaction_dt - date
prod_cat - Fixed values - Prd1, Prd2, Prd3, Prd4
Selected_Prod_Subcategory - Values are Yes or No or null
Selected_Prod_Childcategory - Values are Yes or No or null
I want to build a chart which shows me counts of Selected_Prod_Subcategory and Selected_Prod_Childcategory that have value and is not null by prod_cat and on a monthly basis. So the X axis will have Month like Jan 26, Feb 26, Mar- 26 and within each month I separate bars for Prd1, Prd2, Prd,3 and Prd4 and for each of the Prod_Cat, I have “Stacked” counts of Selected_Prod_Subcategory and Selected_Prod_Childcategory where the fields are not null.
I am able to created stacked bars when we have say only Month and counts of Selected_Prod_Subcategory and Selected_Prod_Childcategory, but can we further show multiple bars based on prod_cat?
Thanks!