Mrthdrb

Sort a list by elements of another list

What is the intuitive meaning of having a linear relationship between the logs of two variables?

What is the opposite of 'gravitas'?

How to run a prison with the smallest amount of guards?

How to Reset Passwords on Multiple Websites Easily?

Term for the "extreme-extension" version of a straw man fallacy?

How can I kill an app using Terminal?

Class Action - which options I have?

How to be diplomatic in refusing to write code that breaches the privacy of our users

What is the difference between "behavior" and "behaviour"?

Do all network devices need to make routing decisions, regardless of communication across networks or within a network?

Two monoidal structures and copowering

Closest Prime Number

Trouble understanding the speech of overseas colleagues

What does the word "Atten" mean?

How to check is there any negative term in a large list?

Why are there no referendums in the US?

Did Dumbledore lie to Harry about how long he had James Potter's invisibility cloak when he was examining it? If so, why?

I'm in charge of equipment buying but no one's ever happy with what I choose. How to fix this?

Are student evaluations of teaching assistants read by others in the faculty?

How do I go from 300 unfinished/half written blog posts, to published posts?

Method to test if a number is a perfect power?

What happens if you roll doubles 3 times then land on "Go to jail?"

Where does the Z80 processor start executing from?

Custom report from SQL query

display a sql query being generatedGet full list of categories using sqlModify SQL query to also get number of times orderedMagento Direct SQL New vs Existing CustomersHow to pass a complete SQL query to the model?Number of orders by categorysql query to get Products price, sku, product_id, description and url to pictureSort Product Collection By Event Date Custom fieldSQL Query Newsletter subscription status with custom tablesHow to customize 'Order Total Report' (REPORTS > Customers > Order Total) in magento 2.2.6

2

I want to get order total of the month January 2019 for complete orders

I need to know tables related to this query, or if someone can share query that would be great.

magento2 sql custom-reports

share|improve this question

edited yesterday

Muhammad Hasham

2,7012831

asked yesterday

Muhammad AnasMuhammad Anas

11211

New contributor

Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  order total, you mean the total number of orders for year 2019 or the total sum of amount of all the order for the specific month?
  
  – magefms
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I need sum amount
  
  – Muhammad Anas
  yesterday
  

  
  
  
  

add a comment | 

2

I want to get order total of the month January 2019 for complete orders

I need to know tables related to this query, or if someone can share query that would be great.

magento2 sql custom-reports

share|improve this question

edited yesterday

Muhammad Hasham

2,7012831

asked yesterday

Muhammad AnasMuhammad Anas

11211

New contributor

Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  order total, you mean the total number of orders for year 2019 or the total sum of amount of all the order for the specific month?
  
  – magefms
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I need sum amount
  
  – Muhammad Anas
  yesterday
  

  
  
  
  

add a comment | 

I want to get order total of the month January 2019 for complete orders

I need to know tables related to this query, or if someone can share query that would be great.

magento2 sql custom-reports

share|improve this question

edited yesterday

Muhammad Hasham

2,7012831

asked yesterday

Muhammad AnasMuhammad Anas

11211

New contributor

Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited yesterday

Muhammad Hasham

2,7012831

asked yesterday

Muhammad AnasMuhammad Anas

11211

New contributor

Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited yesterday

Muhammad Hasham

2,7012831

asked yesterday

Muhammad AnasMuhammad Anas

11211

New contributor

Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited yesterday

Muhammad Hasham

2,7012831

edited yesterday

Muhammad Hasham

2,7012831

asked yesterday

Muhammad AnasMuhammad Anas

11211

New contributor

Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked yesterday

Muhammad AnasMuhammad Anas

11211

2 Answers
2

active

oldest

votes

2

Your questions seems double meaning for me, so here I'll post my answer assuming:

You want to get the Total Numbers of order for the specific month, below query should work

SELECT count(entity_id) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019'; 

You want to get the total sum amount you can try this (This will filter only order that are completed):

SELECT sum(base_grand_total) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';

share|improve this answer

answered yesterday

magefmsmagefms

2,0722426

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  It worked. Thanks
  
  – Muhammad Anas
  yesterday
  

  
  
  
  

