we are trying to add 2 calculated field in custom SQL dataset Quicksight which is given below but values not showing in dataset
0
we are trying to add 2 calculated field in custom SQL dataset which is given below but values not showing in dataset
1st is - AsilePrice
sumOver ( sum({SALEAMT}), [{AISLE_NAME}] )
2nd is ProductPrice
avgOver
(
max({SALEAMT}),
[{AISLE_NAME}]
)
---------------------------------
질문됨 2달 전481회 조회
1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
It seems like you're trying to add calculated fields in a custom SQL dataset, but the values are not showing up in the dataset. Here are some suggestions to troubleshoot the issue:
- Verify SQL Syntax: Double-check the syntax of your SQL queries for calculating the fields. Ensure that the syntax is correct and matches the SQL dialect of your database.
- Check Dataset Refresh: Ensure that the dataset has been refreshed after adding the calculated fields. Sometimes, changes to the dataset schema may require a refresh to reflect in the data.
- Debug SQL Queries: Run the SQL queries for the calculated fields directly on your database to verify if they are producing the expected results. This can help identify any issues with the SQL logic.
- Inspect Dataset Configuration: Review the configuration of your dataset in the AWS environment. Ensure that the calculated fields are correctly configured and mapped to the appropriate columns in the dataset.
- Test with Simplified Queries: Try simplifying the calculated fields or using simpler SQL constructs to see if they work as expected. This can help isolate any complex logic causing issues.
- Check Dataset Permissions: Verify that the user or role accessing the dataset has the necessary permissions to view the calculated fields. Insufficient permissions may prevent the values from being displayed.
