Extracting Month using the extract function

Question & Answer
, ,
1

I am extracting the month out a date using the extract function and using that to build a graph ,
instead of the number in X axis is there any way I can get the month name?

image
image1621Ă—617 18.6 KB

2

You need to make a calculated field that maps the numbers to the name.

ifelse({CreateMonth}=1,'Jan',{CreateMonth}=2,'Feb',{CreateMonth}=3,'Mar',etc..
1 Like
3

Hi @Max , I am also having same above mentioned issue. I had tried the calculated field :

ifelse({CreateMonth}) = 1, “Jan”,
{CreateMonth} = 2, “Feb”,
{CreateMonth} = 3, “Mar”,
{CreateMonth} = 4, “Apr”,
{CreateMonth} = 5, “May”,
{CreateMonth} = 6, “Jun”,
{CreateMonth} = 7, “Jul”,
{CreateMonth} = 8, “Aug”,
{CreateMonth} = 9, “Sep”,
{CreateMonth} = 10, “Oct”,
{CreateMonth} = 11, “Nov”,
{CreateMonth} = 12, “Dec”, NULL)

and I got graph as below screenshot

image

But for the bars it is not in correct order. Is it possible to sort the months from Jan to Dec.