Skip to main content
zhandos-s
New Member
January 5, 2023
Question

Empty report, but dataset is ok.

  • January 5, 2023
  • 2 replies
  • 1050 views

Hello, I have this issue where our custom dataset shows exactly what we need, but when creating chart and report it comes empty. 

Dataset is:

select distinct("user"), concat('/',split_part(url, '/',2), '/' ,split_part(url, '/',3), '/' ,split_part(url, '/',4))
from $log
where $filter and app = 'Google.Docs'
and ((url like '/spreadsheets/%') or (url like '/document/%')) and not (url like '%backgroundsync%')
group by concat, "user"

 

Can anyone help ? Probably this is a bug ? 

2 replies

Anthony_E
Staff
Staff
January 9, 2023

Hello,

 

Thank you for using the Community Forum.

I will seek to get you an answer or help. We will reply to this thread with an update as soon as possible.


Regards,

Best Regards
Anthony_E
Staff
Staff
January 9, 2023

Hello,

 

I found this KB article:

 

https://community.fortinet.com/t5/FortiAnalyzer/Troubleshooting-Tip-Empty-reports/ta-p/206939

 

Could you please tell me if it helps?

 

Regards,

 

Best Regards