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.
User | Count |
---|---|
250 | |
248 | |
81 | |
45 | |
30 |
User | Count |
---|---|
340 | |
261 | |
122 | |
64 | |
58 |