Forum Discussion
Data Value Displays As Count In My Line Chart
- 4 years ago
HI Anonymous ,
first thing can you make sure to tag me in your responses, so that I know they are intended for me or not. (use @ before my name)
Thanks for adding more details on your query as it was not mmentioned earlier what kind of chart you are using in your case.
When you move a numeric/decimal/currency type value to a visual like line chart, it by default summarises it to either SUM/AVERAGE/COUNT/etc.
In your case first thing what you really need to do is- modify datatype of LAUNCHDATE column to DATE which is used as an axis on your chart.
I see in the screenshot that data view shows data at a day level, so what you will do is after launchdate is set to DATE data-type; move it as an axis to your chart and your Spend column to values section. Let the summarisation be SUM (which is by default); then you need to drill down to DAy level hierarcy to see the actual data. Something like shown in the quick video below:
Hope this helps.
That's the problem, I don't have that option:
- Pragati114 years agoSuper User
Hi Anonymous ,
In your screenshot, I can see there are 2 tables having same column Total Spend.
One seems to a numeric field with formatting options which is under BudgetSpent table and the other once looks like a text data-type which is under ScorpionOneSpendPer.. table.
Are you sure you are formatting the right column as Currency type and then using the right column on your visual?