I have 2 fields :The 1st one has data such as "10/01/2018 to 10/31/2018" and "11/01/2018 to 11/30/2018" and the 2nd one is a measure (Monthly Forecasted revenue) which has values like 25000$ and 40000$.
How to apply the Forecasted Revenue value on a daily or weekly basis?Ex If a person selects 11/15/2018 as the date filter,he or she should be able to see the value as 40000/30(since 30 days in November) and if the person selects a week in Nov,the value should be 40000*7/30
Right now the entire month value is being shown even if I select a particular date or a week.
Thanks in advance.
