Separately calculating data by seasons

[petercreateParticipant]

@Jean-Yves, both are good fitting what I need. I used the second, for it sorts seasons in order of spring, summer, autumn, and winter. The first is also good but it sorts them in alphabet order. Thanks.

[Jean-Yves Le StangParticipant]

OK

May be DG team has some recommendation on how to sort X axis labels in the first configuration ?

[dgteamModerator]

First, Thanks, Jean-Yves, for the great suggestion on mapping the dates to the astronomical seasons!

FYI:  Here is an explanation of the meteorological seasons. We took the easy way out since these are mapped to month number. 😀
https://www.noaa.gov/education/resource-collections/climate/changing-seasons

Regarding sorting, you can may want to map to a Season Number in the order that you want them shown, instead of the text.

Then, you can combine those two numbers into one column using a Text expression column.

For example, here is what this would look like in the data table, for the data that will be pivoted.

Then when you Pivot the data, use this combined Year-Season column to group the data.

Through a series of separate pivots and mapping, we created this look-up table.  You could also manually create this by having a table with a list of every Year-Season in your data along with a corresponding label.  Note the “\n” is added in the label so the season will be on a separate line.

Then this mapping withing the Pivot command is used to update the labels on the y-axis.

In any case, an interesting problem and we will think about adding this grouping to the Pivot!

 

[Jean-Yves Le StangParticipant]

Many thanks, dgteam, for this explanation which provides further possibilities to present informations with DG and the Pivot Command.

I was aware about astronomical/meteorological seasons but as a former seaman, I am used to fix my position from sun, stars and planets… Not a principle but a natural trend…

[Author]

Posts