topic Vis.js Timeline in App Development

Vis.js Timeline

Anonymous — Tue, 03 Jul 2018 12:56:34 GMT

Hello everybody. I use the Vis.js timeline to visualize my projects. This is not a problem as long as the database looks like this:

This is displayed clean (with the necessary around it). One project per line with different milestones.

But I would like to have the data recorded as follows:

Projekt	Meilenstein 1	Meilenstein 2	Meilenstein 3
Projekt A	02/07/2018	05/07/2018	12/07/2018
Projekt B	22/06/2018	04/07/2018
Projekt C	01/08/2018		08/08/2018

I had only thought to convert the Excel with MTrans or whatever. But I am not enough expert for that. I hope you can help me.

undergrinder — Tue, 03 Jul 2018 16:08:16 GMT

Hi Ronny,

The solution can be the The Generic Load‌, or:

The next will be just pseudo code:

stg1:

Load projekt,

meilenstein,

autonumber(projekt&meilenstein) as rnk

from

;

stg2:

load projekt,

if(rnk=1,meilenstein,null) as meilenstein1,

if(rnk=2,meilenstein,null) as meilenstein2,

if(rnk=3,meilenstein,null) as meilenstein3

resident stg1;

final:

load projekt,

max(meilenstein1) as meilenstein1,

max(meilenstein2) as meilenstein2,

max(meilenstein3) as meilenstein3,

resident stg2;

drop table stg1;

drop table stg2;

It works only when you have maximum 3 milestone (ofcourse, you can add extra fields, but it is not so convenient).

Hope this helps.

Anonymous — Wed, 04 Jul 2018 07:46:55 GMT

Hi Gabor,

Thanks alot for the tip with "Cross Table". This is exactly what I need. And it is easy to use.

Ronny