I want to use a stat visualization to display the difference in percentage between the first and the last value of an sql result displaying stock data. The query accesses a Mysql db of the finance tool gnucash. In the menu I can only select Difference and get the total difference but cannot select difference percent.
select min(UNIX_TIMESTAMP(date)) as time_sec, sum(value_num/value_denom) as value, fullname as metric from prices join commodities on prices.commodity_guid = commodities.guid where $__timeFilter(date) and quote_source <> 'currency' group by date, fullname order by date;
Excerpt of the available grafana calculation list:
|Difference||difference between first and last value of a field|
|Difference percent||percentage change between first and last value of a field|
What can I do to make Difference percent available? (v. 7.3.6)
Thanks in advance