Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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
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
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
Thank you. Will try it out.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |