Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

How to show limited months of data only

surajsironi
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 .