Calculation: Tableau to OAC

Lokesh Obhilineni-Oracle

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}

Gianni Ceresa

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]

+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:

Laquazia.Bell

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.