need help,

[nardtmo]

Hi all

Trying to build this report (see below condition & results) in pbi but with no success.  Premise, is to flag if 3 out of 4 patients that are in placebo reach temp => 102 for 2 consecutive hours and then identify other patients with similar symptions. Additional flag for critical patients temp reaching =>102 for 4 consecutive hours. report is being updated hourly. i have two tables  1 table for patient info and description 2nd table for data/time, patient, and temp. 

hope u guys can help. thanks in advance

Nard 

					1st condition	2nd condition	3rd condition	results
date	time	patients	description	temp	Track if 3 out of 4 placebo patients reach temp of 102 for 2 consecutive hours	if 1st condition met. Flag / Alert remaining patient that reach temp of 102 for 2 consecutive hours	Any patients temp reach 102 for 4 consecutive hours	Remarks
5/18/2021	11:00	A	placebo	97
5/18/2021	11:00	B	placebo	107
5/18/2021	11:00	C	placebo	99
5/18/2021	11:00	D	placebo	97
5/18/2021	11:00	E	tested	97
5/18/2021	11:00	F	tested	103
5/18/2021	11:00	G	tested	97
5/18/2021	11:00	H	tested	97
5/19/2021	12:00	A	placebo	97				normal
5/19/2021	12:00	B	placebo	107				normal
5/19/2021	12:00	C	placebo	99				normal
5/19/2021	12:00	D	placebo	97				normal
5/19/2021	12:00	E	tested	97				normal
5/19/2021	12:00	F	tested	103				normal
5/19/2021	12:00	G	tested	97				normal
5/19/2021	12:00	H	tested	97				normal
5/19/2021	1:00	A	placebo	102				normal
5/19/2021	1:00	B	placebo	103				normal
5/19/2021	1:00	C	placebo	104				normal
5/19/2021	1:00	D	placebo	97				normal
5/19/2021	1:00	E	tested	97				normal
5/19/2021	1:00	F	tested	103				normal
5/19/2021	1:00	G	tested	97				normal
5/19/2021	1:00	H	tested	107				normal
5/19/2021	2:00	A	placebo	102	1st condition met			Patient A reach threshold
5/19/2021	2:00	B	placebo	103	1st condition met			Patient B reach threshold
5/19/2021	2:00	C	placebo	104	1st condition met			Patient C reach threshold
5/19/2021	2:00	D	placebo	105				normal
5/19/2021	2:00	E	tested	97				normal
5/19/2021	2:00	F	tested	96				normal
5/19/2021	2:00	G	tested	103				normal
5/19/2021	2:00	H	tested	103		2nd condition met		Patient H reach threshold. Similar symptoms
5/19/2021	3:00	A	placebo	102	1st condition met			Patient A reach threshold
5/19/2021	3:00	B	placebo	103	1st condition met		3rd condition met	Patient B reach threshold. & Critical condition
5/19/2021	3:00	C	placebo	104	1st condition met			Patient C reach threshold
5/19/2021	3:00	D	placebo	104	1st condition met			Patient D reach threshold
5/19/2021	3:00	E	tested	97				normal
5/19/2021	3:00	F	tested	97				normal
5/19/2021	3:00	G	tested	103				normal
5/19/2021	3:00	H	tested	104		2nd conditon met		Patient H reach threshold. Similar symptoms
5/19/2021	4:00	A	placebo	104			3rd condition met	Patient A - Critical condition
5/19/2021	4:00	B	placebo	98				normal
5/19/2021	4:00	C	placebo	99				normal
5/19/2021	4:00	D	placebo	97				normal
5/19/2021	4:00	E	tested	97				normal
5/19/2021	4:00	F	tested	97				normal
5/19/2021	4:00	G	tested	105				normal
5/19/2021	4:00	H	tested	107			3rd condition met	Patient H - Critical condition

[nardtmo]

Hi Johannes,

thanks again for your help. Sorry to ask again, but is it possible to send out an alert / email based on the last data entry and met condition 1. 

Appreciate the help.

Menardo

[tex628]

I don't know whether or not it's posible to place a conditional trigger ("Check if something has happened and if it has send this mail") 

But you should be able to create a new page, filter out the most recent entry with condition 1 met, then finally create a subscription that sends out an e-mail with a snapshot of that page with the desired interval. 

Br,
J

[nardtmo]

Thank you. Will try it out.

[tex628 · Accepted solution]

Hi! 

I've attached a demo file. Take a look and let me know if it works for you. 

I'm slightly confused as to why patient "G" isn't meeting the 2nd condition on the 19th / 03:00. 

Br,
Johannes