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:
Out of my understanding, you need Company A values as a Line against the dates.
Just drop the Date column into axis field(remove date hierarchy and select Date) and Company A into values field.