Creating a filter based on Aggregated field

Q&A
,
1

I have a table that has data at country, station and source_date level. each row has one zap.

I’m trying to create a metric that will show me common zaps on a layer map based on source_date country and station filters

Metric was created using a maxover() function but when trying to add it as parameter on top of the sheet I got an error saying that parameters can’t be aggregated. is there a way to bypass this issue?

2

Hello @Carl_Chahine, I hope this message finds you well!

Regarding your problem, I would suggest trying two solutions:

  1. Instead of using maxOver() directly in a parameter, create a calculated field that computes the common zaps using the maxOver() function. This calculated field will be used in your analysis but not directly as a parameter.
maxOver({Zap}, [{Country}, {Station}, {Source_Date}])
  1. Since parameters cannot be aggregated, use filters to control the data displayed on your layer map. You can apply filters based on Country, Station, and Source_Date directly in your analysis to dynamically adjust the data shown.
3

Hey,
so my question was to see if I can bypass the aggregated parameter but seems not. I already have the maxover.

4

Hi @Carl_Chahine,
It’s been awhile since last communication took place on this thread, were you able to find a work around for your case? While you cannot bypass the aggregated parameter restriction, you could try to create your calculated field on the dataset layer as that may allow you to parameterize the field then.

Let me know if this works for your case or if you have any additional questions.

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

5

Hi @Carl_Chahine,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you!