how to create in SAP C4C a report that measures the days an opportunity has been in a sales phase

[dcerruti]

Good morning,
I need to create a report that measures in days how much the opportunities have been in a specific sales phase.
If you go to the different opportunities you can see the history (the dates of when they entered the phase and the end date with the relative duration).
I would like to point out that I have already configured the opportunity history in the scoping.
I tried to use the Opportunity History as a data source but it does not retrieve that data.
The problem is that when I try to create the report no data source retrieves that data. It is not possible to create Key Figures because the data available based on the different data sources do not have the necessary data (e.g. end date of phase - start date of phase).
Furthermore, I have verified that using the opportunity hader as a data source it is possible to analyze the days in which the opportunities are in a sales phase, but when they exceed it they are no longer counted.
Any suggestions?

[clovismuller]

Hello,
There is a standard field in the opportunity called "Days in the sales phase", which the system automatically calculates how many days the opportunity has been "stuck" in the current sales phase. Maybe it can help you.
In the scenario of counting how many days an opportunity has been in each sales phase, and storing this as unique information for each phase, I believe that a PDI development will be necessary to solve this.

Clóvis Müller

[dcerruti]

Hello and thank you very much, that data indicates how long an opportunity is being in a sales phase, not how long it has been in a phase (a phase that has now passed). I don't know if I was clear...I need data from the past, not from the current situation.