In both transaction reports and payment volume reports, most, but not all customers appear in the Breakdown table below the graph until that customer is added to the “where” filter. Here is an example for a customer called Hollywood High Grade which does not appear in the breakdown table below until added to the where filter.
This is pretty disconcerting since we rely on Amplitude for many things. Anyone know why this would be?
Thank you,
Scott
Best answer by belinda.chiu
View original
+8
Hi 
It is the case that the Breakdown table only hosts up to 100 values (this is noted in our Help Center). So if you have a group by that has more than 100 values, it’s likely that you won’t see all of the values appear on the chart. You can see how the values are ordered in the Breakdown table here: https://help.amplitude.com/hc/en-us/articles/360031259831#h_dda96e95-40ee-4040-912e-e251d64ade23
In addition to that, Amplitude does prune values for performance purposes so it is possible that the value you are looking for may have been pruned out: https://help.amplitude.com/hc/en-us/articles/360031259831
Since you aren’t seeing some of your groupby values appearing in the Breakdown table, it’s likely because those groupby values are either not the top values or they have been pruned out. Inputting the value exactly in the “where” filter will surface them directly since you are looking for them.
Additionally you can download the Breakdown CSV which will give you more values since it can go up to 10K rows: https://help.amplitude.com/hc/en-us/articles/115002923888#h_23368329-5147-4369-9d91-6a1d552eab36
Hope this helps!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
