0

Is there a way to add a filter based on extracted data from a json field? currently I can do something like

json_extract(meta, '$.mp_origin_meta') AS booking_type)

or

meta->'$.mp_origin_meta'

to extract specific data by writing a native query, but I really want to add this like a filter to my dashboard.

RiggsFolly
  • 93,638
  • 21
  • 103
  • 149
Fatemeh Rostami
  • 1,047
  • 1
  • 15
  • 27

1 Answers1

0

I solve this problem using our analytics script which sends our data to Metabase. Generally, we have to create a virtual field in our table and add the json extracted value to that new field. I did this programmatically with a PHP script, but there must be a way to add a field via Metabase panel.

Fatemeh Rostami
  • 1,047
  • 1
  • 15
  • 27