Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a date column and i want number of completed weekdays for a particular date
i.e.
1/12/2018--sat--1
2/12/2018--Sun--1
3/12/2018--Mon--1
......
17/12/2018--Mon--3
18/12/2018--Tue--3
.....
31/12/2018--Mon--5
i want to dynamically get the count of weekdays for a day till today
Suppose u have a date field, a weekday field and a month field:
use this expression:
aggr(rangesum(above( count({1}WeekDay),0,RowNo())),Month,WeekDay,MyDate)
result:
see if I select a weekday for example:
If I select a date: ; exaù^me 27/12/2018; I'd expect Jeu(thirsday) and 4 :
Suppose u have a date field, a weekday field and a month field:
use this expression:
aggr(rangesum(above( count({1}WeekDay),0,RowNo())),Month,WeekDay,MyDate)
result:
see if I select a weekday for example:
If I select a date: ; exaù^me 27/12/2018; I'd expect Jeu(thirsday) and 4 :