A shipping company created a dataset, "Book11," containing budget per region per month for the first six months of 2018. The dataset is shown in the graphic. Now, they want to create a lens showing the total budget for each region for each month. Every combination of region and month must be shown in the lens, even if there is no data. How can a Tableau CRM Consultant help this company build this lens?

A. Use a "Compare Table" and add a column leveraging the "Running Total" function.
B. Use a "Compare Table" and use the "Show summary" option.
C. Use a SAQL query leveraging the "fill" statement with a "partition" parameter.
D. Use a SAQL query to create fake rows for any data that is missing data from the dataset.

Suggest answer: C

Reference:

No comments:

Please share to make the community better.