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
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.
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:
The second article is based on a Sharepoint list, but the concept is the same - your data source will just be different.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.