Query Fortianalyzer

Hi Everyone,

I am new to this forum and was hopping that someone can help me with the following issue.

I want to make a line chart in FortiAnalyzer that shows me the blocked traffic from the outside world of the past month.

Now I have this following query:

SELECT itime, action

FROM $log

WHERE srcintf='wan1'

See below what I get in return:

[image][/image]

So far so good. Itime I can format with the option in chart settings, but action does not count.

[image][/image]

I am not a SQL hero (I know the basics), but I was wonder if anybody can help me with this problem.

How can I get a nice line chart that tells me how many Deny there a each day of the past month.

Thanks in advance,