Display maximum response time in response time month

[WLFRD]

Hello all,

I do an analysis of response times for orders. When I choose the maximum response time on the Y-axis, the maximum response time is displayed in the month of the order enter date. I would like the maximum response time to be displayed in the month in which the response is given.

See the yellow highlighted line. This can be seen in the graph in the month of February.

What do I have to do to show the value 166 in the month of September?

Thanks in advance

Regards

[ThomasWeppler]

I agree with Lukiz84

Change the relationships between your calender tabel and the first respones date.
So they are connected.
If you need the relationship between your calender date and order enter date you can use the userelationship function to have multiple relationships active at the same time.

[WLFRD]

I extracted the Year-Month from the order enter date with the FORMAT function. So I don't have a separate calendar table. Would a separate calender table do the trick?

[lukiz84 · Accepted solution]

No, just extract it from the "First Response Date" instead - why would you need a calendar table then... ?

[PhilipTreacy]

Hi @WLFRD 

Just plot the First Response Date on the x-axis.

Regards

Phil

[lukiz84]

won't help him if he needs the YearMonth column from a supposed Date table...

[lukiz84]

You have to use the other column in the matrix (First Response Date) or if the column in the matrix is from a Calendar table you have to change the relationship