Hello, I have a line chart where I want to have the order of dates equal to my table. Example.
As we see in the image above, in the table the 29-dic is separated into two lines because they belong to two different "CAMPAÑAS". I mean that in the graph they have to appear in different lines because the objective is to separate by "CAMPAÑAS".
Try ordering but the line of the CAMP 2019 and CAMP 2017 join and should be separated.
Please help me with the topic.
I attach the Qvw.
the problem is your chart %s are associated with the same period, which is day-month combination. Try to add year to this combination: 29-dic-2017 and use it as a dimension.
Hi Cristian! I think the problem is solved if you use
=if(len(trim(PERIOD1)), Right(CAMPAÑA, 4) & '-' & PERIOD1)
as your first dimension. Please find the attached file whith my solution!
I don't think you can solve it whithout changing the dimension (as I did adding the year from CAMPAÑA). If the dimension is DAY-MONTH (as it is), then both values from 2017 and 2019 will be necessarily aligned because the tag that group both values (29-dic) is the same.
In this case, I'd suggest to review this article by HIC:
As-of-Table may resolve your problem.