Display Month in Chronological Order in the Filter

Q&A
, ,
2

Hi @QS_User

Welcome to the Quick Sight community!

To display months as Jan, Feb, till Dec in chronological order in an filter, you need to create a calculated field that maps month names to their corresponding month numbers and then use the month number to sort the month names chronologically.

Example:

ifelse(
  {Month}='January',1,
  {Month}='February',2,
  {Month}='March',3,
  {Month}='April',4,
  {Month}='May',5,
  {Month}='June',6,
  {Month}='July',7,
  {Month}='August',8,
  {Month}='September',9,
  {Month}='October',10,
  {Month}='November',11,
  {Month}='December',12,0
)

Please refer the below community posts this might be helpful for you.