bar chart-category label- text conversion fails or at least I do not fully understand what the problem is...

Hi,

I thought I could change the "label" of a bar chart (e.g.) diagramm by working on the 'categories' field of the a!columnChartField() function.

But it seems , I can not.

My diagram: ("Monat" = "Month"):

My requirement was....

....to have the category labels not displayed as "1,2,3..." but as "Jan, Feb, Mar..."

My approach was...

...to wrap the "categories"  field of the a!columnChartField() function with a text(x,"mmm") function, as follows,

a!columnChartField(
      categories: {
        text(index(
          local!datasubset.data,
          "MonatAbreise",
          null
        ),"mmm")
   

But I get...

...only "Jan, Jan, Jan..." in the chart  as displayed here:

What is my mistake?

Thx for your ideas...

  Discussion posts and replies are publicly visible