Chart Showing Same Values For each Month

[ShaneL79]

I am trying to build a chart using some existing data from several tables. Specifically, I want to show the duration of events for each month.

Example: 

MONTH	WHAT IT DISPLAYS	WHAT IT SHOULD DISPLAY
JAN	500	125
FEB	500	75
MAR	500	50
APR	500	150
MAY	500	100

From some research, it looks like the issue may be related to a missing relationship. However, I have attempted several relationships using the tables involved in this data and am unable to get the right relationship configuration.

Can someone please help me figure out how to determine the correct relationship?

[ShaneL79]

That makes sense. I was looking for a higher level understanding initially, but after watching some videos I am still stuck. My issue now is how to give you that file or data without compromising my companies confidentiality. Is there a typical or simple way to provide this that is commonly used on here? Unfortunately my file is rather huge (175MB) and links several datasources.

[PhilipTreacy]

Hi @ShaneL79 

Impossibl;e to help you without seeing your file/data.

regards

Phil