I'm trying to create a metric that would show our profits. I'm using Lens Metric and the calculation so far is like so:
round((round((sum(money_amount_eur_reverse, kql='type:bet_transaction OR type:settle_transaction') * 0.75), 2) - sum(money_amount_eur, kql='type:bonus_transaction AND money_amount_eur > 0')) * 0.7, 2)
From this number I would like to subtract a static number that we pay each day. But I would also like it be multiplied by number of days selected in the dashboard's query. So if 24 hours are selected it would subtract x and if 30 days - 30 * x.
Is there any way to achieve this?