Total of Single Score Visualization

[paulmagaling]

I have a requirement that there should be an element in the dashboard that will total the single score visualization.

In the attached file, the total of the three single count visualization below should appear on the selected visualization. I'm thinking of making it possible through script include, but is there any way that I can make this possible?

[Mark Manders]

What is your business case? Because it sounds like a simple single score with 3 conditions (you can use 'OR') and that will show you the results. Not sure why you are thinking about a script include, while you already have the conditions available on the other single scores.

[paulmagaling]

For the layout of the dashboard, there should be an element that will show the total of the data visualization related to Business Applications.

The data of the three single score on the picture were sourced from three different tables.

[adityahubli]

Hello @paulmagaling ,

Is there any existing relationship between these three tables?
For example, Incident and Problem can be related if the Problem table stores the Incident sys_id as a parent reference. In such a case, you can use a Database View based on that relationship and then use that database view virtual table for visualization.

However, if there is no direct relationship between your 3 tables then a Database View will not work reliably.

In that scenario, the recommended approach would be to:

1. Create a new custom table to store the required data from all three tables.

2. Build your data visualization or reporting on this custom table.

3. Create a Scheduled Job (daily or as needed) to collect and sync data from your 3 tables based on the required conditions.

This ensures the data remains up to date, consistent, and report-friendly.

If this helps you then mark it as helpful and accept as solution.

Regards,

Aditya,

Technical Consultant