Custom data extraction for mongodb field

Get Help
1

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:

{"logRawCode":13,"logRawAdditionalData":"0x04020C0E","batteryLevel":12,"logNumber":3781,"batteryLow":true}

, 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?

Thanks.

2

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]