Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Changing table column name using variable

Hello,

 

I have a column which I've renamed "Year to Date" in a table visualisation. If I set a variable somewhere to May is there a way to program the column heading to be "May YTD" (i.e. put the month name in automatically)

 

Thanks for your help,

 

CM

Need Help

1 Reply

  • Ruksuro's avatar
    Ruksuro
    Helper III
    8 years ago

    I don't beleive this is possible to make dynamic for the end-user as it is defined at load stage.

     

    I would recommend adding a new measure which returns a string which you can then use as a title, either in the visual itself or on a card above.

     

    I don't know your specifics but something like:

     

    Title = if(hasonevalue([Month]),min([Month])&" YTD","YTD")