Fiscal month name

[reachbgk]

I have used fiscal_month_offset to create fiscal calendar for my client. For date timeframes I see options for fiscal_quarter, fiscal_year, fiscal_month_num but there is no fiscal_month_name. Do I need to write a case statement and convert the numbers to month names

[Maddie]

Hi reachbgk,

The dimension fiscal_month_name would be the same with the month_name dimension, so you can use month_name to display January, February etc.

If you want to show them in order, I’d select month_name and fiscal_month_num in the data tab and hide the fiscal_month_num in the visualisation.

If this does not work, could you please explain briefly what you are trying to achieve?

Best,
Maddie | Redkite

[Cyril_MTL_Analy]

Maddie is 100% right.

I would add that you can also use the order_by_field parameter.

But you would have to create a specific dimension for that, not under the dimension_group.
So something like:

  dimension_group: created {
    type: time
    timeframes: [
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year,
    ]
    sql: ${TABLE}.created_at  ;;
  }


dimension: created_fiscal_month_name {
  group_label: "Created Date"
  label: "Created Fiscal Month Name"
  type: date_month_name
  order_by_field: created_fiscal_month_num 
  sql: ${TABLE}.created_at ;;

[reachbgk]

Thank you Maddie and Cyril, I see what you are saying. I think I had myself confused from overthinking.
Appreciate your input and help