I'm trying to use Alteryx to do benchmarking. I have a series of facilities with survey questions and answers, and I want to compute metrics within the same facility for all facilities. There are about 130 different metrics. I'm also working with a prior analyst's work, where the metric definitions are next to each metric number on a different table. A toy example is below.
My thoughts on my options:
- Find a way to perform these calculations (all within the same facility as a grouping) where I can use the metric definition (from excel ideally) as input as the metric definitions as a custom formula input.
- Re-define all these metric calculations within Alteryx, although I'm not sure the best way to do that without creating a giant workflow.
I welcome any thoughts on the right tool for the job. I can use Qlik or Excel also.