Forum Discussion
android1
Post Patron
Post PatronFilter between hours in the day
Hi, This calc column 8AM-10PM = IF(HOUR(vw_PivotChargesFrontPage[Visits_StartTime]) >= 8 && HOUR(vw_PivotChargesFrontPage[Visits_EndTime]) <= 22 ,TRUE(),FALSE()) returns all calls with a sta...
Would need sample data posted that I can copy and paste, just been hacking up to this point.
Add the following Boolean expression as well.
vw_PivotChargesFrontPage[Visits_StartTime] <= vw_PivotChargesFrontPage[Visits_EndTime]
Greg_Deckler
Community Champion
Community Champion8AM-10PM =
IF(
HOUR(vw_PivotChargesFrontPage[Visits_StartTime]) >= 8
&&
(
HOUR(vw_PivotChargesFrontPage[Visits_EndTime]) <= 21
||
(
HOUR(vw_PivotChargesFrontPage[Visits_EndTime]) = 22
&&
MINUTE(vw_PivotChargesFrontPage[Visits_EndTime]) = 0)
)
),
TRUE(),
FALSE()
)Maybe.
android1Post Patron
Post PatronOops, inadvertantly accepted as solution.
Not quite returning what I need.
- Greg_Deckler
Would need sample data posted that I can copy and paste, just been hacking up to this point.
- android1
v-chuncz-msftCommunity Support
Add the following Boolean expression as well.
vw_PivotChargesFrontPage[Visits_StartTime] <= vw_PivotChargesFrontPage[Visits_EndTime]- android1
Yes, thank you. Greg_Deckler Your code works perfectly with the added expression from v-chuncz-msft
- Greg_Deckler
Cool! The power of teamwork!