Question
4
Replies
119
Views
Posted: April 14, 2020
Last activity: April 15, 2020
Solved
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..
Posted: 9 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,
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.