SQL query working fine in Data Analyzer but not working while trying to create analytics

[Debanjana]

Hi ,

We are using a query that is  select firstname, lastname,username,DATE_FORMAT(customproperty21,"%Y-%m-%d %H:%i:%s"), count(*) as duplicate_count from users group by firstname, lastname, DATE_FORMAT(customproperty21,"%Y-%m-%d %H:%i:%s") having count(*)>1  . This query is working fine in Data analyzer but when we are trying to create analytics using this query, it's throwing error. Attaching the screenshot of the error for your reference. Also attaching the logs. Kindly help me out.

Thanks,

Debanjana Ghosh

[This message has been edited by moderator to mask sensitive info from an attached image]

[NM]

Hi @Debanjana , error image shows statuskey but not the query which you shared.

[rushikeshvartak]

select firstname, lastname,username,DATE_FORMAT(customproperty21,"%Y-%m-%d %H:%i:%s")dat, count(*) as duplicate_cnt from users group by firstname, lastname, DATE_FORMAT(customproperty21,"%Y-%m-%d %H:%i:%s") having count(*)>1