Hi everyone, i have searched to the best of my knowledge, but i can't seem to find the right method.
I have an excel sheet to monitor log ins. More importantly, if it was an incorrect password.
My table called "AuditLog" has
3 columns:
I would like a pie chart to pull the data from an excel sheet (thats already a connection) and just give me a visual representation of how many successful vs failed log in attempts.
Any help, would be super.
Thanks,
Joe.
I learned how to use pie charts from this video:
You would want to group by Name, Successful, and Failed and then sum those groups.
Below is the code that i used and worked well for me.
AddColumns(GroupBy(DataSource, "ColumnName", "group"),"SumOfCategory", Coalesce(Sum(group,cost)))
Take a look at the following articles:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/use-line-pie-bar-chart
and
The second article is based on a Sharepoint list, but the concept is the same - your data source will just be different.
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
279 | |
236 | |
84 | |
37 | |
35 |
User | Count |
---|---|
356 | |
240 | |
130 | |
71 | |
50 |