Hello to everyone
I'm pretty new in BI4.2 and I have an issue that I can't solve. I present you the context
We use SalesForce for our commercial activity and the business opportunities.
We make a weekly extraction (on mondays) of all opportunities we have in our pipeline and also a monthly extraction (on 1st days of the month) of the same opportunities.
Problem is the amount of data and I would like to filter only on the opportunities that have had a change on some of their objects (% of probability to conclude the deal or previsional turnover or Stage of opportunity etc.) since the week (or month, even quarter) before..
I have in my reports multiple times the opportunity (each time with a different historical date/time and i don't kown from which end I should take the problem. If anybody has an idea to help me. Which function to use, type of formula to use ? etc...
Thanks in advance for your help