I have this dataset:
It’s last row is 2024-10-20. When I look at the corresponding analysis, the last datapoint is for 2024-10-17. i.e. it looks like it’s using a refresh of the dataset from 3 days ago. How do I force the analysis to use the latest refresh?
After SPICE dataset refresh has been completed, it only stores the latest version of data.
Therefore, a analysis will always use the latest data refresh.
You may go to the dataset to check if that analysis is using this dataset by referring to this document Tracking dashboards and analyses that use a dataset - Amazon QuickSight
Another possibility may be the dataset do not have latest data even refresh was succeed. One of the reason can be there is filter applied in the dataset.
You can create a analysis by using the latest dataset to valid it.
You may go to the dataset to check if that analysis is using this dataset
It definitely does.
Another possibility may be the dataset do not have latest data even refresh was succeed.
It definitely does:
One of the reason can be there is filter applied in the dataset.
No filter as you can see above.
You can create a analysis by using the latest dataset to valid it.
Creating analysis works fine (but isn’t a solution).
Can you share a screenshot from your Analysis including filters applied if any?
Regards,
Giri
if using the same dataset to create a analysis can see latest data but the existing analysis using the dataset cannot, likely there is a filter applied in the existing analysis.
Can show a screenshot of the analysis showing the visual and filter with the old data ?
I managed to stump everyone?
Can I confirm the data type of the date field in dataset preparation screen is String?
and the one showing in the line chart is date?
Can I confirm the data type of the date field in dataset preparation screen is String?
Correct.
and the one showing in the line chart is date?
String/text:
I just saw the image that 2024-10-20 and 2024-10-21 are shown in the chart. but they just not sorted in order, you may use the sorting option to sort by this date column
THANK YOU, ALL!!!