I have made it so my gallery filters with this code:
If(!IsEmpty(Filter(Admin_LeadData,FullName = varUser)), Lead_Data, Filter(Lead_Data, AssignedTo.Value = varUser || LeadMember1.Value = varUser || LeadMember2.Value = varUser || LeadMember3.Value = varUser || LeadMember4.Value = varUser))
I have a chart that pulls data from a collection that currently pulls data in from a statement on my dashboard screen:
ClearCollect( colDash_StatusTrack, { Status: "Not Started", Count: CountIf(Lead_Data, Status.Value = "Not Started") }, { Status: "In Progress", Count: CountIf(Lead_Data, Status.Value = "In Progress") }, { Status: "Dead Deal", Count: CountIf(Lead_Data, Status.Value = "Dead Deal") }, { Status: "Completed Deal", Count: CountIf(Lead_Data, Status.Value = "Completed Deal") } );
I now would like this chart to display with the same filters as the gallery but I am not sure where to start with this. Tips/tricks/best practices, should this be as hard as I am feeling it is?
I have gotten this far but it does not filter the results for just the user like I think that it would - I see the count for all the entries into my SharePoint list.
ClearCollect(colDash_StatusTrack,{Agent: LookUp(Agents, FullName = varUser), Status: "Not Started", Count: CountIf(Lead_Data, Status.Value = "Not Started")} );
Collect(colDash_StatusTrack,{Agent: LookUp(Agents, FullName = varUser), Status: "In Progress", Count: CountIf(Lead_Data, Status.Value = "In Progress")} );
Collect(colDash_StatusTrack,{Agent: LookUp(Agents, FullName = varUser), Status: "Dead Deal", Count: CountIf(Lead_Data, Status.Value = "Dead Deal")} );
Collect(colDash_StatusTrack,{Agent: LookUp(Agents, FullName = varUser), Status: "Completed Deal", Count: CountIf(Lead_Data, Status.Value = "Completed Deal")} );
This will not produce my chart at all:
If(!IsEmpty(Filter(Admin_LeadData,FullName = varUser)), ClearCollect(colDash_StatusTrack,{Status: "Not Started", Count: CountIf(Lead_Data, Status.Value = "Not Started")} ); Collect(colDash_StatusTrack,{Status: "In Progress", Count: CountIf(Lead_Data, Status.Value = "In Progress")} ); Collect(colDash_StatusTrack,{Status: "Dead Deal", Count: CountIf(Lead_Data, Status.Value = "Dead Deal")} ); Collect(colDash_StatusTrack,{Status: "Completed Deal", Count: CountIf(Lead_Data, Status.Value = "Completed Deal")} );, Filter(Lead_Data, AssignedTo.Value = varUser || LeadMember1.Value = varUser || LeadMember2.Value = varUser || LeadMember3.Value = varUser || LeadMember4.Value = varUser))
Solved! Go to Solution.
Hi @KimberlyM
If(!IsEmpty(Filter(Admin_LeadData,FullName = varUser)), ClearCollect(colDash_StatusTrack,{Status: "Not Started", Count: CountIf(Lead_Data, Status.Value = "Not Started")} ); Collect(colDash_StatusTrack,{Status: "In Progress", Count: CountIf(Lead_Data, Status.Value = "In Progress")} ); Collect(colDash_StatusTrack,{Status: "Dead Deal", Count: CountIf(Lead_Data, Status.Value = "Dead Deal")} ); Collect(colDash_StatusTrack,{Status: "Completed Deal", Count: CountIf(Lead_Data, Status.Value = "Completed Deal")} ), ClearCollect(colDash_StatusTrack,{Status: "Not Started", Count: CountIf(Lead_Data, Status.Value = "Not Started" && Or(AssignedTo.Value = varUser,LeadMember1.Value = varUser,LeadMember2.Value = varUser,LeadMember3.Value = varUser))} ); Collect(colDash_StatusTrack,{Status: "In Progress", Count: CountIf(Lead_Data, Status.Value = "In Progress" && Or(AssignedTo.Value = varUser,LeadMember1.Value = varUser,LeadMember2.Value = varUser,LeadMember3.Value = varUser))} ); Collect(colDash_StatusTrack,{Status: "Dead Deal", Count: CountIf(Lead_Data, Status.Value = "Dead Deal" && Or(AssignedTo.Value = varUser,LeadMember1.Value = varUser,LeadMember2.Value = varUser,LeadMember3.Value = varUser))} ); Collect(colDash_StatusTrack,{Status: "Completed Deal", Count: CountIf(Lead_Data, Status.Value = "Completed Deal" && Or(AssignedTo.Value = varUser,LeadMember1.Value = varUser,LeadMember2.Value = varUser,LeadMember3.Value = varUser))} ))
Hi @KimberlyM
If(!IsEmpty(Filter(Admin_LeadData,FullName = varUser)), ClearCollect(colDash_StatusTrack,{Status: "Not Started", Count: CountIf(Lead_Data, Status.Value = "Not Started")} ); Collect(colDash_StatusTrack,{Status: "In Progress", Count: CountIf(Lead_Data, Status.Value = "In Progress")} ); Collect(colDash_StatusTrack,{Status: "Dead Deal", Count: CountIf(Lead_Data, Status.Value = "Dead Deal")} ); Collect(colDash_StatusTrack,{Status: "Completed Deal", Count: CountIf(Lead_Data, Status.Value = "Completed Deal")} ), ClearCollect(colDash_StatusTrack,{Status: "Not Started", Count: CountIf(Lead_Data, Status.Value = "Not Started" && Or(AssignedTo.Value = varUser,LeadMember1.Value = varUser,LeadMember2.Value = varUser,LeadMember3.Value = varUser))} ); Collect(colDash_StatusTrack,{Status: "In Progress", Count: CountIf(Lead_Data, Status.Value = "In Progress" && Or(AssignedTo.Value = varUser,LeadMember1.Value = varUser,LeadMember2.Value = varUser,LeadMember3.Value = varUser))} ); Collect(colDash_StatusTrack,{Status: "Dead Deal", Count: CountIf(Lead_Data, Status.Value = "Dead Deal" && Or(AssignedTo.Value = varUser,LeadMember1.Value = varUser,LeadMember2.Value = varUser,LeadMember3.Value = varUser))} ); Collect(colDash_StatusTrack,{Status: "Completed Deal", Count: CountIf(Lead_Data, Status.Value = "Completed Deal" && Or(AssignedTo.Value = varUser,LeadMember1.Value = varUser,LeadMember2.Value = varUser,LeadMember3.Value = varUser))} ))
@yashag2255 Thank you! This gets me so much further. I am happy to report that I am very happy with how this is now working in my app.
User | Count |
---|---|
136 | |
133 | |
78 | |
72 | |
69 |
User | Count |
---|---|
222 | |
136 | |
78 | |
60 | |
54 |