Report with information from Activities

[Coachen]

Hi

I hope you can assist and tell me how to create a new report

We have added a “Fiel” that we call Handover, there we have a Dropdown list

There are some statuses that we need.
Now we need a report to state when we change from one status to another status

Some information that can be useful, We have Handover impotent as and Dimension & Property. But I can´t select different status
I can see it under Activities in our project

Is this possible to create and report on?

Thanks in Advance

[Marilou]

Hi @Coachen

I’m not exactly sure I understand what you mean.

From what I understand, your custom field “handover” is a drop down and only 1 variable in the drop down can be chosen at a time.

You have imported the field as dimension and property in eazybi.

You want to report on transitions between items in your drop down list.

ex: Handover has those items in drop down: Start, Progress, review, done

Maybe you want a report that answers: During the week, how many issues were transitioned between handover.Start to Handover.progress.

For this, you can likely use the hidden measures Transition to and transition from

Hope this help,
Marilou

[Elita.Kalane]

Hi @Coachen

Thanks for posting your question! I must agree with @Marilou - it is not entirely clear what kind of a report you are attempting to build (a screenshot or more details would be very useful, if you don’t feel comfortable sharing here, you can reach out directly to us at support@eazybi.com, referring to this community post).

However, for you to be able to track single select drop-down field history, you first must enable the value change import.
If you don’t see the selection to import value changes, add these lines in the Additional advances setting section (see screenshot below)

separate_table = true
changes = true

Then make sure you import the field as a Dimension, Property and also value changes options are selected

• Use the Handover dimension in rows to see different Handover statuses

• Use the Time dimension to see changes over time

• Use the Issues history measure to see how many issues had each Handover value at the end of each time period

You can learn more about issue change history here - Import issue change history

Best,
Elita from support@eazybi.com

[Coachen]

Hi

Thanks for getting back to me

To add some more info
We have those options below and we want to create a report that shows when we change from (Example) Received, not reviewed - Received Not Complete (result will be in days)

Here is what we have in Activites

So here we 1 day when we changed status from not reviewed to Received and approved

We need this report to see if we meet our SLA

[Elita.Kalane]

Hello @Coachen

Thanks for the follow-up!

So in fact, you want to see how long the ticket stays in the particular selected option?

Start by enabling the value change import, as I showed in my response above.
For you to be able to analyze the field’s history, you need to import the value changes (your field should be imported with all these checkmarks enabled)

Then similarly as my colleague Gerda shows in this community post - Is it possible to show the amount of time tickets were flagged during Cycle Time? - #3 by gerda.grantina select measure Days in transition along with your dimension “Handover Documentation” in report Columns.

Best wishes,

Elita from support@eazybi.com

[Coachen]

Hi
I have tried to do this to my report but I cant fetch info from our Handover different status/changes

And don´t know how to procced
If there anything to do in Advanced Settings for Flagged?

Noticed under Custom Fields that I can´t Mark Import Value Changes

Is there a way to do this?

Thanks for your support

[Elita.Kalane]

Hello @Coachen

Thanks for the follow up!

Indeed. You have to adjust the settings to be able to import the value changes. Find that field in your import options under the Custom Fields and click on “edit” the field.
Please also take a look at my first response in this conversation thread, where I have shared the settings that must be added and the screenshot of how it should look. Once you add these settings, you will be able to import the value changes.

Best,

Elita from support@eazybi.com

[Coachen]

Hi

Now I have added so I can import Value changes

I added this in Additional advanced settings

But should I even add some in Custom JavaScript code?

Or how should I be able to see for how many days on the different status?

Br

[Elita.Kalane]

Hello @Coachen

Thank you for the follow up.

There may be some confusion.

Previously, you mentioned the following:
We have those options below and we want to create a report that shows when we change from (Example) Received, not reviewed - Received Not Complete (result will be in days)

That made me assume you want to see how many days the issues stayed in the particular values selected in the Handover Document field.

Now you are mentioning you want to see the days in Statuses? Please clarify what is the desired result?

If you want to see how many days the issues stayed in the Handover Document field selections, please create your report as follows

1. Add issue dimension in Rows
2. Select measure (From Measures dimension) named “Days in transition”
3. Add Handover Document next to measures dimension → In Columns. Select the Handover document members.

See screenshot below how your report should look:

If you also want to see in which status the issues were, please use the Transition Status dimension.

The difference between Transition status and Status dimension is that Transition Status interacts with historical measures (such as “Days in transition”). The Status dimension only displays results for the issues in the status currently. From what I understand from your use case - you want to see how much time issues spent (historically) in the particular members of Handover Document field. Hence, you had to import the value changes, and that’s why the historical measures and dimensions need to be used.

Best,
Elita from support@eazybi.com

[Coachen]

Hi

Maybe I don´t understand or have the right knowledge to create this report
We want an report that can present this in a table as example below

	Not received	Received, not reviewed	Received, not complete	Received and approved
Customer X	1	2	1	3
Customer X	5	1	4	2
Customer X	9	2	3	1
Customer X	3	6	6	3

But right now i am stuck and don´t know how to proceed

This is the what I get

[Elita.Kalane]

Hello @Coachen

I can see that you have not selected the measure “Days in Transition,” but you still have the measure “Issues created” selected in your report.

Please take a look at this loom video where i’m showing how you can create your report - Issues - Test account - eazyBI - 24 February 2026 | Loom

If you are new to eazyBI, I highly recommend taking a look at our learning center, which will help you learn about eazyBI in an interactive way - Learning Center

Best,

Elita from support@eazybi.com