Hello, I have a question about general workflow and data structuring for my use case. Let me go into a bit of detail: We are a fitness business that has customers who check in using passes or memberships. We are trying to answer various questions about our customers using data collected from our P…

[image] B_Burgess: sum(ifelse({transactionStatus}=“success”,transactionAmount,0),[{customerID},{passID},{membershipID},{checkinID}]) Do you have a transactionID in your dataset? The calculated field you need in this example should be something like this: sum(min({transactionAmount}, [{transa…

Best practices for working with large, disparate datasets?

Q&A

David_Wong July 10, 2025, 6:34am 4

Hi @B_Burgess,

Do you have a one-to-many relationship between the 2 tables that you’re joining? That would inflate your values.

Take a look at use case #2 in this article. It’s about using LAC-A functions to deduplicate data.

Topic		Replies	Views
Does quicksight support relationships between datasets? Or is it going to? Q&A data-source , quicksight , dataset , Business-Intelligence-Engineer	4	653	January 19, 2024
Create a calculated field using fields from different datasets Q&A calculations	1	3572	December 13, 2022
2 Fact tables in one dataset Q&A error , data-preparation , how-to	15	1823	September 11, 2023
Can i combine calculated fields from different datasets in a table Q&A data-source , export , Business-Intelligence-Engineer	5	183	January 19, 2025
How to join data with different date granularities Q&A how-to	14	950	September 14, 2023

Best practices for working with large, disparate datasets?

Related topics