Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,359,747
Community Members
 
Community Events
168
Community Groups

EazyBI - calculating problems or import from database

Hi, guys
I've got two tables from two reports for the sake of simplicity, let's take the numbers 501 and 305.

Report 501 is about scope of test and got column:
Zawansowanie kroków = Advancement of the test step,
which contains measure: 

CASE 
WHEN CurrentTuple(VisibleRowsSet()).Item(0).Name = '$total_aggregate'
THEN
Avg(VisibleRowsSet(),
([Measures].[Count of test step succes] + [Measures].[Count of test step cancel]) / ([Measures].[Count of test step])
)
ELSE
([Measures].[Count of test step succes] + [Measures].[Count of test step cancel]) / ([Measures].[Count of test step])
END

 Table 501.PNG


Report 305 is about daily progress and got column:
Zaawanoswanie testów = Advancement of the tests,
which contains measure:

IIf(
DateDiffDays(
DateWithoutTime([Time].CurrentHierarchyMember.StartDate),
DateWithoutTime(Now())
) >= 0,
[Measures].[Advancement of the tests (all)], NULL)

Table 305.PNG


I expected the result of calculation will be the same figure. So the total of the column form report 501 will be the same as the row from current day from report 305, but it isn't.
Is this problem with calculation in measures or with import from database? 

If you have question about any details feel free to ask.

1 answer

0 votes

Hi, @Rafał Kiersztejn 

 

Please, contact eazyBI support with more details.

We need to see the report definitions containing the full details of the report design, so we can check if it is expected that the results in those two reports should match.

 

Kindly.

Janis, eazyBI support

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

4,955 views 18 31
Read article

Atlassian Community Events