When subtracting 2 dates, the result is a number; however, it creates an attribute. Here is the formula:
TIMESTAMPDIFF(SQL_TSI_DAY, {date 1},{date2})
How can I change it to a fact?
I'm using NetSuite Analytics Warehouse.
You can add SUM() before your calculation:
SUM(TIMESTAMPDIFF(SQL_TSI_DAY, {date 1},{date2}))
SUM didn't work, but MIN and MAX do. I assume because the result of the formula is just one result.
Hi @User_F2RD3,
you have to add an aggregate function to change the column from attribute to metric
When I add it to a column, I don't get the Aggregate function.
Also, I don't want to aggregate the result.
SUM didn't work. However, MAX and MIN, did. I assume that since the formula produces one result, MIN and MAX produce the same result and change it to a Fact.
Mathematically what you are saying makes sense - but check for the compatiblity of the two functions TIMESTAMPDIFF and SQL_TSI_DAY. I think the first one expects a full timestamp, whereas the second only seems to provide the DAY without the rest of the hours, minutes, seconds?
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
How to show amount columns with currency symbol and format in AI Agent response. Provided sample in supplement instruction but it is not displaying based on format
After the recent Oracle FDI/OAC release updates, both our PROD and DEV environments no longer display the Data | Visualize | Present tabs at the top of the workbook.Previously, I used the Present tab to: Hide or show specific canvases/visualizations. Hide filters used in the workbook. With the new workbook interface, I…
My data: My Calculation - above in the last column you can see it works great: So why the heck my table goes blank for every value in Month End Date filter?
We are trying to clarify the 2 data sets that go into the oracle-delivered "Headcount Turnover" measure. This measure is found in FDI, in "HCM - Workforce Core"."Facts - Workforce Headcount" subject area We have our own internal calculation, which is a few percentage points different than this measure, which is why we are…
Dear Experts, We are trying to add security steps to our new implementation but the option that is mentioned in oracle documentation and also seen on other existing implementations is not available in our instance. The Navigation is FDI Console> Semantic Model Extensions> Security Configurations> Data Security Step.…
