Dashboard/Report - Extract the Value of a RITM

Alessandro Mont
Tera Contributor

Hello Team,
I've a RITM with a question about the quantity of Routers.
I want to create a dashboard or a report where I can sum/have the value of the question for each RITM.

AlessandroMont_0-1756457557997.png

 


I found something in the tables sc_item_option_mtom_list.do and sc_item_option_list.do, but how can I connect it to RITM? What is the key attribute?

AlessandroMont_1-1756457662576.png 

AlessandroMont_2-1756457831481.png

Do you know how I can set up a Dashboard to display the List of RITMs and their corresponding values for each question?

2 REPLIES 2

Rafael Batistot
Tera Sage

Hi @Alessandro Mont 

 


To sum values in dashboard use an aggregation, this might help you 

 

  1. Go to Reports > Create New.
  2. Table = SC Item Option M2M [sc_item_option_mtom].
  3. Add filter:
    • sc_item_option.item_option_new.name = "quantity_of_routers"
  4. In the Report Designer:
    • Type = Chart (Bar / Pie / Pivot) → supports aggregation
    • Under Group by → choose request_item (to see RITM-level totals)
    • Under Aggregation → choose SUM on the field sc_item_option.value


Important detail

 

The field sc_item_option.value is stored as string. If your variable is a numeric question type (integer, decimal), you can aggregate directly.

If it’s a text variable, you won’t be able to sum it unless you cast it into a number (via a business rule or transform map).

Bhuvan
Tera Sage

@Alessandro Mont 

 

Create report on 'sc_item_option_mtom' and select bar visualization type.

 

Group by 'Parent Item.Number' and Stack by 'Depdenent Item.Question' and use Grouped bars. Use Aggregation as Sum as you want the count for each question related to RITM,

Bhuvan_0-1756637467020.png

If you want to filter the data for only question 'number of routers' use filter conditions in the condition builder,

Bhuvan_1-1756637998031.png

You can fine tune the grouping and visualization as per your requirement. 

 

If this helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan