Line Chart, different and multiple expression

[jose_vargas]

Hello again community.

I attach a file, where i have 4 line chart in different graphics, each one have a different expression whit different variables.

I wanto to show in a 1 graph the 4 lines.

Any idea? what should i do?

Thanks

[jayanttibhe · Accepted solution]

Check attached - You dont need the calculated Dim. Instead just use Set Analysis for the Expressions.  PFA. Second TAB for the new chart.

[sunny_talwar]

One dimension with 4 expression?

[kaushiknsolanki]

Convert your expressions to below.

1. (Avg({<GrupoUsuarioEnvio = {"ANALISTA N2"}>}TiempoEnvio))

2.(AVG({<GrupoUsuarioRespuesta={"PEX"}>}TiempoRetorno))

3. (AVG({<GrupoUsuarioRespuesta={"OPERACIONES"}>}TiempoRetorno))

4.(Avg({<GrupoUsuarioEnvio={"ANALISTA N2"}>}Aggr(FirstSortedValue(TiempoConclusion, -Fecha_Respuesta), GrupoUsuarioEnvio, NumProcesso)))

Regards,

Kaushik Solanki

[jose_vargas]

Thanks to all users.  I was used a stament "IF", because of that my chart was empty.

[kaushiknsolanki]

Always Prefer Set analysis over If statement. That will help you in improving the performance of your application.

Regards,

Kaushik Solanki