Grafana: How to implement math formula in query
I am trying to create a influxdb query which selects pressure values and apply a math function on them. I found out how how to apply simple calculations like /100 (see the following screenshot) which works.
But I want to calculate the altitude from this pressure values. The formula for this is the following:
Where p is the pressure (the query value in my case) and p0 is a constant. So now my question is how can I apply the formula for altitude to my pres value ? Or is it not possible because I can only do simple operations like the /100 with the math block ?
As far as I'm aware there is not currently any support in InfluxDB for exponents, which means that your equation can't be calculated.
There is an open issue in github (actually 2, a "feature collection" and an individual issue) for adding this as well as a host of other enhancements, but no timeline for when it might happen.
The simplest suggestion I have right now would be to calculate the altitude within your collector and store that in the database along with pressure.
Another alternative would be to switch to Graphite, which does support pow(), scale() & offset() functions and thus should be able to perform that calculation.
- svyby - how to call in different variables for by formula in a function?
- QUERY function with multiple conditions using time frame
- Function in excel contains unrecognized text from a code I made in microsoft VBA
- Sorting the string combined with arrayformula()
- Adding numbers in Excel, based on a condition
- how to sort a string contains list of number in google sheet?
- formula for number of blocks with mortar in a distance
- Is the mktime64 implementation simple by pure coincidence or by design?
- Google Sheets: SUMPRODUCT Formula for Summing Income and Expenses by Month Across Multiple Sheets
- Return one value from a report list, not sum or record count in Sheets
- If formula (the sum is less than 30 then roundup tp 30)
- Combine two columns that's are on a column "B" and column "C" and then make them into one column on column "E" with even and odd position each others
- How to determine luminance %?
- Widen/narrow line sections of plot so that x-axis breaks at peaks are evenly spaced
- Merging Google Sheets formulas into1 to get the same Result
- Finding the total numbers between values in TI nspire spreadsheets
- Use macro to dynamically insert static formula reference to an Excel sheet
- Collapsing Wide Data into Tall Data in Google Sheets
- Google Sheets QUERY Issue When Name Includes '
- How to render Latex markup using Python?
- offer price with target ROI
- Enter Cell Formula using VBA
- How to add a pound symbol(£) before the formula in textbox
- Workbook "Calculation Options" stays in Manual no matter the operation (open, save, close) being performed unless approved user hits Calculate
- Cannot extract month name, in specified language, from date
- IF AND and conditional formatting question
- Hide zero (0) values in INDEX formula
- R get local variable from formula
- Can I define a local value (or variable) in a Google Spreadsheet formula?
- Inverse formula of exponential moving average (ewm) in pandas