Simplify Graph Formula

Martin22 — Mon, 30 Sep 2019 13:07:26 GMT

Hi all,

I encounter a performance issue with a graph :

Here is some context : this is a combo graph, with a dimension (a hierarchy with Activity and then Axis), and three mesures. The three mesures have the same formula, described here, except for the AVG, replaced with Min and Max for the two others.

We are able to filter on a periode thanks to another graph, or some filter panels.

The client wants to see the result aggregated for each Activity/Axis and each period filter, depending on the selection, and we had to put the formula described here, but since then the graph takes a long time to load, and sometimes will put an error message because of expired timeout.

Does anyone see how to simplify the formula ?

pick(match($(Level_H_ORGA),'Activity', 'Axis')
, pick(match($(Level_H_TIME),'Year Month', 'Date', 'Hour')
, AVG(aggr(sum([Mesure1]), [Activity], [Year Month]))
, AVG(aggr(sum([Mesure1]), [Activity], Date))
, AVG(aggr(sum([Mesure1]), [Activity], Hour))
)
, pick(match($(Level_H_TIME),'Year Month', 'Date', 'Hour')
, AVG(aggr(sum([Mesure1]), [Axis], [Year Month]))
, AVG(aggr(sum([Mesure1]), [Axis], Date))
, AVG(aggr(sum([Mesure1]), [Axis], Hour))
)
)

Thanks,

Martin.

Re: Simplify Graph Formula

sunny_talwar — Mon, 30 Sep 2019 13:14:54 GMT

How about this

Avg(Aggr( Sum([Mesure1]) , $(='[' & $(Level_H_ORGA) & ']'), $(='[' & $(Level_H_TIME) & ']')))

Re: Simplify Graph Formula

Martin22 — Mon, 30 Sep 2019 13:26:20 GMT

It's just great, thanks a lot !

I have other formulas of the same type, I will try to adapt your solution.

Thanks again !

topic Re: Simplify Graph Formula in App Development

Simplify Graph Formula

Re: Simplify Graph Formula

Re: Simplify Graph Formula