Hi team, here comes another request, that most likely is not yet possible: We want to create a line chart that shows a metric (in our case ticket vs conversion rate) for each customer on a separate line over time. So far, this is doable. We have too many customers and so, we want to limit the chart down to only the top 10 customers by another metric (ticket volume in our case). I don’t see a way to apply a top 10 filter onto a metric that is not shown in the chart. Would be great if I could just drag that additional metric onto the top 10 filter, or just choose from all metrics instead of what’s in the chart. An alternative to that would be to allow for metrics to be added “invisible” to a chart, just so that we can base filters on it.

Hi Thomas, this is not possible at the moment to do visually, but in MAQL you can filter any metric by TOP/BOTTOM of other comparible metric without the need to display the second metric. See https://www.gooddata.com/docs/cloud/create-metrics/maql/ranking/where-top-or-bottom-in/ So something like this might work in your case:

SELECT {metric/TicketVsConversionRate} WHERE TOP(10) IN (SELECT {metric/ticketVolume} BY {attribute/customer_id}, ALL OTHER)

This internally calculates the metric ticketVolume by customerID and takes top 10 customers based on this metric. And only for those customers calculates the TicketVsConversionRate. It is not as universal as it would in the UI and would require special top 10 filtered metric (and that 10 is hardcoded there) but it could work for your case.

thanks, I’ll play with that! Might at least come some way towards the solution