Why is my line graph falling to 0 after each month and why is there a sudden spike in december? (this is in Tableau)

84 Views Asked by At

Revenue month chart of 2011

I am supposed to make line chart to analyse the revenue for each month in a particular year. So what should be done other than this? Is this one right?

2

There are 2 best solutions below

0
Valantis Vasilakis On

The Revenue column is the problem. I believe you want a continuous measure (Sum, Max, Avg etc) while you are now using a continuous dimension.

Remove the Revenue from rows and bring a Sum(Revenue) or similar.

0
Mox On

Wrong chart type, and (perhaps) data aggregation issue - you want a bar chart by month, not a line-chart by day.