This is the dataset.
Line chart as below.
However, having filter by month is showing duplicates in x-axis.
Hi @lbl ,
I could not replicate your use case with dummy data and could not see the same issue that you reported.
Can you a create a sample analysis in the arena to understand the data granularity?
Thanks,
Prantika
Please create a csv file with the following data.
invoicedate,Product,SelCountryDisp,Sales SGD,month
1/11/2024,A,Singapore,100,1
1/11/2024,B,Singapore,200,1
2/12/2024,A,Singapore,300,2
2/12/2024,C,Singapore,400,2
3/13/2024,A,Singapore,500,3
3/13/2024,B,Singapore,100,3
4/14/2024,A,Singapore,200,4
4/14/2024,B,Singapore,300,4
5/15/2024,A,Singapore,400,5
Create a dataset with the csv, make sure to change invoicedate to date type.
Create the line chart and filter by month as stated in initial post.
Thanks
Hi @lbl ,
QS is not replicating data. It’s just that the chart is “large” and there are very few datapoints, so it just replicates the labels to not show an empty graph.
You can try play with the labels properties to avoid the issue:
If you enter more data, this problem will automatically disappear.
Best Regards!
Andrea
Hi @lbl,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your case or did the solution provided above assist?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you
@andrepgn
it is nothing to do with the number of data points.
now, it is working without any changes. probably, aws fixed this issue backend?
glad that this issue is gone! thanks!
