While attempting to transform data related to shift timings in Amazon QuickSight, specifically concerning breaks and slot timings, the following error occurred:
No data available for preview.
Details: QuickSight fetches up to 1000 sample rows from each data source table before applying transform operations. However, the transformation process for shift timings resulted in:
There are currently 0 rows of data available for preview as a result of the operations performed on sample rows of data. You may save the dataset and visualize all data from source in Analysis.
Context:
- Data Source: The dataset contains fields related to shift timings, including breaks and slots.
- Operations Performed: Transformations involving parsing and manipulating time data from string fields (e.g.,
Slot,Meal Break,Break-1,Break-2). - Problem Encountered: The data preview fails to display any rows after applying the transformations, suggesting that the transformations might be filtering out all sample data or causing errors that prevent data from being processed correctly.
Steps Taken:
- Attempted to transform time fields into minutes for comparison.
- Applied various functions for parsing and calculating time intervals.
- Encountered issues with syntax or logic in transformations, leading to no data being available for preview.
Desired Outcome: Identify the cause of the issue and resolve it to ensure that the dataset preview works correctly, allowing further transformation and analysis of shift timings data.
formulas tried: start_time = substring({Slot}, 0, 5)
end_time = substring({Slot}, 6, 11)
meal_break_start_minutes = parseInt(substring({Meal Break}, 0, 2)) * 60 + parseInt(substring({Meal Break}, 3, 2))