User Profile
Maddy29
Copper Contributor
Joined Dec 10, 2021
User Widgets
Recent Discussions
Re: One Click Information
Thanks for the help, however it is not working on the basis of UM (which is a dropdown). When I tried to get for other person it gives me an error. Also, Area and Branch should be populated at the same time when selecting for another person. Please let me know for any clarification.3KViews0likes0CommentsRe: One Click Information
thanks for the help, however it is not working on the basis of UM (which is a dropdown). When I tried to get for other person it gives me an error. Also, Area and Branch should be populated at the same time when selecting for another person. Please let me know for any clarification.3KViews0likes2CommentsOne Click Information
Hello Mentors, I want to extract all the related information on the basis of UM name in this format. Can I get it out in the below format on Sheet 1? I have got output in sheet 2 by applying Vlookup but can I get output in that format? If yes then how? mentors, please help I have attached the sheet for your reference. Best Maddy3.2KViews0likes6CommentsRe: Ageing Analysis
thank you sir, it really helped me. just for clarification on average number of incidents raised. - how will it work. In my long data set when I apply this formula it doesn't give me the right picture. if you help me to understand would be great sir. Thanks.2.5KViews0likes2CommentsAgeing Analysis
Hello Mentors , In my attached sheet I am trying to do ageing analysis. Please help me to get result under mentioned bucket in the sheet. ageing wise for Open cases -> how many are under 0-30 days , 31-60 days , 61-90 days and >90 days. ageing wise for Closed cases - how long it took to close the incident. ->how many are under 0-30 days , 31-60 days , 61-90 days and >90 days ( took to close). Average number of incident raised every month. Is there any way to identify or mention or count the common description among all. please help me to get the result.2.7KViews0likes6Comments- 761Views0likes0Comments
Return Request Analysis
Dear Experts, need your guidance in my attached file. Daily & Monthly average volume out of 20 sample request how many have made 50% of total return request 1.how many return request received in the same day of credit date to customer 2. 1-5 days 3.6-20 Days 4.21-50 Days 5.51-100 Days 6.More than 100 Days 1.how many return request received under less than 1 GBP 0-100 101-200 201-500 501-1000 1001-2000 thanks826Views0likes2CommentsRe: Productivity Variance Analysis
Hi Joe, I really thank you for responding. Yes I am just wondering how can I calculate my stats in excel since dont have time components as such. 2nd - can I get your help to show the calculation with your findings Joe. That would be a great help. Thanks3.1KViews0likes0CommentsProductivity Variance Analysis
Hi Experts, can someone please help with output I am looking for in the sense of productivity at Quartile 2 and Quartile 3. I have tried with formula to get Productivity at Quartile 2 and 3 and same with Workout at Quartile 2 and 3. I want to create a sample which shows variance on productivity and workout. I have mentioned Productivity Baseline. I would really appreciate if someone can reply. thanks3.7KViews0likes11Comments
Recent Blog Articles
No content to show