How can an Einstein Consultant help this company build this lens?

A shipping company created a dataset. "Bookll," containing budget per region per month for the first sixmonths 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 an Einstein Consultant help this company build this lens?
A . Use a SAQL query leveraging the "fill" statement with a "partition" parameter.
B . Use a SAQL query to create fake rows for any data that is missing data from the dataset.
C . Use a "Compare Table" and use the "Show summary" option.
D . Use a "Compare Table" and add a column leveraging the "Running Total" function.

Answer: D

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments