Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm following along the video titled Create a Master Calculated Dimension. As per instructed by the video, I've created a new master dimension called "Month-Year", where the expression is `=Month & '-' & Year`
When I edit the sheet and add the recently created master dimension to the sheet, it is added as a table column with the name '=Month & '-' & Year' instead of its actual name "Month-Year".
Is this a bug? In the video, the table has the right name.
But in my sheet, this is what I see:
Here I'm sharing the configuration of my master dimension. As you can see, the field is name appropriately named.
Any insights are valuable! Thanks 😄
In image PaoHL_2-1730904595182.png try placing the title you want to use in the "label expression" field.
Kind regards.
Just replying to add that I tried this using single quotation marks around the desired name and an equal sign before the whole string (='Month-Year') in the "Label expression" field as you suggested, and it worked.
In image PaoHL_2-1730904595182.png try placing the title you want to use in the "label expression" field.
Kind regards.
Hi Frank,
Thank you for the suggestion. It seems that field is for something else, because it has a formula button:
Screenshot of Master Dimension configuration screen, where desired name for Master Dimension has been written in the "Label expression" field
I tried it nonetheless, but this was the result:
Screenshot of a table visualization containing the Master Dimension "Month-Year" as one of its columns. The name has been changed to simply a dash"-"
I tried using quotation marks around the string too, thinking that would work, but actually, the field gets highlighted red and it is not possible to change the configuration any more:
Screenshot of the Master Dimension configuration window, where the desired name has been written as a string surrounded by quotation marks in the field "Label expression".
I also tried adding an equal sign before the string in quotation marks, but that resulted in the field highlighted in red as well.
😕
Just replying to add that I tried this using single quotation marks around the desired name and an equal sign before the whole string (='Month-Year') in the "Label expression" field as you suggested, and it worked.