Practical usage of SELF operator in Web Intelligence
Let’s check some scenarios where we can use SELF operator
with Previous function.
- Example 1. If we want to populate a specific sequence or series
We require to start with 3 and continue the series with multiples of 3.
=3 + Previous(Self)
We can use any calculation such as =3 +1.5* Previous(Self).
- Example 2. Showing concatenated values
=[City]+", "+Previous(Self)
A slight change in arrangement- reset on Country name.
=[City]+",
"+Previous(Self;([Country]))
- Example 3. Now, consider a business requisite.
Issue here is absence of Target values for each date. Since for few dates, target value is not present, we could not compare Sales value and suggest a color-code for those dates.
Business informs that when we do not have Target for any
Date, pick the last available target.
So, Target for 9/17/15 will be 75 for USA.
Here SELF operator becomes helpful to pull targets from
previous values.
We are adding a updated target column with formula as:
=If IsNull([Target]) Then Previous(Self;([Country])) Else
[Target]
If target is null for a specific date, it will go to previous dates and pull last available target value.
(In this case, we have sorted Date in ascending order.)
Now we we compare Sales with updated target, everything looks good as expected.
(for this example to work fine, first row should have a target value that will be pulled down.)
Let us know how you are using SELF operator.
very informative post. I will use the suggestions discussing here for optimizing my new blog site.This post will be very helpful for the begaineer SEO worker who are new in this field.
ReplyDeleteKeep posting this type of helpful post.
With best wishes.Mixed In Key 7.0.181.0
"Thanks a lot very much for the high quality and results-oriented help. I won’t think twice to endorse your blog post to anybody who wants and needs support about this area.
ReplyDelete"
Mobile phone Battery replacement | Mobile phone unlocking service | 100% genuine mobile parts | Mobile service center in chennai | Mobile service center in chennai | Mobile phone glass replacement