Recently, I came across a problem where I wanted to show multiple charts in a dashboard, but the space should be optimized. There were multiple charts in that dashboard, which were supposed to be placed in a small space.

In this case, showing multiple very small-sized charts is not appropriate.

You will get an idea of how to change the charts dynamically:

1. Passing parameters from a drop-down menu to Pentaho charts/tables.

You have to follow the below-mentioned steps:

Step 1: Create a drop-down menu in Pentaho.

– Write a query for the drop-down menu.

– Add a ‘Select Component’ to the Components.
– Add parameter and listener to the select component.

Step 2: Create a chart.

– Write a query for a chart.

– Add the above-created parameter to the chart query.

– Add a ‘CCC Bar chart’, ‘ Pie Chart’, or a ‘table Component’.
– Add parameters and listeners to this chart/table component.

The Chart will change dynamically as per the selection from the drop-down menu.

Emergys Blog

Recent Articles

  • Service Desk Automation

    Top Candidates for Service Desk Automation

    Top Candidates for Service Desk Automation

    Automation is not new to anyone. It is the foundation [...]

    Automation is not new to anyone. It is the foundation for any enterprise digitization. However, companies [...]

  • Maximizing Customer Engagement with Salesforce

    Maximizing Customer Engagement with Salesforce

    Maximizing Customer Engagement with Salesforce

    Forget about closing deals – in today's business world, customer [...]

    Forget about closing deals – in today's business world, customer engagement is all about building bridges, [...]

  • Bridging the Gap Between Humans and Machines with Generative AI

    Bridging the Gap Between Humans and Machines with Generative AI

    Bridging the Gap Between Humans and Machines with Generative AI

    Nowadays, customers expect quick and thorough help whenever they reach [...]

    Nowadays, customers expect quick and thorough help whenever they reach out, whether it’s to order something, [...]