User define measure is not equals Custom property in the report with Time dimension

Questions & Answers
1

Hi
please, could you help or advise?

I do data import using REST SPI
I calculated the following columns:

  1. Exit_date - date/time (not all rows have this date). Imported as Property, Date Count Measure and Date Count Dimension
  2. Exit_days - decimal (not all rows have this date) - imported as Measures
  3. Exit_days (1) - decimal - clone of Exit_days - imported as properties for Key column.

The report is looking as:

Why_empty
Why_empty1849×858 76.5 KB

The questions are:
Why are some of the cells in column Exit_days empty, but some of them are not?
What is approach/logic?
I expect to have Exit_days == Exit_days(1).
if Time dimension is removed - everything is Ok, but I need time.
All IssueKey have the right Exit_day (November 2022 for this example)

please, could you help or advise?
Thank you ahead
DK

2

@DKostiuk

it is somewhat likely that data mapping is not correctly defined for the “Exit days” measure with Time dimension.
You could check that by selecting the “Exit date” (as property) in columns of your report.
I would guess that these 3 rows have date property against Nov 2022, but others don’t.

Please export and share the import options definition for your Rest API source application.

Martins / eazyBI

3

Hi,
you can - all dates are Ok

Import_definition_TEST
Import_definition_TEST1569×881 132 KB

and please, you can find the import definition in the google-doc file - Import Definition - Google Documenten

thank you for your support
DKostiuk

4

Hi,
Please add measure “Created_at” (measuere) in the same report columns and share the screenshot again.
Martins

5

Hi,

there is. I add the measure “created_at” (not property)

Import_definition_TEST_created_at
Import_definition_TEST_created_at1570×800 121 KB

6

@DKostiuk
Measure “Created at” is what links the issueKey dimension with the time dimension.
If there is no created at value at the created date, the value won’t be displayed at the Time period (if imported as measure).

Martins

7

Hi, Martins,

is it possible to import “Exit Days” with the link to “Exit_date” and time dimension?

8

Yes, then you would need to map “Exit date” field to “Time” dimension and skip mapping the field “fields created (1)” to time dimension.
eazyBI would let you map just one date field to “Time” dimension in the cube.

or you could leave the mapping as it is and acheve the results with custom calculations.

Try creating new calculated measure using this formula:

Sum(
Filter(
DescendantsSet([IssueKey].CurrentMember,[IssueKey].[IssueKey]),
DateInPeriod(
[Measures].[IssueKey Exit_date],
[Time].CurrenthierarchyMember
)
),
(
[Measures].[Exit days],
[Time].Currenthierarchy.Defaultmember
)
)

Martins

9

Thank you for your support