-
1. Re: Average number of days calculation
Norbert MaijoorJan 8, 2018 1:23 PM (in response to Chaitanya Somanchi)
Hi Chaitanya,
Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread
1. M1. Total Amount of Days: window_sum([datediff])
2. M2. Count OrderID: WINDOW_COUNT(countd([Order ID]))
3.M3. Average: [M1. Total Amount of Days]/[M2. Count OrderID]
Regards,
Norbert
-
2. Re: Average number of days calculation
Chaitanya Somanchi Jan 8, 2018 1:45 PM (in response to Norbert Maijoor)Thanks Norbert. Solution works if i want to show it as a table. However i was looking to plot it on a bar graph to see the average across each quarter. When i was trying that it doesn't work. Can you also help me on this ?
Attached the workbook by filtering to 2017 Q4. The average shows 3.97 . However in the next sheet i was trying out the bar diagram it shows 0.62
-
3. Re: Average number of days calculation
Norbert MaijoorJan 9, 2018 1:04 AM (in response to Chaitanya Somanchi)
HI Chaitanya,
Find my updated approach below as reference and stored in attached workbook version 10.4 located in the original thread
1. D1. Order Date (Quarters)
2. M1. Datediff: {fixed [Order ID]:min(DATEDIFF('day', [Order Date],[Ship Date]))}
3. M2. Count OrderID: {fixed [D1. Order Date (Quarters)]:(countd([Order ID]))}
4. M3. Average: [M1. Datediff]/[M2. Count OrderID]
5. Drag the required objects to the indicated locations.
Regards,
Norbert
-
4. Re: Average number of days calculation
Pavan Vemuri Jan 9, 2018 2:57 PM (in response to Chaitanya Somanchi)Hi Chaitanya
Check this out!
Check Sheet 2 in the attachment.
Regards
Pavan
-
Avg no of days_datediff.twbx 570.1 KB
-
-
5. Re: Average number of days calculation
Chaitanya Somanchi Jan 9, 2018 4:44 PM (in response to Pavan Vemuri)Thanks Pavan. This worked out