topic Re: Graphics filter in App Development

Graphics filter

fmonetti — Thu, 15 Oct 2020 14:51:57 GMT

Hi, I am trying to apply an automatic filter in the calculation of a graph but I have not got the correct result. My data table is as follows:

User	Team	Month	Sales
User 1	A	Jun	10
User 1	A	May	12
User 1	A	Apr	13
User 2	A	Jun	20
User 2	A	May	25
User 2	A	Apr	27
User 3	B	Jun	30
User 3	B	May	33
User 3	B	Apr	31

If a filter in the model User 1, i need a chart to show me the results of the user's Team that has been filtered, not just that user or the rest of the teams. In this case the result of Team A:

Hope you can help me

Florencia

Re: Graphics filter

sunny_talwar — Thu, 15 Oct 2020 15:00:21 GMT

@fmonetti you can use an expression like this

Sum({<User, Team = p(Team)>}Sales)

Re: Graphics filter

sguerra2 — Thu, 15 Oct 2020 15:20:27 GMT

@sunny_talwar it worked!! I am working together with @fmonetti .

We have other graphic that needs the same filter logic but the formula is calculating average:

Avg(Aggr(Count({<[Base iCall-1.Estado]={'Enviada'},[Base iCall-1.Visita: Nombre del propietario],BU =p(BU)>}[Base iCall-1.Reunión remota: Nombre de reunión remota])/[Días],[Base iCall-1.Visita: Nombre del propietario],PAIS,[Base iCall.Mes]))

I tried to follow the same logic and put it in the set analysis buy without success.. how should we handle it? Thanks a lot!!!

Re: Graphics filter

fmonetti — Thu, 15 Oct 2020 15:25:44 GMT

than you very much @sunny_talwar !

it works perfectly

Re: Graphics filter

sunny_talwar — Thu, 15 Oct 2020 15:52:34 GMT

Try this

Avg({<[Base iCall-1.Visita: Nombre del propietario], BU = p(BU)>}Aggr( Count({<[Base iCall-1.Estado] = {'Enviada'}, [Base iCall-1.Visita: Nombre del propietario], BU = p(BU)>} [Base iCall-1.Reunión remota: Nombre de reunión remota]) / Only({<[Base iCall-1.Visita: Nombre del propietario], BU = p(BU)>}[Días]) , [Base iCall-1.Visita: Nombre del propietario], PAIS, [Base iCall.Mes]))

Re: Graphics filter

sguerra2 — Thu, 15 Oct 2020 18:18:46 GMT

Excellent! it is working! thanks a lot! Do you know if it is any way to avoid all filters to all the graphics in one sheet?? or does it need to be setup per graphic in the formulas?

Re: Graphics filter

sunny_talwar — Thu, 15 Oct 2020 18:16:30 GMT

@sguerra2 awesome

Re: Graphics filter

User45 — Mon, 08 Mar 2021 09:19:06 GMT

Hello, if I wanted a graph to appear already filtered, in this case by status (debt) = "Pending",how could I do it? The idea would be to make a line chart with customer dimension and measure the total amount, but filtered by pending. Thank you very much in advance.
Jorge