Lately, I’ve been tasked to build some new dashboards, getting my hands dirty so to speak. I thought I would share one of the use cases I’ve worked on as it involves SAQL and dates. It’s often something I get questions on, so I figured let me provide this example and hopefully, it may give ...
In CRMA we have the flexibility to build lots of different charts to analyze our KPIs. In this article, we’ll learn how to create a Pareto chart, but first of all: What is a Pareto chart? And why would I need this chart in my analysis? The Pareto chart (named after the Italian economist, Vilfredo ...
Some of my blogs are inspired by questions or use cases that I encounter when working with Tableau CRM. In the past month, I’ve had the same question around joining two datasets in a query; one dataset is grouped by two dimensions, but the other dataset is missing one of those dimensions, hence the question ...
In this part of the SAQL series, we are going to look at the rollup modifier, which is used to create total and subtotals in your query. Now as with the previous parts of this series, total and subtotals can also be achieved in the UI by using compare tables. Hence just because you need ...
If you have been following along in this blog series, I’m sure you are starting to see how powerful SAQL can be joining data as we see fit, but there is more to the story. You can create new derived fields that we already touched upon in part 5 of this blog series, but let’s ...
In the last blog of this SAQL series, we saw how powerful SAQL really can be by joining datasets together using the cogroup statement. But we are not stopping there, we can do more powerful stuff. Another way of joining different streams is with the union statement, so in this blog, we will uncover that ...
What we have covered so far in the SAQL series have been some basic features, however, it can be a lot more powerful. Let’s say you have two different datasets you want to use for a single query; it could be cases and opportunities for an account. Well, with SAQL we can leverage co-grouping to ...
By now we have covered most of the basics in a SAQL query, but there is one more thing that you will see a lot when you are working with SAQL and it is filters. So in this third part, we will look closer at filters. Pre-projection Filters When you apply a filter to a ...
Einstein Analytics dashboard pattern for dynamic Period over Period Analysis using a single date picker.
Highlights:
* Works with a single standard date widget
* Works with absolute dates
* Works with relative date
bonus
Allows switching between \"current period vs. prior period\" (example: Jan-Feb 2019 vs. Nov-Dec 2018) & \"current period vs same period prior year\" (example: Jan-Feb 2019 vs. Jan-Feb 2018)
In the first part of this blog series, I explained what is SAQL and the anatomy of SAQL. This will be the foundation for the rest of this series. The SAQL query we covered was simply, in fact, there was no reason to write that query in SAQL, which I also mentioned isn’t recommended for ...
