+ Reply to Thread
Results 1 to 7 of 7

Want to have the average of requests per customers for a give period versus another period

  1. 10-27-2017, 10:05 AM #1
    Alkyrian
    Alkyrian is offline
    Registered User
    Join Date
    10-27-2017
    Location
    Montreal
    MS-Off Ver
    2013
    Posts
    3

    Question Want to have the average of requests per customers for a give period versus another period

    Hi,

    I'm working currently on a project to decrease reccuring requests from customers with a VIP program and i want to be able to measure the decrease of requests.

    I built a small excel file in order to fill in the average of requests before the beginning of the VIP follow-up (last month) and the number of requests by week 6 weeks after the beginning of the follow-up so i can see how much it decreased.

    I entered false numbers in my file to see if i'm able to built a stacked bar chart where i can see week after week the overall or per customer difference between the number of average requests before and after the follow-up but for now i'm not getting anywhere.

    Thank you for you help and advices
    Attached Files Attached Files
    Last edited by Alkyrian; 10-27-2017 at 10:21 AM.
    Reply With QuoteRegister To Reply
  2. 10-27-2017, 10:08 AM #2
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Want to have the average of requests per customers for a give period versus another pe

    How to attach an Excel file to your post,
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post
    Reply With QuoteRegister To Reply
  3. 10-28-2017, 08:16 AM #3
    stasinek
    stasinek is offline
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Want to have the average of requests per customers for a give period versus another pe

    See the resolution will be good? I used Power Query.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 11-02-2017, 11:17 AM #4
    Alkyrian
    Alkyrian is offline
    Registered User
    Join Date
    10-27-2017
    Location
    Montreal
    MS-Off Ver
    2013
    Posts
    3

    Re: Want to have the average of requests per customers for a give period versus another pe

    Thanks this is what i wanted.

    Could you explain how you did that with power query. I never use that module and i tried to understand how you did that but I didn't find.

    Thank you !
    Reply With QuoteRegister To Reply
  5. 11-02-2017, 02:31 PM #5
    stasinek
    stasinek is offline
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Want to have the average of requests per customers for a give period versus another pe

    To start, try to download and install Power Query from the official Microsoft Office website.
    Reply With QuoteRegister To Reply
  6. 11-03-2017, 09:22 AM #6
    Alkyrian
    Alkyrian is offline
    Registered User
    Join Date
    10-27-2017
    Location
    Montreal
    MS-Off Ver
    2013
    Posts
    3

    Re: Want to have the average of requests per customers for a give period versus another pe

    Thanks.

    The module is installed
    Reply With QuoteRegister To Reply
  7. 11-03-2017, 10:39 AM #7
    stasinek
    stasinek is offline
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Want to have the average of requests per customers for a give period versus another pe

    Start the Power Query tab and go to edit. Take a look at the next steps and try to understand them (there are few, all from the user interface)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calculate the portion of a planned number during a period, based on another time period
    By BryGuy81 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2017, 01:29 PM
  2. [SOLVED] Macro to give next # of Pay Period
    By Robert1960 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2016, 01:03 PM
  3. Returning value from date witin give period of time
    By beelv in forum Excel General
    Replies: 3
    Last Post: 06-07-2016, 09:55 AM
  4. How to sum when it exceeds limits and calculate the period (payback period)
    By jihyeu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2013, 11:38 PM
  5. [SOLVED] Complicated:Calculate time period based on no. of units sold + fluctuations within period
    By omaha.crab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 03:04 AM
  6. If Cell Ends with a Period, Remove Period
    By Ocean Zhang in forum Excel General
    Replies: 2
    Last Post: 08-07-2011, 04:18 PM
  7. Excel 2007 : How to extract the period from a Year / Period text string
    By The_Snook in forum Excel General
    Replies: 2
    Last Post: 08-06-2011, 11:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1