Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Create a unified date for

Received Response
21
Views
2
Comments
User_5R2TJ
User_5R2TJ Rank 1 - Community Starter
in Oracle Analytics Forum

So I'm building a dashboard that has three dataflow/sets and each datasets has a corresponding dates: SLT Date,CaseDate and DateCreated. What I want to achieve is create a single monthly date so that I can put it in a table and put each different KPIs for each dataset.

Basically one unified date for each KPI metrics on my multiple date. Is it possible if so how?

Additionally is there a formula to create a moving 6 months median?

Answers

  • Chere-Oracle
    Chere-Oracle Rank 6 - Analytics & AI Lead

    Can you create a date parameter, which can be used in the Dashboard Filters visualization, and bind your three date filters to the date parameter?

  • BrandonH
    BrandonH Rank 5 - Community Champion

    dataflow the 3 datasets into 1?