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.

How to show limited months of data only

Sironi
Kilo Sage

Hi Team,

I want to show data only till March-2024 month , should not show any months names/ data after March-2024.
how to limit it.

Sironi_0-1714586929642.png

Sironi_1-1714586989970.png

 

Sironi_2-1714587047851.png

 



1 ACCEPTED SOLUTION

Bert_c1
Kilo Patron

Stop the data collection job by setting Active to false, or from the Indicator form delete the Data Collection job there.

Screenshot 2024-05-01 155135.png

  Delete any score data after the desired data, table is 'pa_scores_l1'.

Screenshot 2024-05-01 155514.png

View solution in original post

4 REPLIES 4

Bert_c1
Kilo Patron

Stop the data collection job by setting Active to false, or from the Indicator form delete the Data Collection job there.

Screenshot 2024-05-01 155135.png

  Delete any score data after the desired data, table is 'pa_scores_l1'.

Screenshot 2024-05-01 155514.png

How can we delete Deleting Score Date 

go to the "pa_scores_l1" table, and filter on the desired indicator. Data can always be re-generated using a Historical Data Collection job, where the start and end dates can be specified.

You are awesome, Thanks I deleted April 2024 data records from " pa_scores_l1 " table.

Sironi_2-1714607710892.png

 

Sironi_4-1714607867355.png

Now No April  month .