Rank: Newbie
Groups: Registered
Joined: 2/21/2018(UTC) Posts: 2  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
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 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...
|
 1 user thanked epf for this useful post.
|
|
|
|
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.
