How can we use two dimensions in Columns

Questions & Answers
1

As in the screenshot I have created two different reports in eazybi for two different fields.

Can I have them in the single report ?

image
image

when i try to add two dimensions in a column the report looks as below in the screenshot

image
image805×357 14.8 KB

I want the second dimension result to be shows in the table format side by side

image
image971×361 25.2 KB

2

Hi @Amzad,

I recommend removing both dimensions from the report columns and defining new calculated measures instead. For the number of issues with “Yes” in Test Data Created/Available the formula could look similar to the one below:

([Measures].[Issues created],
[Test Data Created/Available].[Yes])

You can define similar calculated measures for Tes Data Definition Completed or even a combination of both. For example, to retrieve the number of issues with both fields marked as “Yes”, the formula could look similar to the one below:

([Measures].[Issues created],
[Test Data Created/Available].[Yes],
[Test Data Definition Completed].[Yes])

Then, you can use these calculated measures in your report on a single level.

Please look at our documentation page for more information on defining calculated measures - ​Calculated measures and members.

Best,
Roberts // support@eazybi.com