Solved

Modifying Month dimension in Calendar

  • 26 July 2023
  • 3 replies
  • 387 views

Userlevel 2
Badge +2

Hello Pigment community,

 

Quick one here. I want to modify the Month Dimension in my calendar but “Cannot update a protected property (eg. built-in properties of calendar dimensions)”

I’m currently showing Jun 23 (MMM YY) and would like to switch to Jun-23 (MMM-YY).

How can I tune my own Calendar?

Thanks in advance !!

Guillermo

icon

Best answer by abhilashsawla 27 July 2023, 05:36

View original

3 replies

Userlevel 4
Badge +7

Hi @Guillermo Puls 

Your requirement can be achieved by creating property in Month Dimension, Please following Steps to achieve it.

Step-1

Create New Property in Month Dimension with Unique List Item and apply following formula.

LEFT(Month.Name,3) & "-" & RIGHT(Month.Name,2)

So, Your output results will be:

 

Step-2
Click on the setting in Month dimension and In Special Property, Set that Property as Default display name
 

 

After that, if you create any metric than you can see that your month will be showing like MMM-YY format.
 

Hope, I have answered your question.

Thanks
 

Userlevel 2
Badge +2

Feeling like a newy, Thanks a lot @abhilashsawla.

 

 

Userlevel 4
Badge +7

Your Welcome @Guillermo Puls 

Reply