Solved

Customer Record Missing from Report Breakdown Table until added to "Where" filter

  • 4 January 2022
  • 1 reply
  • 17 views

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

icon

Best answer by belinda.chiu 6 January 2022, 18:08

View original

1 reply

Userlevel 4
Badge +4

Hi @Thrasher ! Welcome to the Amplitude Community :wave:

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! 

Reply