Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there!
I'm a bit lost , so i hope someone of you will give me light about the question below.
I got this example to explain the logic:
CENTRE ID | PATIENT ID | MESSURE ORDER | TEMPERATURE |
---|---|---|---|
A | 10 | 1 | 38,4 |
A | 11 | 1 | 37,4 |
B | 21 | 1 | 39,2 |
B | 22 | 1 | 37,5 |
B | 22 | 2 | 36,6 |
A | 10 | 2 | 38,2 |
A | 11 | 2 | 37,3 |
B | 21 | 2 | 38,6 |
B | 21 | 3 | 37,4 |
A | 10 | 3 | 37 |
A | 11 | 3 | 36,2 |
B | 21 | 4 | 36,8 |
A | 10 | 4 | 36,6 |
I need to know the (average of temperature by (maximum messure order by patient ID)).
I don´t wanna need to show the "Patient ID' field in the result which should be something like this:
CENTRE | TEMP. AVG |
---|---|
A | 36,4 |
B | 36,7 |
Regards,
Lan
Expression:
=Avg(Aggr(FirstSortedValue(TEMPERATURE,-[MESSURE ORDER]), [CENTRE ID],[PATIENT ID]))
PFA
Can you elaborate your logic in more detail please?
OK! I´m sorry about my english, when I said messure I meant to say measure.
Lets go...
There are 2 centres A and B.
Each centre got X inpatients (2 in the A and 2 in the B in this case).
I took the temperature several times for each patient (not the same times per each).
So i need to know the average of the temperature for the patients only for the last time i took the messure (being the last time, the maximum measure time of the temperature).
Expression:
=Avg(Aggr(FirstSortedValue(TEMPERATURE,-[MESSURE ORDER]), [CENTRE ID],[PATIENT ID]))
PFA
Hi,
Pls look into the attached qvw and let me know if this is what expected.
Thanks,
Prabhu
Tresesco reached before me...
Dimension = [CENTRE ID]
Expression
Avg(Aggr(FirstSortedValue(TEMPERATURE,-[MESSURE ORDER]),[PATIENT ID],[CENTRE ID]))
Actually the qvw works but i'm trying to check the logic in my enviroment, which much more complicated.
Hi tresesco,
Could you help me on this?
Some help with first and last on count({set analysis} DISTINCT aggr(firstsortedvalue)))
I got some troubles with this expression calculating the value on first or last [Orden Form]
=Count({<[Valor Item]={2},[Id Paciente]=P({<[Orden Form]={">=2"}>}[Id Paciente])>}DISTINCT Aggr(FirstSortedValue([Id Paciente],[Orden Form]),Bloque,Estudio,Centro))
Please, if you can help me let me know if you need any added information.
I will appreciate a lot any assistance.
Regards,
Lander