The client is trying to create a SAQL query to predict sales in each sales region. They cannot get the query to return any results, but have identified that the enror is in the timeseries statement. They have asked a Tableau CRM Consultant to review the following query and fix any errors. q = load "sales"; q = group q by ('Date_Year', 'Date_Month', 'Region'); q = foreach q generate 'Date_Year', 'Date_Month', 'Region', sum('Sales') as 'sum_Sales'; q = timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=('Date_Year', 'Date_Month', "Y-M"), partition='Region'); q = foreach q generate 'Date_Year' + "~~~" + 'Date_Month' as 'Date_Year~~~Date_Month', 'Region', coalesce('sum_Sales', 'Forecasted_Sales') as 'Sales'; q = order q by ('Date_Year~~~Date_Month' asc, 'type' asc); q = limit q 2000;
Which timeseries statement will fix the query?

A. q = timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=('Date_Year', 'Date_Quarter', "Y-Q"), partition='Region', ignoreLast=true);

B. q = timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (length=12, dateCols=('Date_Year', 'Date_Month', "Y-M"), partition ='Region');

C. q = timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=('Date_Year', 'Date_Quarter', "Y-Q"), partition ="Region');

D. q = timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=('Date_Year', 'Date_Quarter', "Y-Q"), partition ='Region', seasonality=4);








 

Suggested Answer: C

Community Answer: B

Reference:
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_statement_timeseries.htm

 

This question is in Certified Tableau CRM and Einstein Discovery Consultant Exam
For getting Salesforce Certified Tableau CRM and Einstein Discovery Consultant















Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Salesforce. 
Trademarks, certification & product names are used for reference only and belong to Salesforce.
The website does not contain actual questions and answers from Salesforce's Certification Exams.