Skip to main content

Ability to Filter a Report using a Calculation for MDA Data

  • January 29, 2016
  • 1 reply
  • 21 views

andrea_weisz
We have loaded SalesForce data [dates] to our MDA Usage Data. We would like to be able to filter using a calculation with our SF Dates, For example: "Implementation Deadline Date - 90 days." Right now all we can do is "Implementation Deadline Date > or < a selected calendar date." This requires us then to update our filter weekly to ensure we are capturing all the information that now meets our criteria.

1 reply

kristin_f3c469
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • February 19, 2016
Yes - Reports 2.0 needs a variety of filters so you can report using relative date filters:
  • Based on Calendar - like This Calendar Year, Month; Last Calendar Year, Month, Previous Calendar Year, Month
  • Based on Fiscal Calendar
  • Based on Day - Today, Last 7 Days, Last 30 Days, Last 90 Days, Next 7 Days, Next 30 Days
thanks
Kristin