Would you like your Sales YTD Chart looking like the first one? And then with a simple input and click becomes the next one? Dream no more. It is happening with the Sexy Chart Maker!
The first was created by login as SystemAdmin and at the Chart Maker Process:
After click OK, relogin as your Client and call up your Sales Rep Dashboard and look at the Sales YTD Chart inside. Your sales data over the months are broken down according to Product. To switch to a break-down by Customers, go back to the SystemAdmin > Chart Maker:
If you call up the Chart window and look for Sales YTD you will see it been rewritten as:
If you specify a new ChartName, it will generate for you a new one (not tested yet so if anyone hits any bugs do tell me and it should be easily fixed).
In theory this Chart Maker can generate from any table source, to any field amount, to time based (or even different category but its not tested) of different time type (Day, Week, Month, Year), and any breakdown column. Just specify the in between tables for it to join and that final column breaker as shown in the two examples above. It can theoretically go to any length of joins. Thus you can have LineNetAmt>C_Order.C_BPartner_Location.C_Location.C_Region_ID (this is untested imaginary example to give you the idea behind my creation so check if your tables joining is logical with the breaker column as existing and it must work.
The chart datasource generating also will check the table data set (C_OrderLine) as having such break data before it creates that datasource line. Thus if you have fresh new data for the break, you should just give this ChartMaker a reprocess again. Just remember to do a Chart Maker process entirely in the SystemAdmin or else it will not delete its old datasource records.
This Chart model is a graphical statistical presentation layer and has no impact to actual live data. By the way this ChartMaker process is also created using the Aladdin Magic Plugin to speed up my development of this.
The Chart Maker source is committed to http://bitbucket.org/red1/org.red1.chartmaker. Binary plugin is at http://sourceforge.net/projects/red1/files/ChartMaker/. You do not need the 2Pack. It is already included in the plugin. Just install using Felix Console and login SystemAdmin you will see the Chart Maker process.