Forum Discussion
Chart Showing Same Values For each Month
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?
2 Replies
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.
