I have what I think is a fairly simple situation that I cannot figure out. I am trying to make a chart that averages revenue on reporting period, then can drill down into average based on market. The column results of my query are as follows (revenue is simply an integer):
When I configure my chart, I choose to import all three data fields and apply no filters and go to the grouping tab, selecting the following options:
This seems in-line with what I have seen in the instructional videos posted here. However, when I save the chart and look at it, the average Revnue for each reporting period is displayed properly, but when I click on a reporting period, instead of seeing each Market's average within that period, I see "No data to display."
What am I doing wrong?
Thank you for your assistance.
Cory
