Reply
Frequent Visitor
Posts: 4
Registered: ‎12-04-2018
Accepted Solution

Problem with a line graph

Hi, 
I'm working with a report of sales, but I have a problem with a line graph. I need to switch rows and columns but when I try to do it I got a message that says that a table can't have more than 2200 columns. Of course I won't show all my registers in the graph. I have another page with filters

 

asdsad.jpg

 

This is part of my table, and the top of the columns are months and years of the sales.

 

grafica bien.jpg

This is how I want to look my graph

 

 

 

And this is what I got

grafica mal.jpg

 

So what I need is to give a each product a line instead of giving a period of time a line.

 

Hope you can help me. 

Thanks

 


Accepted Solutions
Community Support Team
Posts: 5,419
Registered: ‎09-21-2016

Re: Problem with a line graph

Hi @abisaileon11,

 

In Query Editor mode, unpivot columns to format the table structure as below:

1.PNG2.PNG

 

Place [Year_Month] onto X-axis, and place [Product] into legend.

3.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Community Support Team
Posts: 5,419
Registered: ‎09-21-2016

Re: Problem with a line graph

Hi @abisaileon11,

 

In Query Editor mode, unpivot columns to format the table structure as below:

1.PNG2.PNG

 

Place [Year_Month] onto X-axis, and place [Product] into legend.

3.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor
Posts: 4
Registered: ‎12-04-2018

Re: Problem with a line graph

[ Edited ]

Hi
Thank you so mucho for your reply, It has been very helpful.
Now I'm having another problem. When I unpivot the table the column of month/year doesn't respect the order

t.jpg

As you can see. 

And When I create the graph also It doesn't haver order in the axis

grad.jpg

You know how I can solve this?

Thank you for your help.