Hi - Have been working on developing and customising the crm over the past two weeks to transition from my old (yet very trusty) Access Database of 9 years, to something cloud.
One thing I’ve struggled with is the reporting - It seems so simple in Excel, yet I cannot understand why it wouldn’t work in SuiteCRM.
I have a custom module which has the below ‘package’ options
Year
Package Type
Both are populated from the drop down, so Year is 2018,2019,2020 etc and the Package has ‘bronze, silver, gold’.
I’m trying to generate a chart which would show the years across the bottom axis, and then split (the package types) to show how many have been purchased against each year.
This is how far I’ve got: https://ibb.co/C6t16md and this is ideally what I’m trying to replicate: https://ibb.co/wQdgDNz
I’ve read a few articles, but none seem to cover this and are either very basic reporting or doing pie charts (which are not suitable for this).
Any direction would be great, thank you.