objectcomputing / check-ins

Other
7 stars 7 forks source link

Implement pulse survey report #2357

Closed mkimberlin closed 1 month ago

mkimberlin commented 1 month ago

As a Team Member (with appropriate permission), I want to view a report on pulse survey data so that I can be attentive to the needs of those in the organization.

Acceptance Criteria:

mvolkmann commented 1 month ago

@mkimberlin For the line chart I assume we want dates across the x-axis and scores (1-5) across the y-axis. Correct?

Since everyone won't report their pulse every day, we will have to make some assumptions. How about these?

mvolkmann commented 1 month ago

@mkimberlin For the bar chart I assume we want team members across the x-axis and average scores over the selected date range across the y-axis. Correct?

mkimberlin commented 1 month ago

@mkimberlin For the line chart I assume we want dates across the x-axis and scores (1-5) across the y-axis. Correct?

Since everyone won't report their pulse every day, we will have to make some assumptions. How about these?

  • If a person hasn't reported pulse scores (internal and external) for a given day, we will assume they are the same as the previous day for which they reported scores.
  • If there is no previous score, we will assume scores of "satisfied" (4 out of 5). These assumptions will allow us to compute an average score for all selected members for any day.

WRT the x and y axis, you are correct.

I don't want to assume anything about scores. I want to give the average for the scores that we have. If a day has 5 responses, we add those up and divide by 5. If a person didn't respond, they simply don't get included in that calculation. If we don't have any responses for a given day, then we don't plot a point for that day.

@mkimberlin For the bar chart I assume we want team members across the x-axis and average scores over the selected date range across the y-axis. Correct?

I want a bar on the x axis for each possible score (1-5) with the y-axis being the number of responses.

So you would see that X people responded with a 1 and Y people with a 2 and so on...