I have a data like
I wanna plot Product on X-axis like 4 2 3 4 but not 1 2 3 4 so as to get the continuous line.
Can anyone help me
Attached is my current applicaiton.
I think you forgot to attach. Please attach it again.
How are you?
Here is my attachment.
See if this helps (Sorting on Y-value Ascending)
Sunny, i tried that but the X-axis values were loading from 1. So, it still shows the same result.
Isn't this what you want?
That was an example i stated.
But its not working with my actual data since i have to select the option "Continuous" in the chart as the data on X-axis is huge.
U can find my app. in the attachment.
The chart in attached qvw is empty. Do you want to repost the qvw after adding the dimension and expression back with your required settings.
I Apologize for the mistake.
Here is the actual app.
I was wondering why does it take so much time when i use continuous option in the line chart.
use dual when you load product. text can be the product name and number the order you need it.
if you sort by product in your chart, it will sort by number not text
Can you please explain it.
Create a line chart with Dimension: Product & Expression : Sum(Sales)
Now go to chart properties and go to sort Tab, check Y-value Ascending
Its still the same result.
Retrieving data ...