search

fhosking / cml-database

0 stars 0 forks source link

Hammersmith Registry>Baseline>Bone marrow data #97

Closed afzalkhan500 closed 1 month ago

afzalkhan500 commented 1 month ago

The CD values percentage sign missing: image image

When I change CD11c+IF value and save following error comes up: image

fhosking commented 1 month ago

Added % and numerical formatting to these 'value' fields. Unfortunately there isn't really a way to have the % formatting appear in the input field itself as it does on the access form

image

I believe I've fixed the issue causing the error above which is unrelated.

afzalkhan500 commented 1 month ago

For patient 464 the % is showing as fraction:

image image

Also just noticed that "% CD34 on trephine:" is showing 6 but it should be >20%: image image

afzalkhan500 commented 1 month ago

Also for patient 464 there are 17 values but only 8 appear in REDCap:

image image

fhosking commented 1 month ago

Firstly, are you sure you don't actually have record 564 selected rather than 464?

afzalkhan500 commented 1 month ago

Yes, 564 not 464!

afzalkhan500 commented 1 month ago

"% CD34 on trephine:" options are:

<5%

5% and <10% 10% and <15% 15% and <20% 20%

fhosking commented 1 month ago

I've multiplied the BMCDValue by 100

afzalkhan500 commented 1 month ago

"% CD34 on trephine:" options are:

<5% 5% and <10% 10% and <15% 15% and <20%

20%

fhosking commented 1 month ago

It seems that in the data, the values are stored as:

image

Perhaps you could help me identify the code from your side or by decoding these records

<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

baselinedataid | bma_ncd34 -- | -- 356 | 1 390 | 2 520 | 1 534 | 2 552 | 1 564 | 6

afzalkhan500 commented 1 month ago

It should say >20% but on my end the > sign keeps disappearing!

fhosking commented 1 month ago

Understood

afzalkhan500 commented 1 month ago

356: <5% 390: > 5 % and <10% 520: <5% 534: > 5 % and <10% 552: <5% 564: > 20%

afzalkhan500 commented 1 month ago

Looks like it comes from: image

fhosking commented 1 month ago

Ok, so it seems that

  bma_ncd34 == 1 ~ "< 5%",
  bma_ncd34 == 2 ~ "> 5% and < 10%",
  bma_ncd34 == 3 ~ "> 10% and < 15%",
  bma_ncd34 == 5 ~ "> 15% and < 20%",
  bma_ncd34 == 6 ~ "> 20%",

I have updated the project:

(record 390)

image
afzalkhan500 commented 1 month ago

Great! and x100: image

fhosking commented 1 month ago

Updated

image