HDIFF in Formulas when I can only group by Days... | Help and How-To

liamcameron · 2024-09-11T23:58:07.475000Z

I have two dates and i want to calculate the hours between... sisense says to use HDIFFHour Difference HDiff( <Start Time>, <EndTime> )Returns the difference between <Start Time> and <End Time> inhours.But when selecting a date field from the data selector, i can only group in years,months,days, or aggregative time... here's a screenshot of an hour diff, where the formula is all 0....

MoreDiscussions

HDIFF in Formulas when I can only group by Days... | Help and How-To | Sisense Community