I’ve heard more than once than bindings can be hard and confusing. And if I didn’t believe that, then I only have to look at the most viewed blogs I’ve written and my demystifying binding blog series is by far the winner. In the Spring 20 release, it has become a little bit easier to ...
In Einstein Analytics we build our dashboards with datasets that we have constructed and run in the Data Manager. We do this because we want to denormalize our data to improve the performance of our queries. This does, of course, come with a price that we do not have real-time data, though we can schedule ...
Not long ago I took you through co-grouping in my SAQL series, while SAQL is good to know especially when you want to do really advanced stuff, there is no reason why it has to be complicated and in Spring 20 it isn’t (I guess Safe Habour still applies). With clicks instead of manually writing ...
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 ...
In the latest release, Winter 20, we got a lot of help in creating static steps – or as we will be calling them from now on, custom queries – but it can perhaps be a little hard to navigate how it works. So let’s have a look at these custom queries. First of all, ...
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 Winter 19 I did a two-part blog series on the (at that time) new SAQL timeseries statement. Yesterday I got an email requesting a 3rd part to the blog series looking at what you can do with timeseries directly in the UI, since this has been enabled after the original blogs were written. I ...
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 ...