Benchmarking Data

Question

Hi everyone,

I'm looking for some tips on how I would be able to reconcile old data with newly added data. This data will be evaluated from a monthly basis. If you take a look at "capture 6", this is what the table will look like. I want a workflow that will record new data based on present date, and add it to prior date data. At the end of the month, I would eventually like a bar chart showcasing the data to be presented.

Please note that this data is intended to be a performance benchmark. Please let us know if you require any more information! Thank you

Capture 6.PNG

Capture 7.PNG

CoG · Answer

Where does the old data currently reside? Depending on what you are already storing and where, how you do things will look a little different. If you need to know what product does the best/worst on a month-month basis, based on data from daily reporting file, then you will need to at a minimum keep track of every product's performance for the month (which you can update based off of the daily report, or add new row at the beginning of new month).

A separate workflow or process can be built to handle generating the report on a monthly basis, which would involve doing simple sorting (Sort Tool). If your old data is broken down into day-day results, then the monthly report workflow would just need to aggregate (Summarize Tool) for each month you want to analyze.

If you have more specific questions, I'd be happy to provide more specific answers.

Happy Solving!!!

KevinQVo · Answer

Hi @CoG

Thank you for your response!

The database is based on a daily reporting file. For instance, let's say I have a group of products that I am selling, and want to track what product does the best/worst on a month to month basis. I need help with creating a workflow that will record data new data and add it onto the old data.

I hope this clarifies it more!

Thank you again!

CoG · Answer

What do you mean by reconcile? Do you have a database with the old data that you are trying to overwrite or add to? It depends on your exact circumstances, but just adding to previous data is generally a good way to go. Then to create the bar chart, you'd just need to filter off data outside of your date range of interest. What do you need help with in particular?