none
How to build a Line chart from a crosstab data source? RRS feed

  • Question

  • I've been going through the tutorials and can't find what I'm looking. I hope someone can point me in the right direction.

     

    I'm trying to build a line chart based on a dataset that consist of the following fields:

    Funnelcode

    Week1

    Week2

    week3 ... week28

     

    Data source will have 4 records with funnelcode values of "Above, Middle, Low, and  below".  Each record containing values in the week fields.

     

    So I'm trying to define the X axis labels to coordinate with the week fields, but having no luck.

     

    Is this going to be doable, or do I need to normalize this table?

     

    Thanks!

    Thursday, July 12, 2007 5:50 PM

All replies

  • bump...could use some help still
    Tuesday, July 24, 2007 7:38 PM
  • Would I be better off trying to normalize the data into a temp table?

     

    Thursday, July 26, 2007 7:23 PM
  • I think that you should not use crosstab data source.
    Your dataset should consist this following fields :
    -FunnelcodeValue
    -WeekName
    -Value

    So in your chart properties, on the data tab:
     Values ->use Values
     Category Group->use WeekName field
     Series Group -> use FunnelcodeValue field

    Then the report will create it self.

    Please tell me that this work.


    Monday, July 30, 2007 10:27 AM