Chart Time series Period Comparision

[norber...@multimageweb.com]

good afternoon !

i want to setup timeseries chart for compare actual year and previous years data. see attached example.

cant find out how should i setup on timeseries comparisable x axis

e.g. 

case 1. series1 this year month, series 2. previous year month

explained here

http://www.jfree.org/phpBB2/viewtopic.php?f=3&t=23480

norbert

[Steven Sackett]

Hi Norbert

in the attached document from Paul it talks of having multiple data sources in one chart. Won't that solve the problem?

regards..

[redhuan d. oon]

Hi Norbert, dobre,
I have adapted Adaxa's charting in its CRM module (already included in core of iDempiere by team) to be more easily generated without defining each series row in the model. http://red1.org/adempiere/viewtopic.php?f=45&t=1826

[norber...@multimageweb.com]

hi Steven, Red1

Thanks for document. we study it again and we cant setup scenario.

when we adding 2 series, then they cant be mapped when charting switch to XYChart.

see example before/after:

timeseries-comparision-before.png - displaying when  we set 2 series 2 years by month - charting cant compare.

timeseries-comparision-after.png - displaying our hack - however working only for categories not for XYBarchart Generator.

in second example - in our hack - we add temporary a field TimeUnitDateFormat. when we enter e.g. MMM dateformat then we get common/comparable simplified series. This can be compared as image showing.

This still doesn't works for XY series generator (date), only for category series . (string, when we convert date to category in java)

we assume this must be implemented (http://www.jfree.org/phpBB2/viewtopic.php?f=3&t=23480)

@red1 your plugin handle this scenario ?

norbert

[redhuan d. oon]

I been studying and decided to use Excel 2016 as the killer BI-UI (business intelligence and user interface) dashboard. It has now built in pivot tables and database integration on the fly. Doing charts is not just easy, but fast and awesome looking
Together with Nakarat of Bangkok, we are collaborating on some free ready made templates to present cash flow analysis, and for me i like to show Warehouse dashboard that shows supply chain inventory scenarios.

[nilskm]

This is actually a pretty important question. Being able to compare time periods is often very essential in BI. To me it should include comparison of sales (in quantity and numbers), revenue per product or per category or per group of categories (category with subcategories) etc. 

I'm looking forward to your templates Redhuan :-) 

Nils

[norber...@multimageweb.com]

We like excel, however in this thread discussing about chart feature improvement.

Steven: we prefer join Paul.

best regards

norbert

[Steven Sackett]

Imported a transaction into account 43000 for 24 months and displayed in graph.

Paul created the attached graph as a quick demo.

Setup should be visible in adaxa.testadempiere.com in a few hours.

Open the account element window and go to account 43000.

regards..

[Steven Sackett]

the demo site is updated with the example chart... and note that graphs can be made to look nicer.  :-)

[norber...@multimageweb.com]

Thanks for response !

Paul setup for us timeline for 12 months  by using categories (categories column = p.PeriodNo) without enabling time series feature. He used PeriodNo as "common category" for comparison.

in above example data must be generated by pg. timeseries (http://no0p.github.io/postgresql/2014/05/08/timeseries-tips-pg.html) otherwise if not data supplied for some periods e.g. 5,6 month then his chart will include gap for empty Months(categories will be excluded)

our idea was implement support for simple date format similar to period (e.g. get period from timeseries) then draw in jfreechart  timeseries XYchart. recommendation from jfreechart team(http://www.jfree.org/phpBB2/viewtopic.php?f=3&t=23480)

wdyt?

norbert