It sounds complicated, so we’ll take this slow.įirst, let’s create the SAQL step that will display the results of our query on a compare table. We’re going to create a hidden SAQL step to inject new SAQL code into our query used to power the table. To dynamically change the columns displayed, we’re going to something that some of you information security engineers will notice right away. We can do that by hitting the arrow on the side of the measure and clicking “hide”.Īs we can see, the calculations are working and the columns are hidden! Wonderful! Now, let’s try something a little more complex, changing what columns are displayed dynamically. ![]() Now let’s hide each of these columns while keeping the results shown. ![]() The following screenshot should give a good example of what we are doing.Īs you can see, we created a new column using the formula B+C+D+E. Let’s say that we have 5 measures, 4 of which need to be added together, but we only want to see the result. This is already available within Einstein. However, just because they are hidden, doesn’t mean they aren’t useful, as they can still be used in calculations. What this means is that the columns are hidden, and will never be visible to the user under any circumstance (unless it is edited of course). Let me explain briefly what I mean by a statically hidden column. I would like to take you on a tour of Einstein’s column hiding and finish off with an approach to dynamically change the columns displayed on your tables! Hiding Columns Statically On the other hand, you may have a large amount of data that you would like to show, and it would be nice to auto-hide columns given certain conditions (perhaps every value is 0 for example). You’ll be pleased to know that we can statically hide those columns. If you have ever needed to create a table in Einstein, you’ll know that there are times that you have to do a calculation but only want to see a result.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |