Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
How to add filter on a Dashboard with many Charts

I have a dashboard with many charts included and I would like to add a fliter that will be on the dashboard page and apply for all charts.
Is this possible?
Thank you,
Christina
Answers
-
It depends how the charts are implemented and exactly what is meant by "filter".
Please explain the problem in more detail.
-
Ok let me share more details. I have created a dashboard including charts based on an sql stament. I don't understand what you mean on how this is implemented.I attach a screen shot.
I have added filters per chart e.g. Milestone and Domain but instead of having in every chart I would like to have one filter for all charts in the Dashboard level.
Hope it is more clear now.
-
I attach a screen shot.
Please do not attempt to describe problems by posting screenshots. Screenshots are not accessible to visually impaired members of the community, and cannot be indexed by search engines, or copied and pasted to assist in developing a solution. They might show what the app looks like, but not how it is built.
I don't understand what you mean on how this is implemented.
I have added filters per chart e.g. Milestone and Domain but instead of having in every chart I would like to have one filter for all charts in the Dashboard level.
How did you do that?
What are the region/series Source properties?
How did you create the filter controls and integrate them with the charts?
(Post this information as text, not screenshots)
-
Hilary Farrell-Oracle Software Development Senior Manager Dublin, IrelandMember Posts: 2,417 Employee
Hi Christina,
In addition to Paul's very valid points in relation to the use of screenshots not being accessible, please always be mindful when posting screenshots of internal apps on our external forum. Einstein is our internal forum for raising questions in relation to internal apps. You can of course raise questions on this external forum also, if you wish, but just please be mindful of the content that is provided here.
On the screenshot you have provided, it depicts two pie chart regions, with two select list items on each region acting as filters on the chart, to filter by Domain and Milestone. Paul has already asked for additional information in relation to how you've defined those filters, as that would be required to provide you with an accurate response.
Regards,
Hilary
-
OK... I must be missing your point. if you can share details on how to add a prompt / filter on a dashboard as if I was creating everything from point 0.
So for the sake of simplicity I have one Chart type Bar in table Employees that shows Series A, B group by column C.
and on Chart 2 again Type Bar shows Departments Series D, E group by column F.
Is there a way to have a filter on the dashboard that I will select a value and this value will filter Column C and Column F?
-
Hilary Farrell-Oracle Software Development Senior Manager Dublin, IrelandMember Posts: 2,417 Employee
Hi Christina,
So for the sake of simplicity I have one Chart type Bar in table Employees that shows Series A, B group by column C.
and on Chart 2 again Type Bar shows Departments Series D, E group by column F.
Your response doesn't correlate with the screenshot you provided. Lets stick with your screenshot, please, as that's the app you're trying to update, correct? The first chart region on that screenshot is titled 'Number of Certificates Passed per Cohort', with two selects lists displayed at the top-left, named 'Domain' and 'Milestone' - lets call them P1_DOMAIN and P1_MILESTONE:
- Does your chart series reference the two page items, P1_DOMAIN and P1_MILESTONE?
- Does your chart series attribute 'Page Items to Submit' reference those two page items?
- Do you have Dynamic Actions associated with those page items, to trigger a chart refresh when the select list changes?
- Your second chart also depicts two select lists, 'Domain' and 'Milestone' - are those two select lists based on the same underlying values as the selects lists referenced in Q1 above?
Regards,
Hilary
-
I have found the answer to my question. Thank you for your answers. The point that I was looking is to create a new page item as Select List and then filter the sub charts with this parameter.
Thank you,
Christina