Skip to main content

Dear Pigment Community,

I hope you're doing well!

I am currently facing two challenges in my Pigment setup and would greatly appreciate your guidance:

  1. Freezing Data Entry for Weekends & Holidays:

    • I would like to restrict data entry for weekends (e.g., 06/01/2024 and 07/01/2024) and holidays (which I will updating in a different dimension) while keeping data entry open for other days.
    • This restriction should apply consistently for all weekends throughout the year.

  2. Customizing Date Formats in Column Headers:

    • I want to display the date in the column header in the format: 6th Jan 2024 and 7th Jan 2024 (instead of the default format).
    • This format should be applied consistently across all dates throughout the year.

If anyone has suggestions, solutions, or best practices for implementing these features, I would greatly appreciate your input!

Thank you in advance for your help!

 

Hi,

 

  1. You should be able to achieve this with Access Rights.
    • Create a Boolean property called ‘Weekend’ in the ‘Day of Week’ dimension
    • Pull the output of this property into another ‘Weekend’ Boolean property in your Days dimension with a formula
    • Create an Access Rights metric that is formula-driven based off the output of the aforementioned property in the Days dimension as well as an input metric to define holidays.
    • Apply the Access Rights metric to your data entry metrics.
  2. You don’t already have it, you will need to create a text property in the Days dimension that shows the date is your desired format. You should then go to the Block Settings for the dimension and make this property the Default Display Name.

 

Hope this helps,

Reply


Ask your question here!

Terms & ConditionsCookie settings