x Want to participate? Join the group to interact

Sage X3

Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.

Sage Enterprise Intelligence Graph of quantity ordered

State Suggested Answer
Replies 2 replies
Answers 1 answer
Subscribers 40 subscribers
Views 1128 views
Users 0 members are here

Browse Forums

234

topics

29

replies

General Discussion

5k

topics

13k

replies

Sage Data & Analytics

56

topics

95

replies

Sage Enterprise Intelligence

209

topics

410

replies

Sage Intelligence Reporting

121

topics

322

replies

Graph of quantity ordered

SUGGESTED

Posted By John Mitchell over 2 years ago

Anyone know how automatically show only the last 30 days data?

Top Replies

Pablo ES over 2 years ago +1 suggested

SQL range with date, something like (invoice date >= current date - 30 days) I can look into specifics if this doesn't get you going.

Cheers,

Parents

0 Pablo ES over 2 years ago

SUGGESTED

SQL range with date, something like (invoice date >= current date - 30 days) I can look into specifics if this doesn't get you going.

Cheers,
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 John Mitchell over 2 years ago in reply to Pablo ES

I was trying to do it with a filter based on order date(sales orders). Nor sure how to describe that. Is there some specific built in functions I can mix in the statement?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 John Mitchell over 2 years ago in reply to Pablo ES

I was trying to do it with a filter based on order date(sales orders). Nor sure how to describe that. Is there some specific built in functions I can mix in the statement?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data