Add Supporter Conditional with airSlate SignNow

Add supporter conditional

hi and welcome to another course in microStrategy's mobile app developer academy this course is entitled conditional formatting conditional formatting enables you to change how elements of your documents display depending on conditions you specify you can use conditional formatting to draw attention to important textual data or selectively hide images and make your documents more dynamic this video will present the steps necessary to apply conditional formatting to a document in a mobile app after watching this video you should be able to use conditional formatting to modify the display of text and images based on conditions you will need MicroStrategy web and an ipad with MicroStrategy mobile so let's begin here is what the sample document looks like before we add conditional formatting the user can filter the data by region and call center using selectors there's a lot of information in the key performance indicator panel and it would be beneficial if we could draw the users attention to the most important information and here's the same document after we've added conditional formatting so how do we accomplish this well I will begin with opening the document in MicroStrategy web in design mode I'll start by adding conditional formatting to dynamic text in a panel right-click the text point to conditional formatting and select advanced I'll choose which metric to use for the qualification and then enter the details for the qualification the conditional formatting will be applied to the text box when the percentage difference between revenue and target revenue is between negative 1 percent and 0 the next step is to define the formatting I want to apply to the text box when the qualification is met a negative percentage difference between actual and target revenue is bad so I want data in this range to display with a rag font color to do this I click format select red and click ok i also want to format the text to indicate when the percentage difference between actual and target revenue is within the expected range this means that I need to add another qualification to do this I click the new icon on the top left of the window and enter in the details this qualification will apply when the percentage difference is positive and within a small range of the projected value I will indicate this status using a simple black dot again i click formatting and this time i select replace data and select quick symbol there are a range of symbols to choose from and each can be given a color in size I have skipped ahead and added two more qualifications when the percentage difference between actual revenue and target revenue is less than negative 1 percent that's something that may require further investigation i'm going to add formatting that indicates exactly that i select the replaced data checkbox and this time use the replace text option i'll type investigate and use bold red text finally I want to use conditional formatting to indicate that a value greater than positive one percent is good this final condition corresponds to good news since this means that actual revenue has exceeded the target by more than one percent I'll format this data to display in blue you've seen me create conditional formatting for the dynamic text with a percentage difference between revenue and target revenue I have created very similar conditional formatting for the dynamic text in these two boxes the only difference is in the metric used for the qualifications here's what the conditional formatting looks like on the iPad you can see that it is much easier to understand the significance of the key performance indicators in addition to text boxes you can also apply conditional formatting to images this feature opens up a number of creative possibilities I'll demonstrate how you can use conditional formatting to create an interactive US map in this document users can click the name of a region to display the corresponding call centers on a map here's how you can create the effect in MicroStrategy web in design mode the panel staff that contains the US map is targeted by the region selector this enables you to add conditional formatting to the images and text based on the region attribute the image we're using for the US map is cleverly designed let's take a look as you can see the US map image contains gray bubbles corresponding to the positions of each call center we've placed an image of an illuminated green light on top of each of the gray bubbles by selectively showing or hiding each of the lights we create the effect of turning lights on or off depending on the region the user selects to add conditional formatting to an image right click it point a conditional formatting and select advanced add formatting based on the selected region not containing the call center I'm choosing not in list because I want to hide the light bulb when the northwest region is not selected then I click formatting and select hide image now I'll hide the text box used to label the call center to use conditional formatting to high text click formatting select replace data and use the height option now I'll repeat the process for every other light bulb and call center label for example I'll apply conditional formatting to the Salt Lake City label in order to hide the text when Southwest is not the selected region conditional formatting can also be useful when you're dealing with missing or incomplete data by default null values don't display in documents for example suppose there is no unit soul data for Seattle as you can see there's just an empty space where we would expect a metric value sometimes an empty space is fine but you may want to add more formatting to indicate that data is missing in MicroStrategy web in design mode I'll right click the text pointer conditional formatting and select advanced I'll add a new qualification and for the condition select is now I will replace null values with the words no data and use a brown italic font style now here's the result on the iPad so far I've been demonstrating using advanced conditional formatting editor there is another tool the visual conditional formatting editor that can be more convenient when you are applying formatting based on simple conditions in the visual editor you can drag the handles to specify the ranges to which you want to apply conditional formatting you can mouse over the line to display options for adding editing and deleting formatting rules however for more complicated conditional formatting you will need to use the advanced editor and that's a wrap for this MicroStrategy app developer Academy course on conditional formats you