Extract Sprint Names from issue.fields.sprint.name

I want to do two things

  1. For each issue, show the sprint or multiple sprint name it has been
  2. In each project, how many issues are not assigned to any sprint meaning does not have a sprint name

I am trying to create a pre calculated measure for these. I am getting null when i try to extract Sprint Names from issue.fields.sprint.name

Hi,

There are standard properties in the data cube Issus sprints showing all the sprints issue has been and Issue sprint showing the current sprint.

Issues currently in no sprint have the (no sprint) value in the property:

Kindly,
Janis, eazyBI support