Hi,
I have a metric named current year with year as data type and no dimension. purpose is to automatically update the current year every year. Is this possible to achieve in pigment and how?
Thanks in advance
Hi,
I have a metric named current year with year as data type and no dimension. purpose is to automatically update the current year every year. Is this possible to achieve in pigment and how?
Thanks in advance
Best answer by CDALMAY
Hi
Yes it’s possible. What you can do is the following :
IF(Set_Current_Year = Year,
TRUE
) 

You will then be able to use those variable in tables/boards and in a single place change the Year to be displayed (refresh your page if it doesn’t refresh automatically).
Note : I usually do the same for Month and Quarter.
Note 2: If you want the year to be automatically populated on Set_Current_Year you can leverage the metric today (below is how to create it by
TIMEDIM(today,Year)
Hope this helps,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.