cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
abisaileon11 Regular Visitor
Regular Visitor

How to show a line graph by month

Hello there, 
I making a line graph to show sales of 2018 and 2019. I created a date table and I related this to dates in sales table.

I want the graph looks like this

Sin título.jpg

 

But when I put date in the axis it looks like this 

Sin títulol.jpg

 

I put a column in the date table of months, year and days but in the case of January it sums january of 2018 and 2019

 

s.jpg

 

Hope you can help me.

Thank you. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to show a line graph by month

Put the date hierarchy in instead of the date and choose a hierarchy of year and month and drill down into it to the month. With Categorical turned on.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


3 REPLIES 3
Super User
Super User

Re: How to show a line graph by month

Try changing the x-axis setting from Continuous to Categorical in the Format pane.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


abisaileon11 Regular Visitor
Regular Visitor

Re: How to show a line graph by month

ssss.jpg

 

I tried what you say but it shows me every day of the calendar, and if I put months on the axis box I have the same problem in January that sums sales of january 2019 and 2018.

Super User
Super User

Re: How to show a line graph by month

Put the date hierarchy in instead of the date and choose a hierarchy of year and month and drill down into it to the month. With Categorical turned on.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!