Creating a working calendar with holidays marked in Pigment

Hi Spanadan98! 

To make things clear: do you need the view to be as shown, or do you want a metric that holds the calendar days to be used in calculations, such as counting working days and holidays?

Hello ​@francois 

I want a view as shown in the screenshot. I want to show that calendar table on a board along with the timesheet of employees. I want the employees to see/visualize the national holidays that they have throughout the year.

Thanks!

Hey ​@Spandan98 

Here’s what I’ve managed to build:

By creating a calendar that has Day, Week and Month, and using two metrics structured by Day, you can pivot a table using Day > Month in pages, Day > Day of Week as columns and Day > Week followed by the metrics in rows.

I’ve used two metrics, one with the day count (structure: Day, format: Integer, formula: CUMULATE(1, Day, Day.Month)) to display what day it is and another one (here, Name of the day) that displays whatever text you want to display.

Since Pigment can’t properly guarantee there will be only one cell, you have to set a default summary method as illustrated above - I’ve chosen Concatenate. 

In my case, Sunday was shown as the first day, so I’ve also had to add a second ID, and sort the table using that one.

You can then play with the row height and formatting colors to make it look as you want, and add the relevant data points such as your user’s timesheets.

Hope this helps!