can I link 3 datasets in an analytics workbook?
# ask-stanley-ai
o
can I link 3 datasets in an analytics workbook?
c
AI generated answer (using internal Slack threads):
Yes, you can link 3 datasets in an Analytics Workbook. SuiteAnalytics allows you to access joins more than 2 levels, unlike Saved Searches. This functionality is particularly useful when you have multiple custom records that reference each other and you want to view their relationship in a single view. For example, if you have 3 custom records, let's call them 1, 2, and 3. If 2 is referenced on 1, and 3 is referenced on 2, you can use SuiteAnalytics to show 1, 2, and 3 as they relate to each other in a single view. Another example is if you wanted to run a report on sales orders, that have related invoices, and you want to show the related credit on those invoices. SuiteAnalytics allows you to do stuff like that. It's also worth noting that there are certain fields/tables that aren't available in Searches that are available in Analytics. That and the multi-joins are the main reasons to use them. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.820265174
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.812514126
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.810222507
Please provide your feedback on this answer.