Forum Discussion
WLFRD
Helper III
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 ...
No, just extract it from the "First Response Date" instead - why would you need a calendar table then... ?
ThomasWeppler
Impactful Individual
Impactful IndividualI 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.
WLFRDHelper III
Helper IIII 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
Memorable Member
No, just extract it from the "First Response Date" instead - why would you need a calendar table then... ?