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?
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…
Hello Team, In the fusion source, we have the records maintained in multiple language say in english as well as in arabic.. ex: dept name is stored in both english and arabic in oracle fusion source with 2 records with different language code like EN and AR. But the same data in FDI is getting extracted only with the…
Hi Team, can oracle provide a standard decks to have a demo and presentation with new customer? Please share any links or attachments if available. Thanks, Manoj
All, I don't see there is a pre built data lieneage which gives more spectrum of solutions or answers for the BI leadership. 1.How many reports each users are owner and what is its path 2.Is these insights are sourced by Subject areas , data sets , Local Subject areas etc 3.Which content duty roles are associated to each…
hi All, The existing FDI pre-built artifacts/Common Subject Areas give us useful information about data reload and warehouse refresh activities. However, I see a gap when troubleshooting Data Augmentation execution at row level. For example, we have a BI Publisher report returning approximately 1M rows, but the…
hello, Is there a way to hide the "back" button in the FDI menu bar? Thank you in advance for your help!
