Jump to content
Changes to the Jaspersoft community edition download ×

Error in Line chart of ad hoc


nikhil.katiyar

Recommended Posts

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 ??

 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...