Forum Discussion

Michael-Schram's avatar
Michael-Schram
Cloud Apps
11-02-2021

Dynamic Date Filtering

How can one add a column filter to a widget or dashboard that is relative to an input parameter or variable?

8 Replies

Replies have been turned off for this discussion
  • By input parameter you mean an arbitrary of any text input?

    Every filter on the dashboard is already an input that can be modified by the user as long as its not locked I think.

    I may need an example to understand better the situation

  • Thanks OlehChudiiovych

    I have received additional recommendations outside of this community as well.

    I intend to review them once I'm back from vacation (~1.5 weeks).  I'll post an update.  If some of my use cases are not solved, then I'll elaborate on them.

    Thanks!

  • I have identified cube design measures that will address our two most immediate use cases.

    However, it'd be preferred to solve some of these problems in a dashboard.

    Once I have a window of time for Blox exploration I'll note if and how it can be used for my use cases.

  • Ophir_Buchman's avatar
    Ophir_Buchman
    Data Integration

    Hi Michael-Schram,

    Your use-case sounds like one of two options:

    1. The ability to control a filter as part of the dashboard (e.g., a drop-down box that lets you choose a value, or a text box that lets you type in a date)
    2. The ability to control a "variable" via a textbox and allow it to affect the dashboard results (a.k.a. "What-If Analysis")

    Can you please elaborate on your use case so I can answer the question?

    • Michael-Schram's avatar
      Michael-Schram
      Cloud Apps

      Ophir_Buchman , the use case would be as follows:

      1. Select a date based value in a widget filter (i.e. month or date range).
      2. Allow various widgets within the dashboard to filter a different date range / period, relative to the user's filter selection.  For example, one widget might display a KPI for the six month prior to the user's selection and another might display the same KPI for the user's selection.

      We've found methods to accomplish this within creative cube architecture but I'm inquiring if the web application has its own solution.