Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Calculation: Tableau to OAC

Received Response
66
Views
3
Comments
Lokesh Obhilineni-Oracle
Lokesh Obhilineni-Oracle Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Hi Team, I need help converting calculation syntax from Tableau to OAC.

For example, what would the equivalent of

{ FIXED DATETRUNC('minute',[Appointment Begin Date]), [FIN]: (IF (COUNTD([FIN]))>=1 THEN 1 ELSE 0 END)}

this, which is a Tableau calculation look like in OAC.

{Image attached for reference}

image.png

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Can you at least explain what is the meaning, the expected result? Because more than trying to convert 1:1 calculations, you should know what you want to achieve. The 2 products being different, there are chances that things can be done differently to get the best experience with OAC instead of replicating exactly an existing thing and maybe have a bad experience with OAC.

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    +1. What are you trying to achieve?

    Please bear in mind that OAC is an analytical platform solution and not just a GUI tricks tool like Tableau with nothing underneath. There are different levels of interaction and doing everything in the front-end isn't really the way to go about things.

    A bit like this:

    image.png
  • Laquazia.Bell
    Laquazia.Bell Rank 1 - Community Starter

    In my example, I would like to know how many users each account has.

    In tableau I would use FIXED to aggregate my measure by the stated grouping column Customer ID. I do not want things in my visualizations to affect this calculation - I simply want a column that says for each group the Aggregate of another column is Y.