Copy value from page to another dimension

Hello
We are using Eazy bi for reports in Jira Data Center.
We have 2 dimensions (Scripted fields that return issues) that contain same issues scope.
We want to chose in one page dimension and get in second page dimension the same value automatically in order not to choose twice (because there are 2 different measurements).
How can we do it?

Thanks in advance,
Anna

Hi Anna

Welcome to the eazyBI community, and Happy New Year!

In eazyBI, all dimensions are independent; they “do not know” anything about values in other dimensions unless there are specific measures for that.

When dimensions are selected in Pages, there is no option to create a measure that explicitly checks and returns values based on selection in other dimensions.

However, if dimensions are somehow related (like Projects and Fix versions, where there are versions for each project), you can use the nonempty option in Pages. This option allows retrieving a subset of values from the second dimension based on the selection in the previous dimensions. Read here: Create reports

Best, IlzeLA
support@eazybi.com

Hello!
Thank you!
Our problem is that we don’t want to choose twice the same values in different dimensions .
But we must do it because our reports are based on different dimensions in the dashboard.
How can we prevent this double-choosing?

Best regards,
Anna

We are using Eazy bi for reports in Jira Data Center.
We have 2 dimensions (Scripted fields that return issues) that contain same issues scope.
We want to chose in one page dimension and get in second page dimension the same value automatically in order not to choose twice (because there are 2 different measurements).
How can we do it?

Thanks in advance,
Anna

Hi!

Unfortunately, except for the Page nonempty option, which does not seem to be helpful in your case, there are not many other options to “link” selected values.

The workaround I can imagine: if the issue has two identical values in two custom fields, won’t filtering only by one of the field’s values be possible? In case you have two measurements, where one is looking for one custom field while another is checking the second custom field, it is probably possible to rewrite the second measure so that it would also look for the first custom field value.

Let me know if this approach sounds useful and if you need my assistance with that!

Best,
IlzeLA, support@eazybi.com