If the string contains the word that we have specified, the MID function will return the first word after the specified word. So back to the beginning, the IF statement. With the addition -1 we are cutting off the blank behind the searched word. The third FIND statement is searching through the remaining string ( the text after the specified word and the blank after it ) for next blank which is actually the end of the word after the specified word. This is where we use the second FIND, to find the position of the first character of the specified word plus the whole length of it, and plus 2 which means the blank right to it. By using the MID function, we are able to extract two positions from the specified word, starting from right to left. We search for the specified word with the first FIND statement. Now, let's see how to use this medium effectively in our Tableau reports.įirst of all, we use the IF clause to check if the certain string contains the word that we have specified, which is the in our case. So, we are convinced that colors are an effective medium to communicate your message and draw the attention of the users to the areas that are important. They communicate your analysis with the user effectively and make your report look appealing at the same time. You will be evaluated on such concepts in the Tableau Desktop Certified Associate Certification Exam. Using colors in your reports too can have multiple benefits. The use of colors has made the same task so easy. Imagine, how difficult it would be for people to comprehend the words while riding their vehicles. This is the reason you have Red, Green, and Orange colors on Traffic Signals instead of words like 'Go', 'Stop' or 'About to Stop'. The popularity of using colors is based on the fact that the human brain processes image 60,000 times faster than text, and 90 percent of information transmitted to the brain is visual. Just like our lives, we want our reports also to be colorful.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |