Custom data extraction for mongodb field

Hy guys, I'm working with mongo in the metabase and I need help filtering information from a field that I have. The field contains the following text:


, I need to pick the battery information 'batteryLevel' key. So I'd like to put that information in a new column. I've tried many ideas here, and so far I haven't gotten anywhere. Could you help me?


If this is a nested document within main document, you could create a filter on it using custom expression something like this:

"$batteryInfo.batteryLevel" > 10 or some condition which you would want.

If you really want to put that in a new column all together probably you could use native query or use custom column expression something like $batteryInfo.batteryLevel or [BatterInfo: BatterLevel]