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?
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: