1 Reply Latest reply on Sep 19, 2017 1:42 AM by lenaic.ridinger

    end date as variable and populated by default

    oscar vicente

      Hi good evening,

          Quick question: per requirements i need to create a dashboard with the following constraints in terms of cut off dates.

        1. By default when it's loaded  it will show always the aggregated figures with date range interval end date equal today ( execution date ).

        2. The date range can be always modifiable through the filter. ( that's clear to me ) . standard filter.

         When the dashboard is opened all records up to today are taken into consideration for the calculations,

      however through the filter i can simulate later on several other scenarios based on my cut off selections.

         When i add the value as filter and interval  it always take the last day i tested with in the worksheet, but i don't want to hardcode the

      end date value to today, only when the dashboard is logged in for the first time is opened.