Oracle Fusion Data Intelligence

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

Display no data if less then 8 records are used for the graph

Accepted answer
11
Views
2
Comments

Hello everyone,

We are looking to implement a logic that ensures no data is displayed in graphs or KPI cards when the underlying dataset contains 8 or fewer records (also through filtering) This requirement should apply across all charts and KPIs in the workbook.

Additionally, we would like to restrict this implementation to specific user groups if possible, so that only certain users are affected by this logic.

Has anyone implemented a similar solution? If so I would appreciate it if you could share your approach, particularly any best practices or potential challenges you faced during implementation.

Thank you in advance for your support and insights!

Best Answer

  • Hi @JT_DC_2023

    Thank you for visiting and posting your question in Fusion Data Intelligence (FDI) Community.

    Please try to create a calculation using below funtion:

    Count*

    Counts the number of rows.

    COUNT(*)

    Example: SELECT COUNT(*) FROM Facts

    and use the calculation column in your graph.

    Thanks
    Subha

Answers