Is it possible to extract month from Jan to Dec?

Question & Answer
, , , , , , ,
1

I had used extract function for extracting month and I got 1 to 12 integers as corresponding month. 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.

2

Hi @Sheena123 - This is bit tricky and sorting on the basis of month will come in down the line. As a work around, you can add some spaces to sort it. Can you please try the below code.

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)

This is NOT an efficient solution but a work around. Please test it.

Regards - Sanjeeb

1 Like
3

Thank you, will try it.

4

Hi @Sanjeeb2022 , This solution is working. Thank you.
In the above screenshot tooltip showing Jan to Dec. Whether it is possible to change the language to Japanese ? Not switching language for entire quick sight. Only changing the chart tooltip, x-axis values like chart values.

5

Hi @Sheena123 - Not sure whether we can change to Japanese or not.

Hi @duncan @DylanM - any idea whether we can change the language to Japanese or not.

Regards - Sanjeeb

6

Hello @Sheena123 & @Sanjeeb2022 !

I do not believe there is a way to change specifically the tool tip. I can mark this as a feature request for the Quicksight team!