Hello,
Any idea on how to calculate the percentage of a specific category value out of the grand total?
My goal is to create a tile visualization for each fiscal quarter so I need to have separate calculation for each quarter?
I'm
Thank you!
@JobDeLuna - If you want just to display the Base Plan Spend as a percentage instead of the value amount as in the report you provided, you just add the Base Plan Spend metric twice to the DV visualization, the go to Properties -> Values, chose one of Base Plan Spend column to display as Percentage and change its Display As property from Values to Percentage Of: All Values.
If what you want is to have a separated calculated column for the the percentage of an specific month (i.e. FYQ1, then create a calculated formula with a formula as below.
filter("Base Line Spend" using "Fiscal Quater" = 'FYQ1') / "Base Line Spend"
Thank you @JoseP-Oracle !!! It worked.
Hello. We are using the HCM - HR Help Desk Requests Overview subject area in FDI for building workbooks. We need to modify the calculation for ticket Resolution Time to "pause" the counter during non-business hours. We don't want the tickets to age, when the person the ticket is assigned to is not working, and have our…
We are building dashboards in FDI, using HCM data. Can anyone advise on best practice for designing front-end access to FDI for different user groups (e.g., Executive, Line Manager, non-Managers, etc.)? Not from the security configuration side, but from the design planning side. We have granted access to only one group by…
Hi All, Previously, I used Data Actions → Analytics Link to navigate between two canvases in FDI. However, I can no longer find this option in the current FDI interface. Has anyone else experienced this? What is the recommended way to create canvas-to-canvas navigation now? Thanks in advance!
Hello, I need to grant users access to FDI without giving them the module security groups, such as ERP, HCM, etc. In FDI, I have other external connections, and I don't want them to see any other modules, so my question is: Is there any other FAW security group that grants access to FDI without allowing users to see the…
With the release of Fusion Operational Analytics, I understand that OTBI Subject Areas will be made available within FDI, but I'd like to know the following: 1) Can I migrate OTBI reports and/or dashboards over to FDI for use by FDI consumers? Are they brought through the OAC Classic layer of the FDI/OAC platform? If not,…