Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Hi Exploring Performance Analytics indicators

Prasun Sarkar7
Tera Expert

Hello I have a requirement to show the sum of the total contract value from the ast_contract table using PA and display it in dashboard,

Can it be achieved please suggest the steps 

Thanks 

1 ACCEPTED SOLUTION

SumanthDosapati
Mega Sage
Mega Sage

@Prasun Sarkar7 

  1. Navigate to Data Visualizations
  2. Create a single score type of widget on ast_contract table
  3. Change the metric to 'Sum' from 'Count' and choose the field whose sum you want to calculate.

Check the below screenshot example where i set the sum of 'Total Cost' field.

SUMANTHDOSAPAT_0-1747047162589.png

Accept the solution and mark as helpful if it does, to benefit future readers.
Regards,
Sumanth

 

View solution in original post

7 REPLIES 7

In that case you can use the same.

In your workspace,

> Click on Edit and and then select Library and choose the report which we created in previous steps that it!!.

OR 

You can even directly create a new visualization also as in this link. And then build the same single score type of report as i showed earlier.

 

Accept the solution and mark as helpful if it does, to benefit future readers.
Regards,
Sumanth

oh ok ok

@Prasun Sarkar7 

If you got your answer, Accept the solution and mark as helpful to benefit future readers.

 

Regards,

Sumanth