I have tried to solve this by myself for some time now, but I think there are smarter people out there)
I want to create a bar chart with 2 series: one with the monthly sales from 2017 and one with the monthly sales from 2018.
The x-Axis should be the months (January - December).
I have 2 Data Sources (both from Salesforce. One is called "All Sales This Year" the other "All Sales Last Year"): one with all closed deals from 2017, one with all closed deals from 2018.
The date format in the data sources is yyyy-mm-dd and the list also included the amount (in EURO) of the closed deal.
I cannot figure out how to set it up. I am totally confused where to start: Lookup? or Date_Convert? or Group_by? I understand how the single formulars work, but I cannot figure out how to bring it all together that it shows the correct data.
Can someone help me? Thanks!