add a comment | 

1

Here is query which will give you order total of completed order's for month jan 2019:

SELECT sum(base_grand_total) FROM sales_order
WHERE created_at >='2018-12-31 23:59:59.000' AND created_at <= '2019-02-31 
23:59:59.000' AND status='complete'

share|improve this answer

answered yesterday

Mohit chauhanMohit chauhan

516111

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks Mohit, but it is showing warning that incorrect datetime format
  
  – Muhammad Anas
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for answer. +1
  
  – Muhammad Anas
  yesterday
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

Muhammad Anas is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f267395%2fcustom-report-from-sql-query%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

Your questions seems double meaning for me, so here I'll post my answer assuming:

You want to get the Total Numbers of order for the specific month, below query should work

SELECT count(entity_id) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019'; 

You want to get the total sum amount you can try this (This will filter only order that are completed):

SELECT sum(base_grand_total) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';

share|improve this answer

answered yesterday

magefmsmagefms

2,0722426

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  It worked. Thanks
  
  – Muhammad Anas
  yesterday
  

  
  
  
  

add a comment | 

2

Your questions seems double meaning for me, so here I'll post my answer assuming:

You want to get the Total Numbers of order for the specific month, below query should work

SELECT count(entity_id) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019'; 

You want to get the total sum amount you can try this (This will filter only order that are completed):

SELECT sum(base_grand_total) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';

share|improve this answer

answered yesterday

magefmsmagefms

2,0722426

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  It worked. Thanks
  
  – Muhammad Anas
  yesterday
  

  
  
  
  

add a comment | 

Your questions seems double meaning for me, so here I'll post my answer assuming:

You want to get the Total Numbers of order for the specific month, below query should work

SELECT count(entity_id) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019'; 

You want to get the total sum amount you can try this (This will filter only order that are completed):

SELECT sum(base_grand_total) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';

share|improve this answer

answered yesterday

magefmsmagefms

2,0722426

SELECT count(entity_id) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019'; 

SELECT sum(base_grand_total) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';

share|improve this answer

answered yesterday

magefmsmagefms

2,0722426

answered yesterday

magefmsmagefms

2,0722426

answered yesterday

magefmsmagefms

2,0722426

1

Here is query which will give you order total of completed order's for month jan 2019:

SELECT sum(base_grand_total) FROM sales_order
WHERE created_at >='2018-12-31 23:59:59.000' AND created_at <= '2019-02-31 
23:59:59.000' AND status='complete'

share|improve this answer

answered yesterday

Mohit chauhanMohit chauhan

516111

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks Mohit, but it is showing warning that incorrect datetime format
  
  – Muhammad Anas
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for answer. +1
  
  – Muhammad Anas
  yesterday
  

  
  
  
  

add a comment | 

1

Here is query which will give you order total of completed order's for month jan 2019:

SELECT sum(base_grand_total) FROM sales_order
WHERE created_at >='2018-12-31 23:59:59.000' AND created_at <= '2019-02-31 
23:59:59.000' AND status='complete'

share|improve this answer

answered yesterday

Mohit chauhanMohit chauhan

516111

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks Mohit, but it is showing warning that incorrect datetime format
  
  – Muhammad Anas
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks for answer. +1
  
  – Muhammad Anas
  yesterday
  

  
  
  
  

add a comment | 

Here is query which will give you order total of completed order's for month jan 2019:

SELECT sum(base_grand_total) FROM sales_order
WHERE created_at >='2018-12-31 23:59:59.000' AND created_at <= '2019-02-31 
23:59:59.000' AND status='complete'

share|improve this answer

answered yesterday

Mohit chauhanMohit chauhan

516111

SELECT sum(base_grand_total) FROM sales_order
WHERE created_at >='2018-12-31 23:59:59.000' AND created_at <= '2019-02-31 
23:59:59.000' AND status='complete'

share|improve this answer

answered yesterday

Mohit chauhanMohit chauhan

516111

answered yesterday

Mohit chauhanMohit chauhan

516111

answered yesterday

Mohit chauhanMohit chauhan

516111