User Profile
dcohare
Helper I
Joined 6 years ago
User Widgets
Contributions
Usage Data Won't Refresh
Hi - I am trying to get the Usage Data Metrics for one of my reports. We haven't refreshed the usage metrics since September 2024 and yesterday, we tried to refresh. Got the error that the credentials were wrong, so we updated the credentials. The refresh last night was successful; however, when I go in today, I'm still getting the data from September and the error message saying the credentials are wrong. What do I need to do to update the usage metrics? Thanks! Screenshot showing successful refresh last night: Error message this morning:Convert Date/Time from UTC to Local Time When Data is in 2 tables
Hi, I am working on an office capacity report. This will have lots of screenshots. I have multiple data tables in Desktop: fromO365Logs: this shows the user, the IP address that they logged into on a given day/time OfficeIP: this shows the IP address of each physical office location OfficeDetails: this shows the details for the location of each physical location. This is linked to the OfficeIP dataset via a Many-to-One relationship. It is also linked to the fromO365Logs dataset, also via a Many-to-One relationship. TimeData: this shows the employee, the date that they submitted hours, and the type of hours they submitted (i.e. regular, OT, vacation, etc. I do not know if this table is relevant to my issue so am including in case The issue is that employees in our locations globally are showing up on the wrong date due to us using UTC. As an example, anyone who worked Monday, November 1 in Australia is showing up in our data charts as having worked on Sunday, October 31. Example: this employee signed in on 10/31 at 10:08 pm UTC, which is actually 11/1 at 8:08 AM local time: Is there any way, or any formula or function, that we can use to convert the date/time from the fromO365Logs dataset based on the Country field in Office Details (using the linked OfficeIP/Office Details)? I would, somehow, have to be able to look at the Country and the date/time and then use the formula to transfer from UTC to local time. Is this possible? Thanks.Colour Coding in Table Based on Data That's In a Different Data Table
Hi - I have two different data tables that are joined via a many-to-one relationship - "TimeData" and "HR HC". In the HR HC data table, I have a field for whether or not an employee works at a site location, but that field is not in the TimeData data table. My question(s) are: Is there a way to bring the data from the HR HC data table into the TimeData table? If not, is there a formula that can be written that says basically "If X employee has 'YES' in the Site Location field, then colour that employee's name purple in the table on the dashboard?" See here to see what I'm looking to do. Thanks for your help!
