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

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
Subha0
Answers
-
HI @JT_DC_2023
This question is specific to Oracle Analytics. You can post this question here -
Check this community discussion which explains about applying a filter to a count -
https://community.oracle.com/products/oracleanalytics/discussion/21763/applying-a-filter-to-a-count0