Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator III
Creator III

Public holiday and weekends

Hi All,

I have attached the sample Data set .

I am showing the value for a KPI named "On Hand Volume " using below expression :-
Sum({<isLastDayOfMonth={1}>}TREND_VOL)

It is working fine till Nov 2022

What i want to achieve here is that for Dec 2022 it should show the opening value for Jan 2023 .
Also , In jan 2023 , it should show the valu for 3 rd jan as it 1st as 2nd jan 2023 was a public holiday .

It shlould exclude weekedends and Public holidays and show .
Dimension- Trend_Rpeort Date

 

Aspiring_Developer_0-1673423316335.png

The value till nov 2022 is fine . However, for Dec 2022 closing value should take the opening value for Jan 2023 .

 

thanks

Labels (1)
2 Replies
Aamer_17
Contributor II
Contributor II

Hi, 

can you please try with networkdays() function in Data load editor.

Hope this will work.

Thanks,

Aspiring_Developer
Creator III
Creator III
Author

Hi ,

For Network Days , we need two dates . But here I want to implement it on the single date i.e Report Date .

 

Thanks