historical dashboard showing incorrect data

Ashwini Sawant2
Tera Contributor

Hello Community,

 

Below is the requirement

 

I would like to have a historical dashboard that shows every month the number  of Knowledge articles created (trend) per RAA (Risk Acceptance Agreement) 

Example:  

AshwiniSawant2_0-1755508186137.png

Filter with the Short Description of the Knowledge article and a Filter per category (Risk Acceptance Agreement and related categories 

 

AshwiniSawant2_1-1755508223782.png

 

-----------------------------------------------------------------------------------------------------------

Solution -

 

I am facing issue with the result in the dashboard - 

 

I have tried to create stacked chart column catergory wise but the data showing is incorrect.

 

AshwiniSawant2_1-1755528413635.png

Schedule Job -

AshwiniSawant2_2-1755528473589.png

below is the filter condition I have applied in the indicator source -

 

AshwiniSawant2_0-1755528361306.png

when I am clicking on any category and then on show records below are the only records I am able to see -

AshwiniSawant2_3-1755528743290.png

 

 

 

Anyone please suggest what could be the reason and how to resolve this issue?

 

1 REPLY 1

Nikhil Bajaj9
Tera Sage

Hi @Ashwini Sawant2 ,

 

Dashbaord is a collection of reports and other widgets. First you need to create your reports, once reports are ready. Go to Dashbaord and add those reports in Dashbaord. Try it and let me know the feedback.

 

To create a historical dashboard in ServiceNow that shows monthly trends of articles created per category, you'll need to leverage Performance Analytics and Reports. First, create a new dashboard. Then, create a report. Finally, add this report as a widget to your dashboard. 

 

Regards,

Nikhil Bajaj

Please appreciate my efforts, help and support extended to you by clicking on – “Accept as Solution”; button under my answer. It will motivate me to help others as well.
Regards,
Nikhil Bajaj