The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Create dashboard widget with combination of multiple table(data source) using some certain queries

samarballav
Tera Contributor

3 weeks ago

Hi Everyone,

 

I am looking for help to create dashboard widget with combination of multiple table(data source) and some certain query to filter out the data like 
Risk Score = (Incident Count × 1.5) + (Critical Alerts × 2.0) + ((100 - Availability %) × 1.2) .

 

Please let me know if anyone can help this out. 
Thank you in Advance

Samar

0 Helpfuls
  • 255 Views
3 REPLIES 3

G Ponsekar
Mega Guru

3 weeks ago

Hi @samarballav ,

 

  1. Create Automated Indicators: Establish individual PA indicators to collect the raw data for Incident Count, Critical Alerts, and Availability %.
  2. Create a Formula Indicator: Build a formula indicator that references the three automated indicators and applies the specific calculation.
  3. Create the Widget: Add the formula indicator to a single score or other visualization widget on your dashboard.

 

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

 

Thanks, GP

0 Helpfuls

samarballav
Tera Contributor
In response to G Ponsekar

3 weeks ago

I have implemented same as you mentioned but this is not reflecting in widget creation data source eg.(formula table name) not visible in the data source. only automated indicator data name is showing.  

0 Helpfuls

G Ponsekar
Mega Guru
In response to samarballav

3 weeks ago

Hi @samarballav ,

 

Can you change the Widget Visualization as Single score and check

 

Also If the formula is invalid or one of the underlying automated indicators has a scoring error (e.g., division by zero), it can prevent the formula indicator from generating scores and appearing in the widget

 

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

 

Thanks, GP

0 Helpfuls