Average sale price per quarter

[El_Pablo]

Hi,

I'm new to charting. I've been trying to create a bar graph to show average sale price per quarter for houses.

I've done the following relationships :

analysis (pkAnalysis, ...)

elements (pkElementID, fkAnalysis, fkSaleID, ...)

sales (pkSaleID, price, quarter, ...)

The layout is on analysis. How can I do bar chart using the quarter for the X-axis and the average price per quarter for the y-axis?

Thanks

[Matthew F]

What happens if you insert a chart on the layout and designate the fields of your choice to the x and y axes?

[El_Pablo]

The X-axis doesn't merge the quarters together.

Here is the resulting graph.

Uploaded with ImageShack.us

[El_Pablo]

Anyone? Will I need to create a quarters table? Makes non sense to me. Since we should be able to group sales per quarter.

[El_Pablo]

Here is an example file with some sample data.

forumInspection.zip

[Matthew F]

In your example file the problem has nothing to do with charting per se, it is a calculation error. Your calculated field would not show the average values in a portal either. You need to create a calculation or a relationship that aggregates the records by quarter. As it stands, your calculation averages all of the prices regardless of quarter.

[El_Pablo]

Ok, so you say that I'll need a quarter table related to the analysis table?

If the database is for a chain store.

How would I then filter out the sales per store per quarter? Would I need to create another relationship?

[Matthew F]

I think there is more than one way to compute averages, including setting up a new relationship. Your attachment was complicated and I didn't understand what it was trying to achieve so I simplified just to illustrate an approach with a new table/relationship. My guess is that, if you can get the calculation working in a portal it will work in a graphic as well.

Matthew

forumInspection.fp7.zip