Filter value field with corresponding number

[Anonymous]

Hi All, 

In the filter - what does the number next to the field mean?  So for example - looking at my region field what do the numbers next to blank and CAN mean? Random curiousity 🙂

[MariaP]

Hi @Anonymous 

The number is the toal number of records for CAN and Blanks, so you have 41 blanks and 10 CAN records

Maria

[Anonymous]

@MariaP  Thanks for your reply but I don't think that's correct.  Unless I misunderstand what you mean by record... what do you mean by record?  The numbers do not at all seem to correspond to the amount of rows for each attribute. 

[MariaP · Accepted solution]

Hi @Anonymous ,

If you drag your columns into a table you will be able to see the number of rows for your selected Region Code. This will help you understand the numbers returned.

Example shown below: for the city Abbeville, there are 5 state_name records which yoiu can see in the filters.

As you filter counts change based on your data model relationships.

I do not know if you have any further filters applied which may be rsulting in counts that are not making sense to you.

Cheers,

Maria

[Anonymous]

thank you @MariaP .  The data I am looking at shows surprising amount of records - for example a region we don't use very often has a count 4x as high as one that we do.  But your explanation makes sense.