Dashboard/Report - Extract the Value of a RITM

Alessandro Mont · a month ago

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.

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?

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

Rafael Batistot · 4 weeks ago

Hi @Alessandro Mont

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

Go to Reports > Create New.
Table = SC Item Option M2M [sc_item_option_mtom].
Add filter:

sc_item_option.item_option_new.name = "quantity_of_routers"

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 · 4 weeks ago

@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,

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

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