Using thhe Configure function field in reports to return the month from the sys_created_on field

[MandyHill]

Hi,

Does anyone know how to return the Month name from the sys_created_on field using the configure function field in reports? I want to have the month as a column in a table to allow me to report on number of incidents per month - I know this can be done on a time series graph but I need to present in a table format.

Thanks,

Mandy.

[Mark Manders]

How do you report a number on a table report? 

What is your exact use case here?

[MandyHill]

Hi,

I'm essentially trying to create a time series report in a pivot table.

So how many incidents were raised per location per month using the created date but the created date is a date/time field.
You can easily do it in a bar graph because there is a time series bar graph 'type' but I need it in table format, e.g.

	Incidents raised per month
	Jan	Feb	March
Location 1	5	12	9
Location 2	8	16	4

I was hoping to find a way to create a new data point for month name off the sys_created_on field that I could use as a column in a pivot table.
Thanks.
 

[Mark Manders]

You will need to add the data to the table (like a new field 'created in month') and have some logic run to fill that field so you can report on it. A pivot table shows fields that are on the form, so without the field there, you won't get your data. 

[MandyHill]

Hi,
My understanding is the Configure function field feature allows you to do this on the fly in the reports themselves.
I have been able to use the following to return the number of the month:

which then becomes a fields I can select in my report:

which displays like this in my report: 

So now I'm wondering if I can find a way to return the name of the month instead of the number.

Thanks.