How to Apply Filters in Apache Superset?

  

In this post, I am going to explain how can we apply integer filters in Apache Superset.

 

Let’s use following dataset for the demo for this post and upcoming posts.

 

product_details.csv

created_at,created_by,updated_at,updated_by,product_id,product_name,description,category,price,stock,quantity,is_active
2025-01-01T10:05:00Z,etl_user,2025-01-02T10:05:00Z,admin,P1001,Monitor 24 inch 1,Full HD IPS monitor,Electronics,8948,718,6,True
2025-01-01T10:10:00Z,admin,2025-01-02T10:10:00Z,system,P1002,Wireless Mouse 2,Ergonomic wireless mouse,Stationery,4487,385,2,True
2025-01-01T10:15:00Z,etl_user,2025-01-02T10:15:00Z,system,P1003,Desk Lamp 3,LED study lamp,Electronics,12419,161,8,True
2025-01-01T10:20:00Z,etl_user,2025-01-02T10:20:00Z,admin,P1004,Backpack 4,Travel backpack,Electronics,24019,719,10,False
2025-01-01T10:25:00Z,etl_user,2025-01-02T10:25:00Z,ops_user,P1005,Desk Lamp 5,LED study lamp,Stationery,22600,151,6,True
2025-01-01T10:30:00Z,etl_user,2025-01-02T10:30:00Z,ops_user,P1006,Monitor 24 inch 6,Full HD IPS monitor,Electronics,13712,63,4,True
2025-01-01T10:35:00Z,etl_user,2025-01-02T10:35:00Z,admin,P1007,Backpack 7,Travel backpack,Electronics,18077,732,2,True
2025-01-01T10:40:00Z,etl_user,2025-01-02T10:40:00Z,system,P1008,Water Bottle 8,Steel insulated bottle,Home,7666,573,10,True
2025-01-01T10:45:00Z,system,2025-01-02T10:45:00Z,system,P1009,Office Chair 9,Ergonomic office chair,Accessories,1428,551,4,True
2025-01-01T10:50:00Z,etl_user,2025-01-02T10:50:00Z,ops_user,P1010,Backpack 10,Travel backpack,Accessories,23308,872,1,True
2025-01-01T10:55:00Z,admin,2025-01-02T10:55:00Z,ops_user,P1011,Wireless Mouse 11,Ergonomic wireless mouse,Accessories,19927,124,5,True
2025-01-01T11:00:00Z,etl_user,2025-01-02T11:00:00Z,ops_user,P1012,USB-C Cable 12,Fast charging cable,Home,10731,904,3,True
2025-01-01T11:05:00Z,system,2025-01-02T11:05:00Z,admin,P1013,Notebook A5 13,Ruled notebook,Accessories,1330,507,9,True
2025-01-01T11:10:00Z,etl_user,2025-01-02T11:10:00Z,ops_user,P1014,Backpack 14,Travel backpack,Home,2459,454,7,True
2025-01-01T11:15:00Z,etl_user,2025-01-02T11:15:00Z,system,P1015,USB-C Cable 15,Fast charging cable,Home,21075,767,7,False
2025-01-01T11:20:00Z,admin,2025-01-02T11:20:00Z,ops_user,P1016,Backpack 16,Travel backpack,Accessories,4366,583,10,True
2025-01-01T11:25:00Z,system,2025-01-02T11:25:00Z,system,P1017,Mechanical Keyboard 17,RGB backlit keyboard,Stationery,4658,419,6,True
2025-01-01T11:30:00Z,system,2025-01-02T11:30:00Z,system,P1018,Water Bottle 18,Steel insulated bottle,Home,8543,340,6,True
2025-01-01T11:35:00Z,admin,2025-01-02T11:35:00Z,ops_user,P1019,Laptop Stand 19,Adjustable aluminium stand,Accessories,16056,256,5,True
2025-01-01T11:40:00Z,system,2025-01-02T11:40:00Z,system,P1020,Wireless Mouse 20,Ergonomic wireless mouse,Home,11645,181,9,True
2025-01-01T11:45:00Z,system,2025-01-02T11:45:00Z,system,P1021,Notebook A5 21,Ruled notebook,Stationery,3638,603,8,False
2025-01-01T11:50:00Z,system,2025-01-02T11:50:00Z,ops_user,P1022,Backpack 22,Travel backpack,Home,21834,50,10,True
2025-01-01T11:55:00Z,admin,2025-01-02T11:55:00Z,admin,P1023,Laptop Stand 23,Adjustable aluminium stand,Electronics,22825,217,6,True
2025-01-01T12:00:00Z,admin,2025-01-02T12:00:00Z,admin,P1024,Backpack 24,Travel backpack,Electronics,22430,465,6,False
2025-01-01T12:05:00Z,admin,2025-01-02T12:05:00Z,admin,P1025,Office Chair 25,Ergonomic office chair,Home,1209,341,10,True
2025-01-01T12:10:00Z,etl_user,2025-01-02T12:10:00Z,ops_user,P1026,Laptop Stand 26,Adjustable aluminium stand,Stationery,15308,93,2,True
2025-01-01T12:15:00Z,system,2025-01-02T12:15:00Z,system,P1027,Laptop Stand 27,Adjustable aluminium stand,Electronics,2291,725,10,True
2025-01-01T12:20:00Z,system,2025-01-02T12:20:00Z,ops_user,P1028,Backpack 28,Travel backpack,Electronics,7318,409,5,True
2025-01-01T12:25:00Z,etl_user,2025-01-02T12:25:00Z,admin,P1029,Laptop Stand 29,Adjustable aluminium stand,Stationery,1611,429,1,True
2025-01-01T12:30:00Z,etl_user,2025-01-02T12:30:00Z,system,P1030,Desk Lamp 30,LED study lamp,Electronics,16623,424,7,True
2025-01-01T12:35:00Z,admin,2025-01-02T12:35:00Z,ops_user,P1031,Mechanical Keyboard 31,RGB backlit keyboard,Home,8934,674,6,True
2025-01-01T12:40:00Z,admin,2025-01-02T12:40:00Z,system,P1032,Mechanical Keyboard 32,RGB backlit keyboard,Electronics,5641,192,7,False
2025-01-01T12:45:00Z,etl_user,2025-01-02T12:45:00Z,system,P1033,Notebook A5 33,Ruled notebook,Home,12085,85,3,True
2025-01-01T12:50:00Z,system,2025-01-02T12:50:00Z,admin,P1034,Desk Lamp 34,LED study lamp,Stationery,11639,163,6,False
2025-01-01T12:55:00Z,etl_user,2025-01-02T12:55:00Z,system,P1035,Water Bottle 35,Steel insulated bottle,Stationery,1916,341,3,False
2025-01-01T13:00:00Z,etl_user,2025-01-02T13:00:00Z,ops_user,P1036,Backpack 36,Travel backpack,Stationery,1164,810,6,True
2025-01-01T13:05:00Z,system,2025-01-02T13:05:00Z,ops_user,P1037,Desk Lamp 37,LED study lamp,Accessories,13668,847,5,True
2025-01-01T13:10:00Z,system,2025-01-02T13:10:00Z,admin,P1038,Monitor 24 inch 38,Full HD IPS monitor,Stationery,13521,267,2,True
2025-01-01T13:15:00Z,etl_user,2025-01-02T13:15:00Z,admin,P1039,Wireless Mouse 39,Ergonomic wireless mouse,Stationery,447,53,4,True
2025-01-01T13:20:00Z,admin,2025-01-02T13:20:00Z,ops_user,P1040,Wireless Mouse 40,Ergonomic wireless mouse,Electronics,443,710,5,True
2025-01-01T13:25:00Z,etl_user,2025-01-02T13:25:00Z,admin,P1041,Backpack 41,Travel backpack,Home,16220,688,9,False
2025-01-01T13:30:00Z,admin,2025-01-02T13:30:00Z,system,P1042,Desk Lamp 42,LED study lamp,Accessories,19898,643,10,True
2025-01-01T13:35:00Z,admin,2025-01-02T13:35:00Z,admin,P1043,Backpack 43,Travel backpack,Electronics,21145,694,6,True
2025-01-01T13:40:00Z,admin,2025-01-02T13:40:00Z,admin,P1044,Laptop Stand 44,Adjustable aluminium stand,Electronics,6326,474,10,True
2025-01-01T13:45:00Z,system,2025-01-02T13:45:00Z,admin,P1045,Notebook A5 45,Ruled notebook,Stationery,9949,706,1,True
2025-01-01T13:50:00Z,etl_user,2025-01-02T13:50:00Z,admin,P1046,Monitor 24 inch 46,Full HD IPS monitor,Electronics,16609,929,2,False
2025-01-01T13:55:00Z,system,2025-01-02T13:55:00Z,system,P1047,USB-C Cable 47,Fast charging cable,Electronics,16710,274,7,True
2025-01-01T14:00:00Z,etl_user,2025-01-02T14:00:00Z,admin,P1048,Mechanical Keyboard 48,RGB backlit keyboard,Accessories,7676,45,9,True
2025-01-01T14:05:00Z,system,2025-01-02T14:05:00Z,system,P1049,Water Bottle 49,Steel insulated bottle,Home,5248,269,8,True
2025-01-01T14:10:00Z,system,2025-01-02T14:10:00Z,system,P1050,Monitor 24 inch 50,Full HD IPS monitor,Accessories,20854,40,7,True
2025-01-01T14:15:00Z,etl_user,2025-01-02T14:15:00Z,ops_user,P1051,USB-C Cable 51,Fast charging cable,Electronics,20287,882,6,True
2025-01-01T14:20:00Z,etl_user,2025-01-02T14:20:00Z,ops_user,P1052,USB-C Cable 52,Fast charging cable,Accessories,15791,701,9,True
2025-01-01T14:25:00Z,admin,2025-01-02T14:25:00Z,admin,P1053,Office Chair 53,Ergonomic office chair,Home,12318,805,9,True
2025-01-01T14:30:00Z,admin,2025-01-02T14:30:00Z,ops_user,P1054,USB-C Cable 54,Fast charging cable,Electronics,20275,653,4,False
2025-01-01T14:35:00Z,system,2025-01-02T14:35:00Z,system,P1055,Monitor 24 inch 55,Full HD IPS monitor,Accessories,22966,115,6,True
2025-01-01T14:40:00Z,etl_user,2025-01-02T14:40:00Z,admin,P1056,Notebook A5 56,Ruled notebook,Accessories,9150,68,8,True
2025-01-01T14:45:00Z,admin,2025-01-02T14:45:00Z,system,P1057,Wireless Mouse 57,Ergonomic wireless mouse,Home,1120,66,2,False
2025-01-01T14:50:00Z,etl_user,2025-01-02T14:50:00Z,ops_user,P1058,USB-C Cable 58,Fast charging cable,Accessories,14382,307,1,True
2025-01-01T14:55:00Z,admin,2025-01-02T14:55:00Z,ops_user,P1059,Desk Lamp 59,LED study lamp,Home,1604,928,7,True
2025-01-01T15:00:00Z,admin,2025-01-02T15:00:00Z,ops_user,P1060,Backpack 60,Travel backpack,Accessories,11040,103,2,False
2025-01-01T15:05:00Z,system,2025-01-02T15:05:00Z,ops_user,P1061,Desk Lamp 61,LED study lamp,Stationery,20259,646,3,True
2025-01-01T15:10:00Z,etl_user,2025-01-02T15:10:00Z,system,P1062,Wireless Mouse 62,Ergonomic wireless mouse,Home,20791,25,7,True
2025-01-01T15:15:00Z,admin,2025-01-02T15:15:00Z,admin,P1063,Desk Lamp 63,LED study lamp,Electronics,18352,930,2,True
2025-01-01T15:20:00Z,admin,2025-01-02T15:20:00Z,admin,P1064,Wireless Mouse 64,Ergonomic wireless mouse,Stationery,14334,31,10,True
2025-01-01T15:25:00Z,system,2025-01-02T15:25:00Z,ops_user,P1065,Office Chair 65,Ergonomic office chair,Home,8773,374,1,True
2025-01-01T15:30:00Z,etl_user,2025-01-02T15:30:00Z,ops_user,P1066,Backpack 66,Travel backpack,Stationery,14552,880,8,True
2025-01-01T15:35:00Z,etl_user,2025-01-02T15:35:00Z,ops_user,P1067,Office Chair 67,Ergonomic office chair,Electronics,15644,574,8,True
2025-01-01T15:40:00Z,etl_user,2025-01-02T15:40:00Z,admin,P1068,Notebook A5 68,Ruled notebook,Electronics,22579,591,4,False
2025-01-01T15:45:00Z,etl_user,2025-01-02T15:45:00Z,system,P1069,Monitor 24 inch 69,Full HD IPS monitor,Home,13366,301,8,False
2025-01-01T15:50:00Z,admin,2025-01-02T15:50:00Z,admin,P1070,Monitor 24 inch 70,Full HD IPS monitor,Accessories,23451,306,10,True
2025-01-01T15:55:00Z,etl_user,2025-01-02T15:55:00Z,ops_user,P1071,Laptop Stand 71,Adjustable aluminium stand,Accessories,18990,955,1,True
2025-01-01T16:00:00Z,admin,2025-01-02T16:00:00Z,admin,P1072,Backpack 72,Travel backpack,Accessories,7463,108,8,True
2025-01-01T16:05:00Z,admin,2025-01-02T16:05:00Z,ops_user,P1073,Mechanical Keyboard 73,RGB backlit keyboard,Home,18296,960,8,False
2025-01-01T16:10:00Z,etl_user,2025-01-02T16:10:00Z,admin,P1074,Desk Lamp 74,LED study lamp,Stationery,13301,288,1,False
2025-01-01T16:15:00Z,admin,2025-01-02T16:15:00Z,system,P1075,Laptop Stand 75,Adjustable aluminium stand,Stationery,642,221,6,True
2025-01-01T16:20:00Z,system,2025-01-02T16:20:00Z,system,P1076,Office Chair 76,Ergonomic office chair,Home,24815,831,2,True
2025-01-01T16:25:00Z,system,2025-01-02T16:25:00Z,system,P1077,USB-C Cable 77,Fast charging cable,Accessories,7166,266,2,True
2025-01-01T16:30:00Z,system,2025-01-02T16:30:00Z,admin,P1078,USB-C Cable 78,Fast charging cable,Electronics,23567,676,1,True
2025-01-01T16:35:00Z,admin,2025-01-02T16:35:00Z,admin,P1079,Water Bottle 79,Steel insulated bottle,Home,2132,785,4,True
2025-01-01T16:40:00Z,etl_user,2025-01-02T16:40:00Z,admin,P1080,Mechanical Keyboard 80,RGB backlit keyboard,Accessories,2519,783,9,True
2025-01-01T16:45:00Z,etl_user,2025-01-02T16:45:00Z,admin,P1081,Laptop Stand 81,Adjustable aluminium stand,Electronics,17826,341,4,True
2025-01-01T16:50:00Z,admin,2025-01-02T16:50:00Z,ops_user,P1082,Notebook A5 82,Ruled notebook,Stationery,13214,917,1,True
2025-01-01T16:55:00Z,admin,2025-01-02T16:55:00Z,ops_user,P1083,Wireless Mouse 83,Ergonomic wireless mouse,Accessories,1652,715,8,True
2025-01-01T17:00:00Z,etl_user,2025-01-02T17:00:00Z,system,P1084,Monitor 24 inch 84,Full HD IPS monitor,Home,3318,250,1,True
2025-01-01T17:05:00Z,system,2025-01-02T17:05:00Z,ops_user,P1085,Office Chair 85,Ergonomic office chair,Stationery,23353,265,5,True
2025-01-01T17:10:00Z,admin,2025-01-02T17:10:00Z,admin,P1086,Water Bottle 86,Steel insulated bottle,Home,19506,530,2,False
2025-01-01T17:15:00Z,system,2025-01-02T17:15:00Z,system,P1087,Desk Lamp 87,LED study lamp,Accessories,7347,731,10,True
2025-01-01T17:20:00Z,admin,2025-01-02T17:20:00Z,system,P1088,Office Chair 88,Ergonomic office chair,Accessories,18395,165,9,True
2025-01-01T17:25:00Z,etl_user,2025-01-02T17:25:00Z,admin,P1089,Water Bottle 89,Steel insulated bottle,Accessories,472,153,4,False
2025-01-01T17:30:00Z,etl_user,2025-01-02T17:30:00Z,ops_user,P1090,Laptop Stand 90,Adjustable aluminium stand,Electronics,16242,330,4,True
2025-01-01T17:35:00Z,system,2025-01-02T17:35:00Z,admin,P1091,Mechanical Keyboard 91,RGB backlit keyboard,Stationery,3927,944,10,True
2025-01-01T17:40:00Z,system,2025-01-02T17:40:00Z,admin,P1092,Monitor 24 inch 92,Full HD IPS monitor,Home,15032,474,2,True
2025-01-01T17:45:00Z,system,2025-01-02T17:45:00Z,ops_user,P1093,Desk Lamp 93,LED study lamp,Accessories,8106,286,10,True
2025-01-01T17:50:00Z,system,2025-01-02T17:50:00Z,system,P1094,Notebook A5 94,Ruled notebook,Accessories,23834,210,5,True
2025-01-01T17:55:00Z,system,2025-01-02T17:55:00Z,admin,P1095,Mechanical Keyboard 95,RGB backlit keyboard,Home,3221,383,6,True
2025-01-01T18:00:00Z,admin,2025-01-02T18:00:00Z,system,P1096,Backpack 96,Travel backpack,Accessories,14977,718,9,False
2025-01-01T18:05:00Z,admin,2025-01-02T18:05:00Z,admin,P1097,Office Chair 97,Ergonomic office chair,Accessories,19463,267,6,False
2025-01-01T18:10:00Z,admin,2025-01-02T18:10:00Z,system,P1098,Backpack 98,Travel backpack,Accessories,18772,377,4,True
2025-01-01T18:15:00Z,system,2025-01-02T18:15:00Z,system,P1099,Backpack 99,Travel backpack,Electronics,21870,96,9,True
2025-01-01T18:20:00Z,etl_user,2025-01-02T18:20:00Z,system,P1100,Office Chair 100,Ergonomic office chair,Electronics,12947,266,10,False
2025-01-01T18:25:00Z,etl_user,2025-01-02T18:25:00Z,admin,P1101,Water Bottle 101,Steel insulated bottle,Electronics,23052,894,10,True
2025-01-01T18:30:00Z,admin,2025-01-02T18:30:00Z,admin,P1102,Monitor 24 inch 102,Full HD IPS monitor,Electronics,12418,654,9,False
2025-01-01T18:35:00Z,admin,2025-01-02T18:35:00Z,admin,P1103,Monitor 24 inch 103,Full HD IPS monitor,Stationery,6607,722,4,True
2025-01-01T18:40:00Z,admin,2025-01-02T18:40:00Z,system,P1104,Monitor 24 inch 104,Full HD IPS monitor,Accessories,8866,657,7,True
2025-01-01T18:45:00Z,admin,2025-01-02T18:45:00Z,system,P1105,Mechanical Keyboard 105,RGB backlit keyboard,Accessories,8890,311,8,True
2025-01-01T18:50:00Z,admin,2025-01-02T18:50:00Z,ops_user,P1106,Desk Lamp 106,LED study lamp,Electronics,5191,88,4,True
2025-01-01T18:55:00Z,etl_user,2025-01-02T18:55:00Z,system,P1107,Desk Lamp 107,LED study lamp,Home,2310,583,2,True
2025-01-01T19:00:00Z,admin,2025-01-02T19:00:00Z,system,P1108,Laptop Stand 108,Adjustable aluminium stand,Home,18019,692,5,False
2025-01-01T19:05:00Z,system,2025-01-02T19:05:00Z,admin,P1109,Monitor 24 inch 109,Full HD IPS monitor,Accessories,13381,647,8,True
2025-01-01T19:10:00Z,admin,2025-01-02T19:10:00Z,admin,P1110,Desk Lamp 110,LED study lamp,Home,17737,249,8,True
2025-01-01T19:15:00Z,etl_user,2025-01-02T19:15:00Z,system,P1111,USB-C Cable 111,Fast charging cable,Accessories,17827,294,8,False
2025-01-01T19:20:00Z,admin,2025-01-02T19:20:00Z,system,P1112,Monitor 24 inch 112,Full HD IPS monitor,Electronics,7768,630,7,True
2025-01-01T19:25:00Z,admin,2025-01-02T19:25:00Z,ops_user,P1113,Office Chair 113,Ergonomic office chair,Accessories,4788,997,8,False
2025-01-01T19:30:00Z,system,2025-01-02T19:30:00Z,ops_user,P1114,Laptop Stand 114,Adjustable aluminium stand,Stationery,8943,901,1,True
2025-01-01T19:35:00Z,admin,2025-01-02T19:35:00Z,system,P1115,Mechanical Keyboard 115,RGB backlit keyboard,Stationery,4224,283,10,False
2025-01-01T19:40:00Z,etl_user,2025-01-02T19:40:00Z,system,P1116,Monitor 24 inch 116,Full HD IPS monitor,Stationery,21915,278,10,False
2025-01-01T19:45:00Z,etl_user,2025-01-02T19:45:00Z,ops_user,P1117,USB-C Cable 117,Fast charging cable,Accessories,23158,891,4,False
2025-01-01T19:50:00Z,admin,2025-01-02T19:50:00Z,ops_user,P1118,Wireless Mouse 118,Ergonomic wireless mouse,Accessories,11106,449,5,True
2025-01-01T19:55:00Z,system,2025-01-02T19:55:00Z,ops_user,P1119,USB-C Cable 119,Fast charging cable,Electronics,9499,359,2,True
2025-01-01T20:00:00Z,etl_user,2025-01-02T20:00:00Z,ops_user,P1120,USB-C Cable 120,Fast charging cable,Home,20693,252,1,True

   

