topic Re: Relative percentage in App Development

Relative percentage

vbravomo — Thu, 23 Aug 2018 08:05:25 GMT

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

Re: Relative percentage

ogautier62 — Thu, 23 Aug 2018 08:46:07 GMT

Hi,

If you have : Month, Process in dimension :

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

regards

Re: Relative percentage

vbravomo — Thu, 23 Aug 2018 09:09:25 GMT

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

Re: Relative percentage

vinieme12 — Thu, 23 Aug 2018 10:47:31 GMT

can you post some sample data and expected output

Re: Relative percentage

ogautier62 — Thu, 23 Aug 2018 10:52:20 GMT

that's what do code above,

could you share some data examples please

Re: Relative percentage

vbravomo — Thu, 23 Aug 2018 12:03:37 GMT

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.

Re: Relative percentage

sunny_talwar — Thu, 23 Aug 2018 12:09:29 GMT

Isn't this what you want?

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

Re: Relative percentage

vbravomo — Thu, 23 Aug 2018 13:25:21 GMT

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

Re: Relative percentage

sunny_talwar — Thu, 23 Aug 2018 14:36:39 GMT

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)

Re: Relative percentage

vbravomo — Fri, 24 Aug 2018 07:33:01 GMT

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

Re: Relative percentage

sunny_talwar — Fri, 24 Aug 2018 11:03:06 GMT

Try this... notice how I don't have curly brackets before < and after >

Count(ID_CASO)/Count(TOTAL<MONTH_FECHA_CREACION_SINHORA> ID_CASO)

Re: Relative percentage

vbravomo — Fri, 24 Aug 2018 11:28:35 GMT

It Works!

Thank you