Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Dataset having single record but when added to dataflow shows inflated dollar value
Rupak C
Rank 3 - Community Apprentice
Has anyone faced this issue ?
We have data sets (Mode-Live) using LSQL and that does not have any duplicates, in this example we specifically added more filters to deal with one single record from the data set as source.
It has $8273
While adding the dataset to the dataflow, this also shows one record but with inflated value on the $ column - $256498.23 in this case, almost 30 times.
We added Group By and DISTINCT in the Dataset LSQL to try fix it, but still shows wrong inflated value.
Tagged:
1
Best Answer
-
Hi @Rupak C
did you applied any aggregation rule on that column , can you check and see if its fixes your issue.
Regards,
Arjun
0
