topic Re: Graph. Filter and totalize by more than one field. in App Development

Graph. Filter and totalize by more than one field.

Magogar — Sat, 16 Nov 2024 20:33:51 GMT

Hello.

I know it must be a very simple answer, but I can not find the solution. Can someone help me please?

I want to make a graph and I need to search the rows with the highest value in the "Period" field and return the average of the "Sales" field.

I have tried the following without success:

Avg (Max(Period) Sales)

Avg({$<Period={Max(Period)}>} Sales)

Expected result:

Period	Sales (Avg)
4	125

rubenmarin — Thu, 27 Jun 2019 18:35:35 GMT

Hi, can you try?:

Avg({$<Period={$(=Max(Period))}>} Sales)

$(=...) is converted before calculating the expression so at the end it executes:

Avg({$<Period={4}>} Sales)

Magogar — Fri, 28 Jun 2019 16:28:40 GMT

Thank you very much. It works perfect!!!