Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to display # of Orders Per Day but exclude Sat and Sun. What would the set analysis be for this expression?
=num(count(Distinct [Order ID])/Count(DISTINCT [Creation Date]),'#,##0')
If you have a calendar in your script (Creating A Master Calendar)
You can use this -> {<WeekDay -= {'Sat', 'Sun'}>}
=Num(Count(Distinct {<WeekDay -= {'Sat', 'Sun'}>} [Order ID])/Count(DISTINCT {<WeekDay -= {'Sat', 'Sun'}>} [Creation Date]),'#,##0')
If you have a calendar in your script (Creating A Master Calendar)
You can use this -> {<WeekDay -= {'Sat', 'Sun'}>}
=Num(Count(Distinct {<WeekDay -= {'Sat', 'Sun'}>} [Order ID])/Count(DISTINCT {<WeekDay -= {'Sat', 'Sun'}>} [Creation Date]),'#,##0')
You could have a field that calculates the day of week from Creation Date, then add to your expression a qualifier of what days you want to count.
LOAD
...
wekkday( [Creation Date] as CreationDay
...
FROM data source;
=num(count(Distinct [Order ID])/Count({<CreationDay={0,1,2,3,4)>} DISTINCT [Creation Date]),'#,##0')
Thanks Sunny, that did the trick. Now I also have a two other questions I can't really wrap my head around.
1. # Requestors who are submitting one request per day
2. # Requestors who are submitting one request per month
Request = [Order ID]
Requestors = [Requested By]
Date field= [Creation Date]
I suggest opening a new thread for a new requirement and also provide a sample so that its easy to offer quick help