After searching around I still haven't found a solution so I thought I would post it here. Any help would be greatly appreciated.
When I go to filter one of the columns it redirects me to dashboard then when I click on sales -> orders it loads the following error:
SQLSTATE: Integrity constraint violation: 1052 Column 'store_id' in where clause is ambiguous, query was: SELECT COUNT(*) FROM
order ON order.entity_id=main_table.entity_id WHERE (
store_id = '1')