Compare two custom fields with native field

#1

Hello, I´m looking for a solution how to compare two custom fields and one native field ( Fix version). There is an option to import those custom fields as Dimension or as Property.

The goal is to compare those two custom fields and one native field (Fix version) between each other.
Expected output after comparison is text field/string

Below is table with values which shows possible options and the yellow highlighted column shows the output

table
table.PNG799×124 4.01 KB

Any idea what needs to be done ?
Thanks in advance for any response

#2

Hi,

Welcome to the eazyBI community!

In eazyBI you can compare fields using MDX (and create calculated measures for output).
If you expect to compare dates, you can use regular expressions to extract and parse the date from string value and then use date functions (like “DateCompare”, “DateBetween” etc) to compare dates and return the custom string as output.

If you want to match full string vs another string, you could use Matches function.
As I understand it would work only at Issue dimension issue level here as only there you would see custom field imported as property.
Assuming that you want to compare issue Fix Version with two custom fields imported as property the question would appear - what to do if an issue has more than 1 fix version.

I guess you could reach out to support@eazybi.com with more details on this use case - how exactly do you want to display results (what dimensions used in rows/columns, what dimensions used in page filters) in your report.

Martins / eazyBI support