Slack Export

Hey James, Hope your weeks going well so far. Do you have a few moments tomorrow for a quick call? I just wanted to ask you a question about your notes from the other week regarding the drug model dashboard; Shouldn't take long, 10minutes at the most

James Scott (jamesscott@shield-legal.com)

2024-05-09 05:35:17

ok sounds ogod!!

Luke Fontaine (luke@shield-legal.com)

2024-05-09 12:39:11

Do you have a few moments now, or is there a time that works best for you?

James Scott (jamesscott@shield-legal.com)

2024-05-09 13:08:43

could we do 3 est?

Luke Fontaine (luke@shield-legal.com)

2024-05-09 13:10:03

I have a meeting then, could you do 3:30 est?

James Scott (jamesscott@shield-legal.com)

2024-05-09 13:15:08

yup!!

James Scott (jamesscott@shield-legal.com)

2024-05-21 14:23:25

hey man! so i completed the final part for the model, have u made any updates to the dashbaord

Luke Fontaine (luke@shield-legal.com)

2024-05-21 14:27:57

Hey! Oh nice I’m excited to see it. No not yet, I had two time sensitive projects that were dropped on me last week. Wrapping the last one up, so I’ll be able finish the dashboard this week

James Scott (jamesscott@shield-legal.com)

2024-05-22 05:52:38

awesome! if you want to go over it some more i would be glad t have a working session together

James Scott (jamesscott@shield-legal.com)

2024-05-24 07:31:18

do you have some free time today to go over some stuff with the dashboard

Luke Fontaine (luke@shield-legal.com)

2024-05-24 09:32:36

Sure. When would you like to meet

Luke Fontaine (luke@shield-legal.com)

2024-05-24 14:48:45

Hi James, I had time to dig deeper into the dash and BigQuery. I originally had join between unicourtcaseanalytics and drugrankingmodelresults as a one to many, which I'm pretty sure was causing the over counting. I had to reconnect the join between these tables, but looking more into the drugrankingmodelresults I don't see a field with a distinct ID that would connect to the other tables to pull unique counts. I'd also appreciate going over the results from the drug model to better understand. I'm going to be available for about the next hour and a half, tuesday afternoon, or wednesday is pretty open

James Scott (jamesscott@shield-legal.com)

2024-05-24 20:38:54

Yea likes do it Tuesday!!! Yea I have an idea on how the joins are going to work

Luke Fontaine (luke@shield-legal.com)

2024-05-28 10:50:17

Ok perfect, I just sent you an invite for 2pm PST

James Scott (jamesscott@shield-legal.com)

2024-05-28 10:50:36

Could u do 230?

Luke Fontaine (luke@shield-legal.com)

2024-05-28 10:50:54

Yeah absolutely, will adjust invite

James Scott (jamesscott@shield-legal.com)

2024-05-28 10:51:03

Awesome ! Thanks

James Scott (jamesscott@shield-legal.com)

2024-05-31 12:06:46

Hey is out meeting at 1 or 2?

Luke Fontaine (luke@shield-legal.com)

2024-05-31 12:07:28

it's on your calendar for 1pm your time

James Scott (jamesscott@shield-legal.com)

2024-05-31 12:07:59

Gotcha can you give me till around 130 I don’t think we need the full hour

Luke Fontaine (luke@shield-legal.com)

2024-05-31 12:12:49

If you want to just take a look and give me your feedback I focused on the adverseeventsicdmetrics information giving the key insights that you had expressed last time. Can you check for accuracy of the data being displayed? Looking at the preview in bigquery I just had a concern about over counting, for example, in this column of numberofseriousoutcomes it'll display the same totals multiple times so I wanted to make sure those weren't all summed together in the visualization

Screenshot 2024-05-31 at 10.11.54 AM.png

James Scott (jamesscott@shield-legal.com)

2024-05-31 12:13:02

Yes I think that’s better we can do that!

James Scott (jamesscott@shield-legal.com)

2024-05-31 21:06:16

for the query u will have to link em to it, for the main page i think thats a good start, i dont think the pie charts are really reprsenting anything though

James Scott (jamesscott@shield-legal.com)

2024-05-31 21:09:06

i think the most impact graph to show is the drugs or data that caters to the biggest percent change in rank for lets see how 2 year window looks

James Scott (jamesscott@shield-legal.com)

2024-06-04 12:27:49

do u need help on looker i might work in it wiht u

Luke Fontaine (luke@shield-legal.com)

2024-06-04 14:22:35

We do have the meeting on Thursday we can do then

Luke Fontaine (luke@shield-legal.com)

2024-06-05 12:40:10

Hey James, it would be really helpful if on the image Ryan created yesterday for the layout of the visualization if you labeled which table each of them are coming from

James Scott (jamesscott@shield-legal.com)

2024-06-05 13:05:12

ok !

James Scott (jamesscott@shield-legal.com)

2024-06-05 13:05:20

can u link me to them

Luke Fontaine (luke@shield-legal.com)

2024-06-05 15:02:00

AI dashboard mapping.png

Luke Fontaine (luke@shield-legal.com)

2024-06-07 13:14:52

Hey james wanted to follow up and see if you had the mapping for the above tables finished

James Scott (jamesscott@shield-legal.com)

2024-06-10 06:22:50

so i just tried to do this, its not as direct as you may seem, dependings on the scores the manufacturing or the type of board it can come from many tables

James Scott (jamesscott@shield-legal.com)

2024-06-10 06:22:57

depending on what kind of metrics we want to show

James Scott (jamesscott@shield-legal.com)

2024-06-10 06:23:44

so as an example for the first one, we can show drug ranking score, which would be ranking tables, we can show scores of drugs from adverse events, which would be adverse events table. and the charts and table is just another visulization of that

James Scott (jamesscott@shield-legal.com)

2024-06-10 06:23:56

but i can say that map will always be unicourt tables cuz they have mapping information

James Scott (jamesscott@shield-legal.com)

2024-06-10 09:42:16

if that makes sense

Luke Fontaine (luke@shield-legal.com)

2024-06-10 17:30:05

Wouldn't most of the Charts across the pages be connected to the same table, and the columns that are applied just be different?

James Scott (jamesscott@shield-legal.com)

2024-06-11 04:34:29

yes that is correct!!