logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
elvinmejoe  
#1 Posted : Tuesday, February 27, 2018 4:14:37 AM(UTC)
elvinmejoe

Rank: Newbie

Groups: Registered
Joined: 2/21/2018(UTC)
Posts: 2
India
Location: Chennai

Thanks: 2 times
Hi,

I am trying to get count of distinct asset id by status. I edited the custom sql to count (distinct column_name). It is throwing an error at the time of execution. Below is the query that gets generated and throws error.
Please help

SELECT

Count(DISTINCT ['Alerts Data (without formula)$'].AssetID) AS C0,
['Alerts Data (without formula)$'].Status AS C1
FROM ['Alerts Data (without formula)$']
GROUP BY ['Alerts Data (without formula)$'].Status

Thanks,
Elvin
epf  
#2 Posted : Tuesday, February 27, 2018 8:03:17 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 552
Switzerland

Thanks: 7 times
Was thanked: 78 time(s) in 76 post(s)
It is the good approach to tune the SQL generated, but you have to fight with your SQL engine (looks like Excel in your case)...
So I would say it is a pure Excel issue to perform SELECT DISTINCT...


thanks 1 user thanked epf for this useful post.
elvinmejoe on 2/27/2018(UTC)
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.