How to show these data on a graph ?

[#1]

Hello,

In case 1 (blue), my data have a different representation than in case 2 (green).

I don't know how I could represent the data in case 2 in a graph, in a simple graph like in case 1. The representation should be the same...that's what I would like.

Thank you very much for your help!

Ivan

[swuehl · Accepted solution]

You can turn your crosstable into a straight table while loading in using a CROSSTABLE LOAD prefix.

Please check the CROSSTABLE LOAD prefix in the Help, I think your load statement might then look like

CROSSTABLE (Type, Zeit) LOAD

     VertragID,

     Beschaffungszeit,

     Freigabezeit,

     Publikationzeit,

     Eingabezeit,

     Publikationzuzeit,

     Nachpublikationzeit,

     Einspruchsfristzeit,

     Zuschlag,

     Vertragsabschlusszeit

FROM

test.xlsx

(ooxml, embedded labels, table is Tabelle2);

Then you can use your created Type field as dimension and sum(Zeit) as expression.

[#3]

Thank you!