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 ...
A little more than a year ago I sat out to demystify bindings (or interactions as they are being called from Spring 20). I wrote a blog series covering data selection, data serialization, and data manipulation functions. It turned out to be quite a few blogs and quite a few bindings as well. I figured ...
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 ...
So I decided to fire up my old computer with a very old version of Adobe InDesign so I could go back in time and create an infographic answering the question “Are you ready to build your dashboard?”. If the answer was “No” to any of the questions I would recommend checking out the Einstein ...
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 ...