Question
4
Replies
79
Views
Posted: 6 months ago
Last activity: 6 months 1 week ago
Display Count as per month
Hi
We have a report definition showing volume as per createdatetime month.
but my report is showing Aug 50 Aug 70
Aug 22
it shows as 3 AUG sum for single id
Rather it should show as single AUG 144
Attached screenshot for better understanding..
Accepted Solution
Posted: 6 months ago
Updated: 6 months ago
Posted: 6 months ago
Any suggestion on how we can get month name from Funtion Alias?
Posted: 6 months ago
Hello,
To get the month name from the DateTime value, use the following expression in the expression builder.
@(Pega-RULES:DateTime).FormatDateTime(@(Pega-RULES:DateTime).CurrentDateTime(), "MMM", "", "")
Thanks,
Posted: 6 months ago
I dont think we can write Expression in report definition
Currently, I think you are displaying the month value by using the format but the count is getting for each date. We need to have custom function alias to get the month name from the DateTime value, then we can get the count per month.