+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
Best answer by abhilashsawla
View original
+6
Hi
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
+2
Feeling like a newy, Thanks a lot
+6
Your Welcome
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.