Forum Discussion
Line chart marks from different tables
I made that customization in the line chart yesterday as you mentioned, and work fine without the name of medication. I joined all the data in a unique table like this
PACIENTE_ID MEMBRANE_THICKNESS MEDICATION DATE
| 1 | 400 | OCT | 15/06/2019 |
| 1 | 426,67 | LUC | 18/06/2019 |
| 1 | 488,89 | LUC | 25/06/2019 |
| 1 | 542,22 | LUC | 01/07/2019 |
| 1 | 604,44 | LUC | 08/07/2019 |
| 1 | 666,67 | LUC | 15/07/2019 |
| 1 | 800 | OCT | 30/07/2019 |
| 1 | 800 | OCT | 01/01/2020 |
| 1 | 738,6 | OZURDEX | 08/01/2020 |
| 1 | 615,78 | OZURDEX | 22/01/2020 |
| 1 | 484,21 | OZURDEX | 06/02/2020 |
| 1 | 361,4 | OZURDEX | 20/02/2020 |
| 1 | 300 | OCT | 27/02/2020 |
OCT is the exam, if you see all the membrane_thickness between OCTs are calculated to be exactly over the line chart (In the transactional system the membrane_thickness is 0 for OZURDEX, LUC, EYLIA and other medication), but this calculation is not simple i need to do line by line maybe it is not the smarter and simple way. But the result was:
Yesterday, i posted this topic looking for a smater and simple way to do it.
Might be worth having a look at some of the custom visuals.
The pulse chart is pretty nice but its very much a case of actually clicking on the visual, or running the visual to look at the medications
Its a pity the medication markers dont stay up until you click on them but its quite nice. Medication is in Event Description