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. 

i.e., (metric-metric1)


Can you guys help me with this?

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • Status Answered
  • 1 yr agoLast active
  • 2Replies
  • 58Views
  • 2 Following

Product Announcement

We are happy to
announce Incorta 4.8 !!!