Description

We would like the administrators to be able to see the number of processes created on each of their solutions per month on Evolve.

Also for them to be able to sort these processes by market. (corresponds to a field in the solution).
I have already promoted the "market ID" field so that it can be used in a report.
But I still can't create this report, could you help me?

Applies To

Evolve 20.x

Cause

How too

Solution/Immediate Workaround

Go to admin and reports create a new report then insert the below option:  

  select DateName(month,EOMonth(Procc.CreationDate))+' '+ cast(Year(EOMonth(Procc.CreationDate))as nvarchar) as 'Month',
Procc.SolutionName as 'Solution Name',count(1)as 'Number of process created',mark.MarketId as 'MarketId'
from RPT_ProcessReportingDetailsView  Procc
join RPT_MarketSolution_LIC_APP_FOR mark
on mark.DataFileID= Procc.DataFileId
group by EOMONTH(Procc.CreationDate),Procc.SolutionName,mark.MarketId

Try this and replace RPT_MarketSolution_LIC_APP_FOR as your solution view name

you should be having the SQL view in the right panel. You can copy it and replace it in the query I provided:

The output would be like this:

Additional Information

https://docs.winshuttle.com/evolve-en-20-1-online-help/reporting-sql-views/RPT-ProcessReportingDetailsView.htm