Empty report, but dataset is ok.

[zhandos-s]

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 ? 

[Anthony_E]

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,

[Anthony_E]

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,