How can you view the first cell something like In Excel
(A:1 - A:2 * A:3) A:4=
As in actions you can delete rows of data
YES! You are correct
“Synthetic variables computation ( math functions only - data range and advanced functions are not supported).”
Arrrrrrrrr ok thanks
You can create a ‘value table’ and this will list all the Gravity readings so you can easily find the first and last, but you can do this on a graph too. Synthetic variables can onlu use add, subtract, multiply and divide. Bummer.
Hi @kelper, @Task001, and @andywhit.
I hope all of you are well,
Indeed these types of synthetic variables are only available in our paid tier. Nonetheless, I’ve already shared this case with our Product team and this calculation will be supported in the future, I will add a “+1” to this STEM feature request.
Thank you for your valuable feedback.
All the best,
-Isabel
1 Like
Thanks XXX
Thanks for that and the team
Also a big Thanks to Kelper for his support 
Please read the OP. He knows how to find the ABV, he wants a widget to display it live.
Hi, I’ve tried to create this variable on a STEM account but then get “an error has occurred and variable cannot be created”. Was this functionality allowed for all STEM accounts?
Hi @407255,
I hope you are doing well.
Unfortunately, as explain in my previous note these types of data range expressions are only available in Ubidots paid licenses. Nonetheless, I’ve already added a feature request for the product team to consider enable an expression that allows you make this calculation. For the time being, I don’t have an ETA, but as soon as I have an update I will let you know.
Best,
-Isabel
Any update, this would be great.
I current have a box with the highest gravity and one with the lowest, just need to add a sum for it to calculate.
Hi @jamesesmith,
I hope all is well.
Unfortunately, I don’t have any updates yet from the product team on where this expression for calculating the ABV value will be added. Nonetheless, I added a “+1” to this feature request and hope to have new in the coming months.
Best,
-Isabel
1 Like
I’ve got it to work with the formula above ((76.08 * (og- insert your gravity variable ) / (1.775-og)) * (insert your gravity variable / 0.794)).
It’s a pain to have to update the OG value each time you start a new brew off so I thought I could create a new variable called OG, with a widget to enter the value.
My thought was, when I start the brew off I would enter this value (along with a context of brew name) and then the above calculation could use that variable plus the current SG variable to show the current ABV. The formula says it’s correct but it does not return a value.
Anyone have an idea why this does not work?
Good day @stripeyjoe,
Can you please send us an image of this synthetic expression you are mentioned? In that way, we can investigate the reason why is not returning any value. Additionally please keep in mind that you can use the context of a variable to make a calculation only when the context is a numerical value.
All the best,
-Isabel
Hi @isalogi
For some reason I’m not able to upload screen shots…
I am using a synthetic expression to calculate the current alcohol level in my fermenting beer, using two variables:
gravity - This comes from my iSpindel device every 15 minutes
OG - this one is set at the beginning of each brewing session, (this is the first gravity reading when I start my brew off), I enter this via a manual entry widget, writing to the OG variable I created in my iSpindel Device.
Both gravity and OG are numerical values in the range 1.000 to 1.200
The formula is:
(76.08*( OG - gravity )/(1.775- OG ))*( gravity /0.794)
When I use this in the synthetic expression to show the current alcohol level the formula validates but I get no values.
If I substitute OG for it’s numerical value (eg, 1.066), then I get a calculated value (eg 5.05%)
Good day @stripeyjoe,
Thank you for your response. Sorry to hear you are unable to upload images. Based on your explanation as the synthetic expression involves more than one variable is necessary that all variables have the same timestamp otherwise you need to wrap up the expression with the fill_missing() function, which is not supported in the free version. A way to achieve your goal under the STEM account is by setting the variables to have the same timestamp.
Best,
–Isabel.
my OG = 10.80 so the formular is …
(1.080 - gravity) * 133.75
Hello @pongsak,
In this case, since the OG is a set value that is only configured at the beginning of each brewing I’d recommend you to simply type the value in the Synthetic Expression as you did here:
This way you won’t need the fill_missing() function. Then, for each brew you’ll have to update this value.
Does this make sense?
Best regards,
Sebastián
Hi @Sebastian,
Thanks for reply, I’m totally novice, so I can’t find the way how to get first value of gravity then I don’t need to correct every batch of brewing.
Would you mind to show me how to do that? Thank you