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