The first panel is drawing its search from an SQL query as follows:
<row>
<panel>
<table id = "accounts">
<title>Click account for more details </title>
<search>
<query>| dbquery AdWordsROI "SELECT ClientName, sum(Impressions) as Impressions, sum(Clicks) as Clicks, sum(Cost) as Cost FROM account_performance where `Day` between from_unixtime($time_range1.earliest$,'%y-%m-%d')and from_unixtime($time_range1.latest$,'%y-%m-%d') group by ClientName" </query>
</search>
</table>
</panel>
</row>
The panel below this one draws data from a different SQL query ie:
<row>
<panel>
<table>
<title>Filtered</title>
<search>
<query>| dbquery AdWordsROI limit=1000 "SELECT site_id,tracking_id, date_pst, sum(total_subscribers) as TotalSubscribers,sum(total_sales) as TotalSales ,sum(`total_amount_usd`) as TotalAmount from revenue_data WHERE date_pst = '2015-05-04' and site_id= 'AR' group by tracking_id"
</query>
</search>
<option name="count">5</option>
</table>
</panel>
</row>
I would like to pick data from the 'cost' field in the first panel to do an eval with the 'total amount' field in the second panel. Basically to subtract cost from amount and get a percentage of it and display it in a new column in the second panel.
Cheers
Bob
... View more