Assistance with defining and operator in easybi

M.S April 1, 2018

I want to define the following formula in easybi and can't find a way to do it:

(("Found in Version" in (aaa) AND fixVersion is EMPTY) OR fixVersion in (aaa))

 

thank you

1 answer

0 votes
Daina Tupule eazyBI
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 16, 2018

I will assume the Found in version means Affects version. The example below uses this assumption.

 

You could use tuples to count issues with particular values. You can search and bookmark for particular member name you can use in the tuple. 

I will count up two tuples. The first tuple will count issues found in unreleased version AAA (Affects version) in project AAA and with no Fix version. The second tuple will count issues planned to release (Fix version) with unreleased version AAA in project AAA.

 

Here is an example formula:

([Measures].[Issues created],
[Affects Version].[Project AAA].[Unreleased].[AAA],
[Fix Version.By name].[(no version)])

+
([Measures].[Issues created],
[Fix Version].[Project AAA].[Unreleased].[AAA])

 

Daina / support@eazybi.com

M.S April 17, 2018

it helped a lot.

thank you.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events