Pega Constellation Insights - Calculated fields - a new column required Month based on date

we have one dashboard in landing page contains date filed, is this any function we have in insights to calculate month from Date field ?

for example Date value is Nov 29,2025 , we need a new column of Month and value is Nov.

are we able to apply this calculation fields as promotional filters ?

@VenkateswararaoK

Infinity 25 does have support for using calculations in Insights. If there is not an OOTB function that meets your needs then you can include custom functions.

Refer to the following documentation.

What’s new in Insights '25

Using calculations in Insights

Specifying custom calculations

@Marc Alderman Thanks Marc , it worked i see one more issue once new record added or updated. the Promoted filters are not updated automatically. is there any way to fix this to update filters automatically without manual reload or refresh ?

@VenkateswararaoK currently no, there is no DX API call behind it to support autorefresh of data.

There are two items on our back, that I’m aware of, to address this:

  • Data objects support “refresh” endpoint EPIC-101580
  • Refresh Insight data on a scheduled interval EPIC-100318