How to filter the table based on fields

Question & Answer
,
1

Hi Team,

I want to filter the table if it contains the name “ASIN Face out”.
There are multiple names combined with “ASIN Face out” in the coulmn i need to filter if it contains the name “ASIN Face out”.

Screenshot
Screenshot2534×1088 303 KB

And also i want to calculate the overall count of the “ASIN face out” cases in small box not in the table view.

Please guide to create the table view and also small box view which need to show overall count alone of the “ASIN face out” cases

2

Hi @hripraa

To filter the pivot table or table to display only rows that contain “ASIN Face Out”.

  • Select the pivot table or table visualization.
  • Click on the “Filter” button (on the top toolbar).
  • Add a Filter for the column that contains the labels (e.g., Labels).
  • In the filter settings, choose “Contains” as the condition.
  • Type "ASIN Face Out" in the text box.
  • Apply the filter, and the pivot table should now only show rows containing "ASIN Face Out" in the selected column.

image
image330×598 24.7 KB

Create a calculated field to Show the overall count of “ASIN Face Out” and then add it to KPI as the visualization type.

Example: (Syntax may vary - replace the field from your dataset)

countIf({Labels}, contains({Labels}, 'ASIN Face Out'))

image