Reporting using Alteryx designer

[gagandeep_dhall]

Hi All,

I need support from some of the experts here in reference to a mini project I am planning for.

This is all I want to achieve in the project:

1. Extract information from Inbox and into a single OneDrive Master File

2. Create Summary Pivots from the information in the excel files

3. Create a single Bar Graph from multiple summarized Pivots

Since there is plethora of information, I was unable to get access to the correct link/training that can help me achieve the above. If someone can help me with the links or point towards a specific conversation, it will be really helpful.

Thanks again.

Regards,

Gagandeep

[seinchyiwoo]

Any sample data that you can attach for better understanding on your challenge?

Cheers

Seinchyi

[gagandeep_dhall]

Hi Seinchyi,

Thanks for replying.

Here how the incoming data will be:

Multiple Files - Frequency: Daily 

Status

Date started

Time Started

Date Completed

Time Completed

Error Date

Error description

Time taken to complete

Time since in queue

Reviewer

So, my 1st step would be:

1. How to extract these daily files from Outlook

2. Add the data daily to the same master file

3. Create a pivot as follows:

Date

reviewer

Number per reviewer

Date	average time taken to complete

4. Putting the output into an excel file

5. Creating a Bar Graph 

thanks again 🙂