Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this... notice how I don't have curly brackets before < and after >
Count(ID_CASO)/Count(TOTAL<MONTH_FECHA_CREACION_SINHORA> ID_CASO)
Hi,
If you have : Month, Process in dimension :
count(ID_CASE) / count(total <Month> ID_CASE) * 100
regards
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
can you post some sample data and expected output
that's what do code above,
could you share some data examples please
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.
Isn't this what you want?
ogautier62's expression in general seems to work with some slight modifications
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:
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
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)
Thank you, but this code returns the same results. I've got and attached the files if it could help.