Jump to content

Calculate (sum/add) hourly Sale/Invoice and display on chart in a bar format


lutfishah
 Share

This topic is 2809 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

 

I need a bit of help with my filemaker database. I'm not really good at using Filemaker charting system.

I want to display the hourly sales in a chart.

So if someone could please let me know a better way of getting totals of the invoices per hour of one day and then displaying them on a chart per hour. 

so

x-axis = 09:00 10:00 11:00 12:00 13:00 .....

y-axis = the totals of the invoices.

 

Many Thanks for you help

 

Link to comment
Share on other sites

I once heard from a filemaker expert on charts that you must be able to display the wanted data in a portal or list view to get it to display properly in a graph.  This idea helped me a lot in getting charts to work.  Can you create a garbage layout that displays in a portal time AND total sales for that time.  If you can then chart those fields >> done like dinner.

 

If you need more help on how t set up the data to display let me know.

  • Like 1
Link to comment
Share on other sites

So if someone could please let me know a better way of getting totals of the invoices per hour of one day and then displaying them on a chart per hour. 

so

x-axis = 09:00 10:00 11:00 12:00 13:00 .....

y-axis = the totals of the invoices.

 

Your question is not clear. Do your invoices have an Hour field? Or a Time field? And do you want to aggregate ALL invoices for a given hour - regardless of their date?

Link to comment
Share on other sites

I would be happy to ... But I need some sample data. Please email or create a Dropbox link to a file I can work with. Doesn't have to be FileMaker but would prefer this

Link to comment
Share on other sites

Your question is not clear. Do your invoices have an Hour field? Or a Time field? And do you want to aggregate ALL invoices for a given hour - regardless of their date?

Sorry about that. Yes all invoices per hour per calendar date. Basically current date.  Yes I have the time field. 

So lets say there are sales made 

Date: 18/03/2015

Invoices

09:00  ---  100.00

09:05  ---  200.00

09:30  ---  50.00

10:00  ---  90.00

10:15  ---  300.00 ... so on

 

Totals Per hour

09 hrs = 350

10 hrs = 390  ...  

I would be happy to ... But I need some sample data. Please email or create a Dropbox link to a file I can work with. Doesn't have to be FileMaker but would prefer this

Thanks so much ... I will quickly create a test file for you.

Cheers

Link to comment
Share on other sites

Yes all invoices per hour per calendar date. Basically current date.  Yes I have the time field. 

 

If you have a time field, define a calculation field cHour (result is Number) =

Hour ( Timefield )

Find the records for the date you wish to display and sort them by cHour.  Set your chart to:

 

Horizontal (X) Axis: Calculation = Invoices::cHour & ":00"

Vertical (Y) Axis: Field = Invoices::sTotalAmount

 

Use Data From: [ Current Found Set ]

[x] Show data points for groups of records when sorted

 

where sTotalAmount is a summary field, Total of invoice amount.

 

 

 

Please email or create a Dropbox link to a file I can work with.

 

If you want to have a private conversation with the OP, send them a private message. If not, ask them to post their files here - so that any member can see them and participate.

  • Like 1
Link to comment
Share on other sites

Do you still need help on this?

Hi Nuos,

 

Thanks very much for your help. I have managed to make it work. So for the time being I'm fine. 

Sorry I couldn't reply to any of the posts as I was away.

 

Best regards.

Link to comment
Share on other sites

This topic is 2809 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.