Dears
I want to calculate of DOD (20181202-20181201/20181201) and MOM f my REVENUE trend based on each service and date_key
but my expression is not working 😞
would you please help me in this regards:
Dimension: DATE_KEY, SERVICE_NAME
Expression:
sum({<DATE_KEY={"$(=Date(max(DATE_KEY),'YYYY-MM-DD'))"}REVENUE)- sum({<DATE_KEY={">=$(=Max(DATE_KEY)-1)<=$(=Max(DATE_KEY))"}REVENUE)/sum({<DATE_KEY={">=$(=Max(DATE_KEY)-1)<=$(=Max(DATE_KEY))"}REVENUE) * 100
