nikhil.katiyar Posted September 27, 2017 Share Posted September 27, 2017 Hi ,I am using line chart to see to a variable vaue at different Timestampsso i have time stamp in row and value variable in column .Now when i run , below query is shown in "Run Query" View in Adhoc Select Sum("Value") as Sum_Value ,timestamp From "pda"."HUL-ValueBlock"group by timestamporder by timestampSo i just want to avoid sum of values in select ,.The Query should be as below :Select "Value" as Value ,timestamp From "pda"."HUL-ValueBlock"group by timestamporder by timestampCan anyone provide the solution of above problem ?? Link to comment Share on other sites More sharing options...
nikhil.katiyar Posted September 29, 2017 Author Share Posted September 29, 2017 Found the Answer Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now