Vis.js Timeline

[Anonymous]

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:

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

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]

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.

G.

[Anonymous]

Hi Gabor,

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

Ronny