Automagic Forum

Given a flow triggered by "GPS Status Event" I am looking for a formula to calculate the number of satellites used in the fix. I know that data is contained in the satellites array. I am hoping that somebody could help me with a formula to calculate the number of satellites from the array.

Thank you in advance

I haven't gotten any responses and came up the the following formula:

sats_used=length(split(join(satellites,"@"), "used_in_fix=true"))-1;

I don't think it is the most straightforward way for this, but it seems to work.

Is there a better way?