Oracle Analytics Cloud and Server

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

Create a unified date for

Question
10
Views
0
Comments

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?