Forum Discussion

android1's avatar
android1
Icon for Post Patron rankPost Patron
8 years ago
Solved

Filter 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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Would need sample data posted that I can copy and paste, just been hacking up to this point.

  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    android1,

     

    Add the following Boolean expression as well.

        vw_PivotChargesFrontPage[Visits_StartTime]
        <= vw_PivotChargesFrontPage[Visits_EndTime]
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Would need sample data posted that I can copy and paste, just been hacking up to this point.