Ygtjki

Would a high gravity rocky planet be guaranteed to have an atmosphere?

Do the temporary hit points from the Battlerager barbarian's Reckless Abandon stack if I make multiple attacks on my turn?

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

Go Pregnant or Go Home

How do I extract a value from a time formatted value in excel?

You cannot touch me, but I can touch you, who am I?

Trouble understanding the speech of overseas colleagues

Method to test if a number is a perfect power?

Lay out the Carpet

What is the best translation for "slot" in the context of multiplayer video games?

A particular customize with green line and letters for subfloat

Why, precisely, is argon used in neutrino experiments?

How can a function with a hole (removable discontinuity) equal a function with no hole?

Is the destination of a commercial flight important for the pilot?

Short story about space worker geeks who zone out by 'listening' to radiation from stars

Sequence of Tenses: Translating the subjunctive

Why didn't Theresa May consult with Parliament before negotiating a deal with the EU?

What is paid subscription needed for in Mortal Kombat 11?

Is `x >> pure y` equivalent to `liftM (const y) x`

Two monoidal structures and copowering

Pre-amplifier input protection

Unreliable Magic - Is it worth it?

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

Was Spock the First Vulcan in Starfleet?

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