https://www.gooddata.com/ logo
Join Slack
Powered by
I’m attempting to build some visuals that I create...
# gd-beginners
j
I’m attempting to build some visuals that I created first in Quicksight and now are to be ported to GoodData. I want to filter a graph to the top 10 by volume but show another metric. This is not exactly uncommon right? I have a group by variable that has a LOT of distinct values and I want to only show the top 10 by volume in a graph. But I might want to show a different metric for those top 10. Am I missing something in GoodData? it seems like your top n filtering can only use metrics in the visual definition and I can’t seem to add volume to the visual without it needing to be used in the visual?
👀 1
image.png
Why cant “Based on” allow you to select any metric?
What I want is view rate for the top 10 by volume
Is there a way to bypass this by creating a metric that will dynamically calculate a RANK for the field so I can use it directly as a filter for my visual?
I can create a field to rank based on volume
but now it won’t let me use a metric as a filter in the visual!!! this should not be anywhere near as hard to do
this interface is really unhelpful by the way. It is so limited compared to other tools. In the end I created a RANK field and then thought I would try creating a top 10 flag where I used the values 0 and null - so that if it was in the top 10 it could be filtered by 0 and added to the visual in a way that might be less intrusive when showing the value. Originally I thought I would stack the values with 0 but I can’t do that.
The visual builder is producing VERY weird results. I’ve added my top 10 flag into the visual as a filter
and yet it doesn’t filter anything
when I tick the show missing values then it disappears!
and still the best I can do is to turn off the labels so at least it sort of looks like my desired result
it just has a lot of empty space. Why is this SO hard to do? why can’t I filter a visual by fields that are not in the visual definition? or at the very least why can’t I add something the visual definition but not show it? I mean I’m hoping there is just a special GoodData way to achieve this because, come on, this is basic functionality
it seems I cant filter anything by a metric - unless it is added to a visual definition.
but at the same time there seems to be no way of controlling how that metric is visualised so that I can hide it
f
Hi Jamie, there is indeed a way to achieve this! It’s not available through the UI, as you were able to figure out from your (extensive!) tests. Instead, it involves making the change on the metric itself, utilizing the TOP OF ranking filter. The idea is to create a metric that looks something like this:
Copy code
SELECT Story View Rate WHERE TOP(10) OF (Volume)
And then use this new metric in place of the original Story View Rate on your visualization. It will still display the values for Story View Rate, but only the ones with the Top 10 Volume (in this case, I’m assuming Volume is a different metric). Please give that solution a shot and let me know how it goes! --- I would be happy to also send some feedback to our Product Team about the apparent inability to do something like that via the UI - it’s important to know that there is interest for such a feature.
j
thanks for the quick response but that seems a very weird way to solve that problem. So I need to create a metric copy any time I want to do a top N visual? instead of just being able to drag it onto a page or a filter in a visual? It sounds like a consequence of architecture rather than something a user would want. If you want to fix this then just add the ability for an invisible metric to be added to a visual - all I need is a tick box ‘hide metric’ which would allow it not be showed but still be available for the metric filtering on the visual.
as for implementing the solution above
Copy code
SELECT {metric/story_view_rate} WHERE TOP(10) OF ({metric/stories_published})
is accepted as a valid metric
that does seem to work with one small issue - I can only sort by the view rate not the volume
and again the only way to do that seems to be adding it into the metric which would mess it up because I can’t add it without it being visible.
So being able to add ‘hidden’ metrics would be super useful for creating more flexible visuals. My general sense of GoodData is that you are still very limited in visual options and that one change would open up quite a few new options for users.
But I think I can live with the solution - and I’m glad there is one! so thanks for the quick help @Francisco Antunes
f
I think those are all valid points you are making, and I’ll be happy to forward them to our Product Team! Indeed, at this time the whole Sorting and Filtering interface in the Analytical Designer is dependent on having the objects you want to use as part of the visualization. I think this choice does merit a closer look, and I hope that our product team can shed some light on this - or perhaps even consider a possible improvement. Thanks for bringing it up, and I’m happy I could help out too! 🙂
🙌 1
p
🎉 New note created.
6 Views
Open in Slack
PreviousNext
Powered by