Unable to Calculate YoY Growth
I have a SQL table with a date column and a metric column (which I want to calculate growth).
I joined the main table with date dimension table (date=date). Now I created a alias for the main table and again joined with date dimension table (date=yearagodate).
In viz, I can pull year (from Date dim), metric(from main table), YearAgo metric(from alias table).
Results are matching. But I cannot make difference for growth calculation.
Can you guys help me with this?