Thank you to whoever tries to help. I have not been able to figure out how to achieve the goal listed.
GOAL: To show the percentage for each plant of their PM status type in GalleryCt (example: see screen shot)
Stuck on #1
1. Obtain the total number of 'NAME OF PM' rows from the entire table for each distinct PlantGroup in GalleryCt
Not sure how to account for the filter after finding #1
2. Based on a filter of a third column named 'PM STATUS', obtain the total number of 'NAME OF PM' rows for each PlantGroup per status value ("Overdue", "Next30", "Current" **This last one comes from another table, but that I can figure out based advise from this solution)
I feel I can write the SUM and division for #3 once I can find the totals from 1 & 2
3.Once I have those totals, then we will divide the number of NAME of PM rows per status to find percentages for each group per status
_________________________________________________________________________________________________________________
GalleryCt ITEMS:
Sort(
GroupBy(
Filter(
'PF_PM_ Compliance_OverNext30',
'PM STATUS'.Value = "Overdue",
'SERVICE COMPLETED DATE' = Blank()
),
"PLANT_x0020_CODE",
"PlantGroup"
),
CountRows(PlantGroup),
SortOrder.Descending
)
This is my attempt but it is not working, but I feel it explains what I am trying to accomplish.
Total number of rows for 'NAME OF PM' per group
If('PLANT CODE'.Value=ThisItem.PlantGroup,CountRows('PF_PM_ Compliance_OverNext30'.'NAME OF PM'),"")
If('PLANT CODE'.Value=ThisItem.PlantGroup,CountRows('PF_PM_ Compliance_OverNext30'.'NAME OF PM'="Overdue"),"")
Additional info:
Plant group value is in the gallery - label named: LabelCt_PlantGrp
Gallery name: GalleryCt
Table Source: PF_PM_ Compliance_OverNext30
Secondary Table Source* for "Current" status: PF_PM_ Compliance_Current
*The tables are identical data sets. Divided the current status into its own SharePoint list to keep the row limit from being too large.
Thanks again to any that might reply.
