Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me with two measures
ID column is trying to access documents which is store in datetime field
Col1 datetime; col 2 id ; col3 ; col4; col5 ID count( this is created using id column)
i need to create measure to count how many id are being accessed during 10pm to 6am interval
I also need to create an other measure which should satisfy condition col3 <> col4 and count id > 3 then i need count how many accessed documents more than 3 times
@itsme123 can you share a sample data and the expected output ?
@itsme123 Perhaps this way
Count(If(Time(datetime)>='10:00:00 PM' and Time(datetime)<='06:00:00 AM'), ID)
// Make sure, If Time(datetime) giving format with "hh:mm:ss TT"
Count({<Col3={"=Col3<>Col4"}, Id={"=Cound(Id)>3"}>} Documents)