Comments
-
While I saw the Multi-Value chart option. I was hoping to show the billing change as the Summary on the Billing Card tracking the monthly billing. Here is my Beast Mode calcualtion: (sum(case when MONTH(invoice_date)=MONTH(CURRENT_DATE() - interval 12 month) and YEAR(invoice_date)=year(CURDATE() - interval 12 month) then…
-
Here is my Beast Mode calcualtion: (sum(case when MONTH(invoice_date)=MONTH(CURRENT_DATE() - interval 12 month) and YEAR(invoice_date)=year(CURDATE() - interval 12 month) then total_amount_billed else 0 end) sum(case when MONTH(invoice_date)=MONTH(CURRENT_DATE() - interval 13 month) and YEAR(invoice_date)=year(CURDATE() -…
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In