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.