Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to prepare a dashboard that counts me some information.
In particular:
Can somone explain me how i can do it in specific dasboard?
I attach the excel with some data in example and a .qvw file where i started working.
see attached charts/text objects for 1 and 3.
for #2 you need to create a master calendar object add year and therapy as dimension and count(distinct patients) as measure
Thank you.
regarding the 3rd question I need more detail:
the expression
if(count(distinct AP_MINSAN10)>1,count(distinct AP_MINSAN10))
does not correctly calculate the changes of therpy as it does not take into account the date of disbursement (FA_DATA_EROG).
I apologize if I have not explained well before but what I have to intercept (and calculate) is the change of drugs distributed (AP_MINSAN10) between two delivery dates (FA_DATA_EROG).
Can you give me the correct expression?
Thank you.
1)
=Count({<PAZIENTE={"=FA_DATA_EROG>=Today()-90"}>}DISTINCT PAZIENTE)
2) Dimensions: =Year(FA_DATA_EROG), AP_MINSAN10
Expression: Count(DISTINCT PAZIENTE)
3) Dimension: PAZIENTE
Expression: Count(DISTINCT AP_MINSAN10)>1