Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can someone please help me in the below metrices calculation:-
here fiscal year starts from OCT
Metrices Description
Total Work Days in Month Total number for this current month
Work Days Elapsed Month Number of working days that have been completed (so for todays reporting it would be 1)
Total Work Days in Quarter Total number for this current quarter
Work Days Elapsed Qtr Number of working days that have been completed (so all of Julys work days and then yesterday)
Total Work Days in Year Total number for this current Year
Work Days Elapsed Year Number of working days that have been completed (so all workdays from October to July and then yesterday)
ok so:
networkdays(yearstart(today(1)-1,0,10),today(1)-1) as [Work Days Elapsed Year]
To create these flags you need to use NetWorkDays() function which allow you to specify custom festivity of your company/country.
Hi,
By using NetWorkDays, I am able to acheive Total Work Days in Month , quarter and year, like below:-
NetWorkDays(MonthStart(Max(skey_date)), MonthEnd(Max(skey_date))) give me Total Work Days in Month
But how to acheive
Work Days Elapsed Month Number of working days that have been completed (so for todays reporting it would be 2)
Work Days Elapsed Qtr Number of working days that have been completed (so all of Julys work days and then yesterday)
Work Days Elapsed Year Number of working days that have been completed (so all workdays from October to July and then yesterday)
Load
NetWorkDays(MonthStart(today(1)-1), today(1)-1) as [Work Days Elapsed Month],
NetWorkDays(yearstart(today(1)-1,0,7), today(1)-1) as [Work Days Elapsed Qtr]
Resident Calendar;
Not clear what "Work Days Elapsed Year" must contains.... working days between oct and july ? or from oct. to yesterday ?
We have finacial year starting from 'OCT', so Work Days Elapsed Year should show number of working days that have been completed (so all workdays from October 2018 to Aug 2019 till yesterday)
ok so:
networkdays(yearstart(today(1)-1,0,10),today(1)-1) as [Work Days Elapsed Year]
Thanks