Hello all,
I want show YOY and MOM expression(different chart) in line chart .
Using 2 dimensions
Customer and year
Expression:-
((COUNT(Aggr(IF(COUNT({<P_DWG -={' '}>}Distinct Drawing_root_Key)=1, 1),P_DWG,New_Primary_Project)) )/
Count({<P_DWG -={' '}>}DISTINCT P_DWG))
Month Current year vs Previous year current month
Current Year vs Previous Year
!!quite urgent thank you
@sunny_talwar