Forum Discussion
query editor & line chart
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.
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
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.
Hi
Thanks for your help, I will just mark the issue as solved and try and use less complicated data. I am new to power BI and its like you are speaking a completely different language. I cant do what you have asked of me because I dont know what you mean.
Thanks for your help its very much appreciated.
Anonymous hmmm not sure if you need mark it answer if your issue is resolved. I can walk thru the process if that helps.
okay...When you say add a column, do you mean in excel? Can you add a column in power bi?
Where is aggregation count?
Here is where I got my data from:
https://trends.google.com/trends/explore?date=all&q=New%20Orleans
I downloaded the csv from interest over time.
Maybe we should start from downloading the data if you have the time?