How can I get a value from a measure as a dimension in Easy BI
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?
1 answer
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.