Pivot without graphing

[arnaudkParticipant]

Hello,

I’m new to DataGraph and I’m using a csv with the following format :

Date                  Category Number
2020-01-01     A              20
2020-01-02    A              30
2020-01-01    B              40
2020-01-02   B               50

Pivoting on a graph takes me what I expect to, after exporting the pivoted data to new columns, plot Serie A and Serie B with “Plots”. But I don’t use the intermediate graph (plotted by the Pivot Command)
Date                  A     B
2020-01-01     20   40
2020-01-02    30   50

Is there a way to do the same but without ploting the “intermediate” graph ? I just would like to pivot the datas and use them to plot my own graph.
I tried the Plot instruction at the left, which adds me a new column, but this one doesn’t accept non-numbers values (I would like to use my categories)

Thank you in advance.

Arnaud

[dgteamModerator]

You can use a Pivot command to process the data in this way but then click the Exclude button on the right side of the command.  This way the command is completely ignored, whereas Hide will not show the graph but the axis range will be affected.

Is this what you mean?

This example below is using the a date axis, but you mentioned you want to use your own categories.  Maybe you could clarify what you want on the x/y axes.

[arnaudkParticipant]

Thank you very much for your answer.

In fact you totally get the point, I proceed the way you showed in the example you posted.
The only difference with my real life :
– I have ~2 years of dates multiplied by ~100 categories = more than 50.000 bins, and DataGraph show me an orange dot on the Pivot section, telling me that there are too many bins. The extracted data seems to be consistent, still.
– I click on hide in the Pivot command and the graph is entirely plotted by the Plots command, but with correct axes

In my real file, categories are regions and numbers are hospitalisations or deaths (Covid data), and I keep in the data I extract from my Pivot the “day” granularity (no groups by months or weeks)

As the Pivot command graph is for me “useless”, I was thinking of generating the Pivot table without the Pivot command, but perhaps with Plot Action before graphing with Plots Command. In this case, I choose the “bin” action (pdf manual P.28, screenshot below), but my categories are in red as it seems I can only select numbers and not text.

Arnaud

[Author]

Posts