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.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
205 | |
187 | |
77 | |
49 | |
37 |
User | Count |
---|---|
318 | |
262 | |
122 | |
73 | |
60 |