Issue comparing 2 years revenue data
Posted: Sat Jan 25, 2020 10:45 pm
Hello,
I would need to compare the revenue of 2 years (2019 and 2018). I want to be able to do such a compare as global revenue and also divided for each sales agent.
In my sample data I have 2 sales agent:
Di Stefano Marco
Ferrario Giovanni
Mussi Giorgio
As you can see from data in sql file, I imagined to have a table with the sales for each month of the 2 years; in each sale record I have the value and the reference to the sales agent.
The main element I imagined to use to the compare the revenue is the Indicator "Fatturato 2019 vs. 2018".
In the indicator the field Sum(vendite_2019.importo) is correct but the Sum(vendite_2018.importo) is not correct. Is a lot bigger. It seems that it breaks after I added the 'relAgenti2018' relation under "vendite_2018'.
Selecting the name of the sales agent, I would need to filter all the data by the agent.
I didn't understand where I'm wrong and if I have to change my data structure.
Kind regards,
matteo
I would need to compare the revenue of 2 years (2019 and 2018). I want to be able to do such a compare as global revenue and also divided for each sales agent.
In my sample data I have 2 sales agent:
Di Stefano Marco
Ferrario Giovanni
Mussi Giorgio
As you can see from data in sql file, I imagined to have a table with the sales for each month of the 2 years; in each sale record I have the value and the reference to the sales agent.
The main element I imagined to use to the compare the revenue is the Indicator "Fatturato 2019 vs. 2018".
In the indicator the field Sum(vendite_2019.importo) is correct but the Sum(vendite_2018.importo) is not correct. Is a lot bigger. It seems that it breaks after I added the 'relAgenti2018' relation under "vendite_2018'.
Selecting the name of the sales agent, I would need to filter all the data by the agent.
I didn't understand where I'm wrong and if I have to change my data structure.
Kind regards,
matteo