Dashboard report doesn't show any record

[Community Alums]

Hi experts, 

I have a report on my dashboard of type score. Now I used a script to return the sys_ids that I want, the issue is I'm getting all the sys_ids but the count remains 0. Does anyone know what's going on with my script or report filter (report also follows interactive filter, just mentioning).

I have attached the screenshot of my report and also the script include.

Then I also used "sys id is javascript: new scriptName().function()" in screenshot report 2

Thanks in advance!

[Dr Atul G- LNG]

Hi @Community Alums 

1. Pending exclusion (all cases including all prior years too, but we only want this years cases) 

Atul: Add condition created this year.

2. Complete cases( status is approved)

3. Closed (status = Closed/denied)

4. last year exclusion in review( which were pending last year but might have completed/closed or still pending for this year)

Atul: Add condition created this year.

5. Is the total (which is 1+2+3-4 = 5)

but as you can see the total of report 2 and 3 (which is closed and complete cases) the count is greater the total (at this point its missing 15 pending cases for this year).

[Community Alums]

Hi,  @Dr Atul G- LNG 

Atul: Add condition created this year.

Pending records can be created last year and still be pending as they are in case review, I tried everything with filter I'm not getting the correct results. That's why I was trying with the script and as you can see I'm getting the sys_ids but still the count remains 0. I don't know why It doesn't show anything. That was my original issue.

When I tried it on my personal instance for incident table I'm getting the correct result but for this (maybe its scoped app) I'm receiving this warning 

I also tried accessible from = all application scope but same result (I don't think I even have make it accessible from other app as the scope of the application and report is the same).

Thank you!

[Dr Atul G- LNG · Accepted solution]

Hi @Community Alums 

Agree, in this case what I suggest

let's try to build this report on list view first and see how many records in this year and last year. This will help us to see what wrong we are doing.

[Tai Vu]

Hi @Community Alums 

Have you attempted to verify those Sys IDs returned in the table you're reporting on?

Simply click on the score number, and it will redirect you to the list of records, allowing you to verify the existence of any records.

Cheers,

Tai Vu

[Community Alums]

hi @Tai Vu , thank you for replying, when I clicked on the 0 it shows ALL>Sys Ids in NULL, but I'm getting sysIds in the report as its highlighted in the screenshot, and when I select those sys_ids and pasting them in the table list view I'm getting the results.