cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
Ake
Ake
Level III

Progression per year, with date axis for several years overlayed

I want to plot data as is progresses over the year, with one curve for each year overlaid. The way I made it so far is to use Day of year (see figure) but I would like actual dates like month-day instead. Any ideas would be welcome!

Ake_2-1692108797615.png

 

 

 

2 REPLIES 2

Re: Progression per year, with date axis for several years overlayed

If you're looking just for a plot/graph, here's one way: 

  1. Add a new formula column for Month
  2. Change Day of Year[Date] to Ordinal
  3. Use Graph Builder to drag both date columns to the x axis. In the axis settings, I unchecked the "Show Tick Labels" box for the Day of Year axis.

Script saved to attached table.

Jed_Campbell_0-1692111797222.png

 

Thierry_S
Super User

Re: Progression per year, with date axis for several years overlayed

Hi,

 

Here is a different approach to your problem.

1) I computed a new column capturing only the Day and Month from the Date column (continuous)

2) I created a custom Date Format DD/MM

3) I plotted this new column as X axis using a 4-week interval

Thierry_S_0-1692112502430.png

Best,

TS

Thierry R. Sornasse