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

[lutfishah]

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

 

[Nuos]

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.

[lutfishah]

Thanks for your reply.

Would you know a better way of calculating the sums of invoices per hour. I need a calculation please.

[comment]

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?

[Nuos]

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

[lutfishah]

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

[comment]

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.

[Nuos]

Do you still need help on this?

[lutfishah]

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.