Forum Discussion
Solved
Trouble with Data Count
I have a large database with various financial metrics including stock price. I want to show the trend of the stock price over time, however the line chart is displaying the count of stock price and ...
Change it to "Sum" or "Average" or any of the other aggregate measures; since you only have one value per date, "Sum" will work just fine.
In your case, "Average" might be the most prudent measure that you'd use in other visualizations, so I'd recommend you change the default aggregation. Select your Stock Price column and you'll find the option in the Modeling tab at the top. See screenshot:
mikeborg82
Advocate II
Advocate IIif the values are formatted as decimals not text, you should just be able to put date into axis and company into values.