I am trying to use Period to date insight however when I add my time and value columns the insights gives “There is no data available.” even though there is.
The data consists of 17k rows and QS already detected my time column as a date. How can I use this insight?
What aggregation have you selected for the field in the “Time” well? Is it “day”, “week”, “month” etc?
Let’s say you selected “Month”. Do you have data in the current month and the previous month? (This insight is trying to compare current month to the previous month)
If you still need help, can you explain what you are trying to show? (May be what you are trying to do can be achieved differently, e.g. by using KPI visual)
Hi, @Yagiz_Ihlamur. Did @Tatyana_Yakushev’s solution work for you? I am marking her reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!