The Workplace Analytics team is excited to announce our feature updates for January 2020. (You can see past blog articles here). This update covers our latest feature, an improvement in the way that admins can handle changes in organizational data that affect auto-refresh queries.
In response to customer feedback, we have given admins a way to respond to schema mismatches that might occur when they upload organizational data. Organizational data is structured by columns (fields), and admins can change or delete those fields. In turn, these changes can affect how auto-refresh queries function in Workplace Analytics.
Queries can use the fields of organizational data in various ways – as filters to decide the query population and the query parameters, and as output columns in query results. During upload, the admin can choose to append the new data to the old, or to replace the old data with the new. Either choice can affect the functioning of queries that have been set to run automatically on a schedule (“auto-refresh”):
If at least one auto-refresh query is affected this way, Workplace Analytics lists the affected queries. It also shows a warning and asks the admin to confirm whether to proceed:
If the admin selects Next, the upload completes, the changes to the data are made, and all affected queries are prevented from auto-refreshing. (The last execution results of affected queries remain available.) If the admin selects Back, queries are unaffected and the admin is returned to the page for mapping fields. There, they can decide whether to map the fields differently or to start over with a different file of organizational data for upload.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.