topic Re: I cannot display the aggregation using a filter in App Development

I cannot display the aggregation using a filter

sersal10 — Sun, 07 Jan 2024 16:59:49 GMT

Hi all,

I have this formula in a data of a line graph, and I also have a filter with the grouped_big_event_name column. the formula works well when choosing one grouped_big_event_name , but if I select more, it doesnt aggregate well in the graph.

Sum({<grouped_big_event_name=, year_event=,event_name=, month_event=, event_code = {"$(=previous_event_code)"}>} quantity )

What is wrong?

Many thanks,

Sergio.

Re: I cannot display the aggregation using a filter

rubenmarin — Sun, 07 Jan 2024 18:08:37 GMT

Hi, you can add a table without dimensions and with =previous_event_code as expression. Check this value when you select one or more grouped_big_event_name, this result could give youa hint of what's happening.

Probably when there is more than one it just returns null, causing the expression to return an unexpected result.

Re: I cannot display the aggregation using a filter

anat — Mon, 08 Jan 2024 02:48:03 GMT

previous_event_code is this variable ?if yes can you share the logic.

if not use the below logic

Sum({<grouped_big_event_name=, year_event=,event_name=, month_event=, event_code = p(previous_event_code)>} quantity )

Re: I cannot display the aggregation using a filter

vinieme12 — Mon, 08 Jan 2024 02:54:17 GMT

"doesnt aggregate well in the graph"what does this mean exactly?

Does the chart not evaluate?

Do you get wrong values?

Does the chart take longer to return the results?

are there too many dimension values in the chart?

Re: I cannot display the aggregation using a filter

sersal10 — Mon, 08 Jan 2024 11:19:48 GMT

Hi, Thank you all. This one worked for sure. I don¡t understand the p() function here as it is used like a lag() function in SQL? I just want to reference and point to another column, but it worked anyway. If you know the reason, I would appreciate any light you can bring to my darkness 🙂

Thank you all again.