Grab a total percentage from a group of users under 1 location only.

[Matt1228]

I have multiple employees under 1 location which each employee has a set range of questions that need to be answered. I want to grab the overall percentage of completion of those questions into a column for the location. So if there are 5 employees with all different overall completion percentages, I want to grab them and basically see how far along the store is. Another tricky thing is I want to use this info across multiple tables. I have a location table that list all the locations and then on my Training table I have a status scoring column. Any guidance will be appreciated. Thanks 

[Swoopy]

Please show the structure of your tables. It would be easier to understand and give you ideas.

[Matt1228]

Here are some screen shots. I want the Overall % trained to average out for the location based on the employees percentage. I also want to display that in the Location data table. 

[Swoopy]

I'm not sure if my understanding of your requirements is correct.

On the Location data table, if you add a virtual column having expression like,

AVERAGE(
   SELECT(Training Status[Overall % trained],
      [Location] = [_THISROW].[Location]
   )
)

will this give what you're looking for?

[Matt1228]

The formula worked but only returned 0% no matter what. 

[Swoopy]

What is Expression used for [Overall % trained] and what is its type used ?

[Matt1228]

formula is  ([week 1 trained]+[week 2 trained]+[week 3 trained]) / ([week 3 questions]+[week 2 questions]+[week 1 questions])

[Swoopy]

Does this formula return the 18% & 87% ?  I wonder what the full names of the last 2 columns are, and why their % are the same (how are they calculated?).

[Austin_QREW]

Hi @Matt1228 ,

Is this an Employee Onboarding App? If not, what is the main function of the app? May be able to send you a template app that can help you out with these features.

Thanks!

Austin from AppSheet Training

[Matt1228]

Sorta. So new location has new employees. We use the app as a training guide for them. My training data has questions that we train. Overall percentage of all the questions that are selected "Trained" comes back as a percentage. I want the overall percentage for all the employees in that location. 

[Austin_QREW]

Awesome! Take a look at our Employee Onboarding App and see if the Activity Log in the hamburger menu is similar to what you are looking for. If you are looking for something more specific than this let me know and I can make some updates to accommodate your use case. Hope this helps!

Thanks!

Austin from AppSheet Training 

[Matt1228]

I sent you a PM with the app so you can get an idea of the layout I have. Not too sure If I can post it openly or How to just have the look under the hood option. Thanks