-
Best way to group data into bi-weekly pay periods
Several possible possible methods come to mind but each seem as though they could be more complicated than needed. I'm certain this must be a fairly common requirement so I suspect the best way to do this has already been established. My first thought was to use the master calendar and somehow append 'pay period start' and…
-
Simple count of unique responses by location
This should be easy I think. I have an app that produces survey response data in a pattern something like the simple example shown. Each row is a response to a question, and each response is tagged with a "ResponseGroupID" that ties them together as having been entered as part of a single "batch". I'm finding it easy to…
-
Qualtrics - associate responses based on question's answer
Using the Qualtrics API connector, I bring in the 'Survey Responses' report that depicts the user's answer to each question. When surfaced using the API, the data is returned with each question/answer as a row (vs. each response as a row as when extracted to Excel). This has the obvious benefit of allowing one to combine…
-
Yes/No dimension across multiple fields
I have a SharePoint list that contains over 50 choice columns, all with their possible response limited to [ 'Yes', 'No', 'N/A' ]. Is there a way to use the [ 'Yes', 'No', 'N/A' ] dimension in a card that shows a bunch of these columns at once without having to reference each separate column's value individually? Hoping…
