Forum Discussion
Data Value Displays As Count In My Line Chart
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.
Let me clarify a few things:
1) The screenshot I shared IS the dropdown for "Count of TotalSpend". I renamed the field to "Spend" so its name is unique. Here is another screenshot of the dropdown:
2) I notice that the fields for my line chart look different than the one shared by Pragati. My line chart has fields for "Axis", "Legend", "Values", "Secondary values", "Small multiples" and "Tooltips". The visual I see from Pragati only has a "Values" field.
3) I changed the name of the data field to "Spend" so it is clear which field I'm working with.
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.
Apologies for not tagging you the first time. I'll remember to tag the user I'm responding to going forward.
Thanks for the info on how the line charts work. I'm using SUM now and I'm getting the numbers I expect. Didn't realize I could only have those three options in the line chart.