Hey, We are a finance planning and analytics company and one of our use case is to build formula builder that will take two or more metrics to return the calculated results. We want to achieve something like this OFFSET((S&M Expense - Customer Marketing Expense), -1) / New Customers user will feed this formula and on top of this formula we will calculate result and give it back to user is there any way in Druid to achieve this.

druid has a SQL language where you can do any calculations on top of aggregations, including calculations that reference more than one aggregation function. so i expect you should be able to do this

Actually we are a finance analytics company and we have over use case where we have to calculate metrics by performing calculations on other metrics i have attached a screenshot below with the formula bar and expression inside it i want to know how will i be able to do it any guidance on this will be helpful.

if you are looking to build an application like this, you may be able to do it with SQL, depending on requirements