Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

query editor & line chart

Hello,

I have absolutely no idea what is going on and have been tying to figure ot out all day, knowing me I am missing something simple.

My data values does not go beyond 100 yet when I apply my data to a linegraph it is well past 100 and wrong.

I have 3 attributes in my legend: New orleans, Jazz and Voodoo. The dates are monthly (along x axis) and are from 2004 to present, the values are anwhere between 0 and 100. I have date applied to the dates, abc applied to attributes and whole numbers applied to the values from 0-100.

 

An eg would be:                 01/04/2004   New Orleans   24

 

I am using data from google trends about search term popularity

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous this is what I will do, on table visual, add date column, add attribute column, and add attribute column again and change the aggregation to count and sort by this count aggregation column and you expect count 1 for each row and then we can debug it from there.

8 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous it will sum entries for the same date and same attribute, can you make sure that 01/04/2014 for new orleans only one record, if you have more than one record that it will show the sum

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you for your reply,

      There is only one on record, each date has 3 different attributes and 3 seperate values. So it should not sum them up.

      I did it exactly the same as the first time I did it, see below, and it worked (With Year along x axis, amount along y and race as legend). I'm stumped

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous this is what I will do, on table visual, add date column, add attribute column, and add attribute column again and change the aggregation to count and sort by this count aggregation column and you expect count 1 for each row and then we can debug it from there.