Hi guys!I would like to know how I can add a column that presents the percentage calculation comparing the values of a year with the previous year, as shown in the table below. I only need three columns... if possible to show in "green" the growth and in "red" the fall. Could you help me please?
Best answer by Moises Morales
View original
Hi Douglas, you will need to create a separate metric for this and then you will need to apply formatting so the numbers show in red or green as needed: https://help.gooddata.com/pages/viewpage.action?pageId=86787973
I'm not able to bring the annual comparison with this metric… could you tell me what I'm doing wrong?The colors I managed to configure, thank you very much!
Hi Douglas, you need to specify a function for the first part of the metric. In this case, it should be something like:
SELECT COUNT (Quantidade - Quantidade, Quantidade - Quantidade) for Previous (year(Datamovimento))
This of course is all dependant on your LDM and you may need to use a connection point of the data set to interact with other objects in the report. There is a great free course on our University page where you can learn more about MAQL functions:
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.
