Group by (or breakdown) by Month of creation

[KirillZh]

Hello,
I’d like to create the following report:

It should be a PieChart showing all won deals in last 30 days, the breakdown (or grouping) dimension should be the Month of creation. Unfortunately, I can’t find the Month of creation as a breakdown property. Do you know it is possible, if yes - how to do it?

[karstenkoehler]

Hi @KirillZh,

As far as I know, this requires an additional calculation property. Using the month() function, you would first translate the date into the month: Create calculation and rollup properties

Once you have that property, you can use it as a breakdown on your pie chart.

Best regards!