Relative percentage

[vbravomo]

Hello,

I've used  Count({<Process,Date>}ID_CASE)/Count(total{<Process,Date>}ID_CASE) but the percentage that I get is over the total amount, and I need to get a percentage per the total of each month. I meant I need to get this table.

Month	Total	Percentage
January	100	100%
Process1	60	60%
Process2	40	40%
February	200	100%
Process1	80	40%
Process2	120	60%

Thank you

[ogautier62]

Hi,

If you have : Month, Process in dimension :

count(ID_CASE) / count(total <Month> ID_CASE) * 100

regards

[vbravomo]

Thank you, but it doesn't work. I need to get the percentage of cases over the total of the month, and per process.

I have two dimensión: date and process.

I have to get the porcentaje of the process 1 over the total of cases of January, and repeat it.

I need a graph where the axis X contain the months, an the axis Y contains the 100% of the cases. And each column have to have the grouped processes with different size depending on the relative percentage of each month.

I'm sorry if I don't explain good.

Regards

[vinieme12]

can you post some sample data and expected output

[ogautier62]

that's what do code above,

could you share some data examples please

[vbravomo]

Your code returns the percentage over the total(Jan+Feb+March...), not over the total of each month.

I've added a file with data and a pivot table that I expect to get.

[sunny_talwar]

Isn't this what you want?

ogautier62‌'s expression in general seems to work with some slight modifications

[vbravomo]

Ok, you're rigth. It Works thanks. But the last problem.

Could you see my qvf y tell me why the same code doesn't work? I don't have the original file but:

• FECHA_CREACION_SINHORA = Date
• ID_CASO = ID_CASE
• PROCESO = PROCESS

It doesn't work becaause if you check the numbers you realize that it's over the big total.:

Results:       "Cliente Fuera de Domicilio" in "ene" = 6229 / 2672204 (Total all months) = 0,23% 

Expected:    "Cliente Fuera de Domicilio" in "ene" = 6229 / 424471 (Total Ene) = 1,47%

Thank you

[sunny_talwar]

You need to create =Month(FECHA_CREACION_SINHORA) in the script to do this...

Month(FECHA_CREACION_SINHORA) as MONTH_FECHA_CREACION_SINHORA

and then use that as your dimension and this expression

Count(ID_CASO)/Count(total{<[MONTH_FECHA_CREACION_SINHORA]>}ID_CASO)

[vbravomo]

Thank you, but this code returns the same results. I've got and attached the files if it could help.