Hi, all I was trying to display the data for last ...
# gooddata-cloud
a
Hi, all I was trying to display the data for last 12 months, the charts are displaying only 1st quarter on this year. Can you please help me understand why is it happening like this. Is there a way to solve this, if data is populated across all the months.
m
Just a guess, but Isn’t it the TOP 10 filter? I can see there are exactly 10 colorful boxes in the chart, maybe it is only giving you the largest 10 and they happen to be in these months? Does it change if you remove the TOP 10 filter?
a
After removing the Top 10 filter, the data comes for all the months, so you mean if I add top 10 filters, it won't show for any month where these top ten is not present even any one of them?
m
I think it depends what you mean by that “TOP 10”. If I am not mistaken you are viewing your data by month and name. And I think currently the TOP 10 filter is passing the top 10 combinations of month+name If that is what you want, it will only give you 10 “boxes” and they are in those months. But if you rather want TOP 10 names by the metric value (overall, no matter in what month) you can switch the TOP 10 filter to do so - there is a “Out of” dropdown (see my screenshot - I have different attributes and dates there, but it works the same). And the default “all” value means “combination of all attributes used in the visualization” in your case month+name. In other words - for the TOP 10 filter, a value of the metric needs to be calculated and it needs to be calculated in some context. It is either name+month or just month or just name and based on that the top 10 are filtered.
a
Okay, got it, I want to view in both the way the top 10 and months, so thats why I have selected all there.
m
OK. Just to make sure I explained it well - you can still have the TOP 10 filter calculated by just name (to get top 10 names) and then view those by name and month.
👍 1
a
Yeah, thank you