I have two columns, revenue this week and revenue last week, and I am looking to add a third column which shows the difference between the two. I believe this might be able to be done with a new metric. Does anyone have an idea how to execute this? Cheers
Best answer by Moises Morales
View original
Hi James,
I believe something like this could work:
SELECT (SELECT SUM(revenue) WHERE Week (Sun-Sat) (Date) = THIS)-(SELECT SUM(revenue) FOR Previous(Week (Sun-Sat) (Date)))You can find in the documentations below the details about the keywords in questions:
-Moises
Thank you! I have ended up splitting into two different metrics but that general idea got me what I needed.
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.