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. ...
Sometimes you have a really great idea for a chart. You know exactly what you want, you have the calculations ready only to realize that the specific chart in mind does not 100% support what you want to do. It’s a typical use case that pops up on a regular basis. A few weeks ago ...
In the past 8 blogs of this blog series, we have covered a lot of ground. We started out looking at the anatomy of a binding followed by data serialization examples and finally data manipulation. In this blog, there will not be an introduction to a new concept. While writing these blogs I have completed ...
This blog series has almost come to an end. From part 1 of this blog series I have tried to demystify the binding syntax and come with different examples of how to use data selection and data serialization, and I hope bindings have become a little more approachable than before. But there is another layer ...