Forum Discussion
Helper IIIDisplay maximum response time in response time month
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
No, just extract it from the "First Response Date" instead - why would you need a calendar table then... ?
6 Replies
lukiz84Memorable Member
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
- PhilipTreacy
Super User
- lukiz84
won't help him if he needs the YearMonth column from a supposed Date table...
- ThomasWeppler
Impactful Individual
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
No, just extract it from the "First Response Date" instead - why would you need a calendar table then... ?
