Show Top 10 in Chart (Rank in Beast Mode)
I am trying to build a multiline chart based on the following
Dimension: Date (x-axis), Search query (line series)
Metrics: impressions and position
The multiline chart should show the position (y-axis) by date for only the top 10 search queries based on the total impressions during a the selected time period.
I cannot do the rank in the ETL because the top 10 search queries could change based on the time period selected.
Is there a way to do a beast mode calculation that would achieve this?