topic Re: Set Analysis with multiple conditions in App Development

Set Analysis with multiple conditions

itsme123 — Tue, 29 Sep 2020 05:43:05 GMT

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

Re: Set Analysis with multiple conditions

Taoufiq_Zarra — Tue, 29 Sep 2020 07:37:14 GMT

@itsme123 can you share a sample data and the expected output ?

Re: Set Analysis with multiple conditions

Anil_Babu_Samineni — Tue, 29 Sep 2020 07:59:46 GMT

@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)