How can I get a value from a measure as a dimension in Easy BI

salinakarki00

I need to create a monthly report with the Project, Project Manager, and Story completed. I have the field "Project Manager" as a measure but I need it as a dimension because when trying to show the data month by month the project manager field is repeated which I want to avoid. Please help if there is any solution to this, can this be done using a query?

Ilze Krauze

Hi,
Welcome to the Atlassian community!

In eazyBI there is an option to drill into a specific dimension for one measure only.

If you click on the measure header in the table, you can choose to Drill into >> Time >> Year.

When Time dimension is added, you can select the specific year and drill further into a specific level:

The result could look like this:

Let me know if that works for you or if you have more questions.

Kindly,
Ilze, eazyBI support