Step 1: create product_details dataset.

Data -> Upload CSV to database.

 

Upload product_details.csv

Choose database and schema where you want to upload the dataset.

Give table name as product_details

 

   

Expand Columns section.

·      Select all the columns.

·      Set Column data types to {"created_at": "datetime64[ns, UTC]", "created_by": "string", "updated_at" : "datetime64[ns, UTC]", "updated_by" : "string", "product_id" : "string", "product_name" : "string", "description" : "string", "category" : "string", "price" : "int32", "stock" : "int32", "quantity" : "int32", "is_active" : "boolean"}

 

Click on upload button.

 

Navigate to the Datasets listing page, you can able to see product_details dataset.

 

Step 2: Set integer filters.

Click on product_details dataset.

 

You will be taken to product overview page.

 

Drag and drop product_name, category, price and is_active columns to Dimensions.

 

Click on ‘Create chart’ button, you can able to see the table like below.

 

Come to Filters section and set the filter price > 20000.

 

Save the changes.

 

 

Click on Update chart, you can see that the table filtered with records where price >= 20000.  

 

Step 3: Apply filters on string column.

 

Let’s filter the products with category Electronics.

 

   

Save the changes and update the chart. You can see now we have the products with category Electronics and price >= 20000.

 

You can observe that the chart is updated like below.

 

Let’s apply Like filter to see the products that starts with USB.

 

Save the changes and update the chart. You can see the table widget like below.

 

That’s it, you're good to go.

  

Previous                                                    Next                                                    Home