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() -…