Average of Data/time custom field per day

Questions & Answers
1

Hello guys
Screenshot 2022-12-16 083812

I have a date/time custom field called “Time of detection”. I want to have average of its value in my table per day. for example at 09 Nov I have 5 issues that created, so i have 5 values for “Time of detection”. I want the average of these 5 values for every day.

thank you

2

@Elita.Kalane HI
could you please help me for this?

3

Hi,

The solution depends on what type of custom field is the Time of detection.
If that is a numeric field, you can import it as a measure. That will create a set of measures in the data cube, and you can use the “Time of detection created” to show the total of the Time of the detection per created issues in the selected period (e.g., date).

You can create a custom measure to show the average time of detection for created issues with a formula like this:

CASE WHEN [Measures].[Issues created]>0
THEN
[Measures].[Time of detection created]/
[Measures].[Issues created]
END

Note to set the decimal formatting for this measure.

Kindly,
Janis, eazyBI support

4

Hello,

thank you for your attention

my custom field is not numeric, it is a date/time custom field.

5

Hi,

Sorry for missing this point in your post.

The following formula gives the average date per issue created in the period:

TimestampToDate(
  Avg(
    Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
      [Measures].[Issues created]>0
    ),
    DateToTimestamp(
      [Measures].[Issue Time of detection]
    )
  )
)

Kindly,
Janis, eazyBI support