Report don't work with custom chart

[mohamedapa]

I great dataset to search phrase with the source ip and time but when i try to generate report it appear no matching data also i test the dataset and it work.

  select from_dtime(dtime) as timestamp, ipstr(`srcip`),Hostname, keyword, count(*) as requests from $log where $filter and keyword is not null group by ipstr(`srcip`),dtime,hostname,keyword order by requests desc

kindly help

[hzhao_FTNT]

Please as alias for ipstr(`srcip`), otherwise chart can not determine correct data column.

select from_dtime(dtime) as timestamp, ipstr(`srcip`) as SourceIP,hostname, keyword, count(*) as requests from $log where $filter group by SourceIP,dtime,hostname,keyword order by requests desc