search

stuartridout / teamlink

TeamLink is a free Microsoft Teams Power App using Dataverse for Teams. It is a space where your team can share there whereabouts for the week ahead directly in Microsoft Teams. Users can select who they want to 'follow' and see the upcoming presences of or can view by site to see who is planning to be on site on that day. TeamLink allows you then to message to see if the person wants to meet up for a coffee ... all from the click of a button!
MIT License
50 stars 2 forks source link

Inflated Presence Entries in MS Power BI Table Connected to MS Dataverse #50

Open slickspidey opened 1 year ago

slickspidey commented 1 year ago

I am trying to use MS Power BI to create a table that displays the office presence status of employees in my organization, as recorded in the "cr599_presence" table in MS Dataverse. However, the table is showing inflated numbers for some employees and I am not sure why. I am trying to show a count of the unique presence entries for each staff member, but some are showing more than the expected 5 entries for a week. Can you help me understand why this is happening or how to correctly show the count of presence entries for each employee? I have included an image for reference of what I'm trying to create with MS Power BI. Screenshot 2023-01-24 092255

slickspidey commented 1 year ago

Also, I am using the "Email" column as a unique identifier for each employee in the rows of my table because it provides the most accurate count of their presence. When I used the "Created By" and "Modified By" columns, the count for everyone's presence was significantly inflated, particularly for myself for some reason.