topic Re: Calcul average per month in Management & Governance

Calcul average per month

zied_ahmed1 — Wed, 12 Apr 2017 11:56:42 GMT

Hello i need to calculate average of actif car per month :

i used a QVD who stock a field named actif need to historise it everyday to know if the car is actif or not (if this field =1 it will be actif for this date)

in the end of the month i need to calculate the ratio between all car and the actif one per month and this is the QVD used :

// QVD_actif:

// LOAD * FROM (qvd) ;/

// Concatenate:

// LOAD

// * WHERE "date"= Today()

// ;

// SELECT

car,

actif

date

// FROM Database.table

// ;

// // ////*********store QVD**************

// STORE [QVD_actif] into [$(vQvdPath)\QVD_actif.qvd](qvd);

Re: Calcul average per month

Anonymous — Wed, 12 Apr 2017 12:07:30 GMT

Zied,

Do something like

count_Actif_1:

Load car,Month(Date) as Month,count(1) as Actif_1

resident <your table>

where actif=1

group by car,Month(Date);

join (count_Actif_1)

Load car,Month(Date) as Month,count(1) as Actif_0

resident <your table>

where actif=0

group by car,Month(Date);

Load car,Month,Actif_1/Actif_0 as ratio

resident count_Actif_1;

Drop table count_Actif_1;

Hope i understood you correctly and it helps you.

Re: Calcul average per month

zied_ahmed1 — Wed, 12 Apr 2017 13:38:58 GMT

yes,just in QVD i need how to stock the field value per day

Re: Calcul average per month

Anonymous — Thu, 13 Apr 2017 10:05:24 GMT

You need month level ratio to be stored against the date??