• Content count

  • Joined

  • Last visited

About coryj

  • Rank
    Forum Newbie
  1. 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