668205_en-US

liliconcom

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!

 

 

 

Data Exploration and VisualizationWindowsRe: 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.

 

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

Best,

TS