I cannot display the aggregation using a filter

[sersal10]

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.

[rubenmarin]

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.

[anat · Accepted solution]

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 )

[vinieme12]

"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?

[sersal10]

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.