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)
As you may have figured out Einstein Analytics does not support multi-currency out of the box. If you are an organization that has enabled multi-currency in Salesforce then I am sure you are likely to want to see this in Einstein Analytics. As I said it’s not supported out of the box (at least not ...
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 ...
When we create dashboards in Einstein Analytics most of us rely on the UI. In the dashboard editor, we click “New Step” select our dataset, define the measure and a grouping whereafter we add it to the dashboard. In other words, with point and click, we can create a great dashboard that gives insight into the data. ...
