Error in Line chart of ad hoc

[nikhil.katiyar]

Hi ,

I am using line chart to see to a variable vaue at different Timestamps

so 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 timestamp

order by timestamp

So 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 timestamp

order by timestamp

Can anyone provide the solution of above problem ??

 

[nikhil.katiyar]

Found the Answer