Working with Conditional Expressions in Geocortex Reporting

Working with Conditional Expressions in Geocortex Reporting [Geocortex Tech Tip]

Darren Boss
Darren Boss
Software Developer
March 27, 2020

Working with Conditional Expressions in Geocortex Reporting [Geocortex Tech Tip]

Geocortex Reporting allows you to better understand and visualize critical relationships in your data through its highly-configurable and versatile reports.

One of the many different ways you can further enhance your reports are through the use of conditional expressions, which allow you to conditionally display a value or alter the appearance of your report based on criteria you specify in an expression.

In this Geocortex Tech Tip, we demonstrate some examples of how this is done.

Watch on YouTube.

Video Transcript

“Hi, my name is Darren and I am a developer on the products team. Today, we are going to take look at conditional expressions in Geocortex Reporting and how you can use them to modify your data, and enhance the appearance of your reports. Let’s take a look!

I have a fairly simple report here. I have the data source configured, which is a map service that has US census data about states and counties within those states, and I’m choosing to display county information, both the FIPS number and the population and median age.

For starters, I’ll just this go ahead and run this, and we can see what it looks like before we start modifying our report using conditional expressions. There we go, this is the information for the state of California; counties with associated data with each county.

We’re here to talk about conditional expressions but first, I’ll just review quickly what an expression is. An expression is a string or a recipe that gets parsed and processed into a value that can be displayed in the report. Expressions consist of field names, constant values like numbers, strings, booleans, they can also contain operators and functions.

So, conditional expressions involve one of these functions that I just mentioned, conditional expressions, in particular, make use of the ‘if’ function, so that can be used in a number of different ways.

For my first example, I’m going to demonstrate how the ‘if’ function can be used to modify the data we’re displaying for our population. So, I’m going to go ahead and select the text box that’s displaying my population value and then I’m going to click on that little ‘f’ in the corner here, look at my text expression. So, right now this is a very simple expression, showing the population of 2007 field. I’m going to delete that, I’m going to expand my functions down here, go to logical functions, just double click on this ‘if’. And so, the ‘if’ function consists of three parts. The first part of is a boolean expression, something that evaluates to true or false, the second value is going to be what we want to display if that condition evaluates to true, and then the third item in the function is what we want to display if the condition evaluates to false.

So, for this, I’m going to use our population 2007 field again. I’ll say if our population from 2007 was less than 10,000, the text that I want to display is ‘Low’. Then if that population happens to be above 10,000, we’re just going to display ‘High’. I’m going to click ‘OK’ there, save my report, and then run it again. We’ll see that my population column now displays these high and low values as compared to the actual numbers from before.

One very useful feature — I’m going to go back into my Expression Editor here — is I’m not restricted to just these two values, I can actually chain operators together. So, right now this expression says, my populations less than 10,000, let’s show a value of low or if it’s over, let’s display a value of high, but what if we want an intermediate value? What I can add at this point is I can add another check on my population, and say if my population is less than 50,000, let’s display a value of ‘Med’, otherwise we’re going to say ‘High’.

Ok, let’s save that, and run the report again. Now, we have low, medium and high values. You’re not limited to just those the three options – you can chain as many of these conditions together as you need to achieve your goal.

In addition to modifying your data, you can also modify the appearance of your report using conditional expressions.

For starters, I’m going to select this Median Age field, and then I’m going to select the Expression tab over here. We have a whole bunch of options available to us, we can set expressions for any of these properties, and thereby the modify the appearance of our report.

I’m going to say, let’s change the color of the text we displayed based on a condition. I’m going to change my foreground color, go down to my logical operators and add another ‘if’ condition.

If you’re not sure what all of the fields are that are available to you, you can go to the ‘Fields’ option here, and I can see, okay I want to work with my median age field. So, I’m going to say, if my Median Age is greater than 40, let’s change the color of our text or foreground color to green, otherwise, let’s leave that color as black. Say, ‘OK’ here, save my report, run it one more time. There we go!

We can see that I’ve changed the color, the foreground color, the color of our text to be green if the median age is over 40 years old. I’ve set that one expression for the appearance of my texts and I’m not restricted to just you know modifying one property, I can come in here, and let’s change something with a font. Let’s go ahead and create an expression that will make our font bold if it evaluates to true, otherwise we’ll leave the font as is or maybe we’ll make it bold. I’ll add the ‘if’ operator in there, again I’m working with my median age. This time, I’m going to save my median age as less than 40, I want bold to be true, otherwise, I want bold to be false.

You’ll notice that as I’m typing here, sometimes you’ll see a little red ‘X’ on the side over here. It’s just indicating that there’s a problem or issue with the expression that you’re currently typing. So, right now this expression is incomplete, and once I finish typing false, that validation warning goes away.

I click, ‘OK’ here, save my report, run it. For this report, I should see any ages below 40 as bold text, and ages above 40 in green.

So, this has just been a small sample of or small introduction into conditional expressions. I hope it’s been helpful and I encourage you to go into the Designer go to the Expressions tab and just look and see what options are available to you and see what kind of creative ways you can come up with to modify your data. Thank you for your time!”

Want to know more about Geocortex Reporting technology? Click the button below for product information, or to schedule a personal demonstration.

Discover Geocortex Reporting


Categories:
Archive
Open: 2020
2020
May 22, 2020

Launching a workflow in Geocortex Inline [Geocortex Tech Tip]

May 20, 2020

Geocortex Essentials 4.13: Additional development tools and external widget support let you customize your apps even further

May 15, 2020

Understanding points of interest and station locator [Geocortex Tech Tip]

May 8, 2020

Using the Inline Designer to build linear referencing views [Geocortex Tech Tip]

May 1, 2020

Understanding performance differences between Geocortex Workflow and the workflow capability in Geocortex Essentials [Geocortex Tech Tip]

April 24, 2020

Printing a vector tile layer in Geocortex Printing vs the Printing widget in Geocortex Essentials [Geocortex Tech Tip]

April 17, 2020

Producing layer reports in Geocortex Reporting vs the Reporting widget in Geocortex Essentials [Geocortex Tech Tip]

April 10, 2020

Comparing dynamic forms in Geocortex Workflow vs Geocortex Essentials [Geocortex Tech Tip]

April 7, 2020

Take control of your GIS with Geocortex Access Control [Webinar]

April 3, 2020

Performing field inspections with Geocortex Mobile (OOB Editing) [Geocortex Tech Tip]

March 27, 2020

Working with Conditional Expressions in Geocortex Reporting [Geocortex Tech Tip]

March 20, 2020

Export support and new third party map integration widgets [Geocortex Tech Tip]

March 13, 2020

Configure and Monitor a Web AppBuilder Web Application from Geocortex Analytics [Geocortex Tech Tip]

March 11, 2020

Geocortex Events and COVID-19/Coronavirus

March 6, 2020

Running a batch script from an alarm with Geocortex Analytics [Geocortex Tech Tip]

February 28, 2020

Understand how your users are engaging with the tools in your applications [Geocortex Tech Tip]

February 21, 2020

How to manage alarms in Geocortex Analytics [Geocortex Tech Tip]

Open: 2019
2019
December 18, 2019

Geocortex in 2019, and a glimpse of what's to come

December 5, 2019

Four key benefits to adopting a mobile GIS solution

November 29, 2019

Using Geocortex Mobile to collect survey data [Geocortex Tech Tip]

November 27, 2019

Dive into Geocortex Analytics [Webinar]

November 22, 2019

How to input parameters on prints [Geocortex Tech Tip]

November 15, 2019

How to include feature attachments in reports [Geocortex Tech Tip]

November 14, 2019

Understanding application management in the Designer [Geocortex Tech Tip]

November 14, 2019

How to reference symbology from web maps [Geocortex Tech Tip]

November 14, 2019

How Geocortex Mobile can integrate with other apps [Geocortex Tech Tip]

November 14, 2019

Implementing Arcade Expressions in Geocortex Essentials [Geocortex Tech Tip]

November 14, 2019

Customer Spotlight: Geocortex Mobile

November 14, 2019

How to Format Your Reports [Geocortex Tech Tip]

November 14, 2019

Showing an image in a form after a file picker [Geocortex Tech Tip]

November 14, 2019

Richard Wiegmann Joins VertiGIS as President and CEO

September 27, 2019

Understanding the toolbar in Geocortex Web [Geocortex Tech Tip]

September 20, 2019

Refining Results in Geocortex Web [Geocortex Tech Tip]

September 19, 2019

Charting data using Geocortex Reporting: Honing your charting skills

September 13, 2019

Utilizing the flexibility of layout in Geocortex Web [Geocortex Tech Tip]

September 6, 2019

Creating Geocortex Web applications that move seamlessly between 2D and 3D [Geocortex Tech Tip]

August 28, 2019

Geocortex adds support for Arcade scripting and ArcGIS Online smart mapping

August 23, 2019

How to create sections and groups for your reports [Geocortex Tech Tip]

August 16, 2019

Displaying SQL Server Data in Geocortex Workflow [Geocortex Tech Tip]

August 14, 2019

Customer Spotlight: Geocortex Essentials

August 8, 2019

City of Austin: Spreading floodplain awareness with Geocortex

August 1, 2019

Geocortex Essentials 4.12: Improved integration with ArcGIS® Online

July 25, 2019

Introduction to Geocortex Printing: Learn to build stunning print templates

July 17, 2019

Updates to the Geocortex Product Life Cycle

July 8, 2019

Extending Web AppBuilder for ArcGIS® with Geocortex Essentials [Webinar]

July 4, 2019

City of Bellingham: Using Geocortex to take the stress out of water shut-off

June 27, 2019

Geocortex at the 2019 Esri User Conference

June 14, 2019

Customer Spotlight: Geocortex Workflow

May 17, 2019

Important Notice - Outage Issues & New Support Cases

May 17, 2019

How to build a summary report with aggregations of feature data [Geocortex Tech Tip]

May 16, 2019

Technology Q&A: Geocortex Mobile

May 10, 2019

How to create print templates for Web AppBuilder for ArcGIS®[Geocortex Tech Tip]

May 8, 2019

Dive into Geocortex Printing [Webinar]

May 3, 2019

Using Geocortex Workflow and Geocortex Reporting to produce a multi-layer report [Geocortex Tech Tip]

May 1, 2019

Market-Leading GIS Software and Services Companies Join to Form VertiGIS

May 1, 2019

Introducing VertiGIS

April 18, 2019

Integrating Workflows into Geocortex Mobile [Geocortex Tech Tip]

April 17, 2019

Customer Spotlight: Geocortex Reporting

April 12, 2019

Using Geocortex Go to preview app configurations [Geocortex Tech Tip]

April 10, 2019

How to Address Complex Form Navigation Using Geocortex Workflow

April 5, 2019

Building native, offline IOS, Android and Windows apps with Geocortex Mobile Viewer [Geocortex Tech Tip]

April 3, 2019

Streamlining mobile operations with Geocortex Mobile Viewer [Webinar]

March 29, 2019

A better way to run geoprocessing tasks in Web AppBuilder for ArcGIS [Geocortex Tech Tip]

March 28, 2019

Extend the reach and capabilities of your applications with integrations [eBook]

March 22, 2019

Displaying data from SQL Database when you select features [Geocortex Tech Tip]

March 20, 2019

How Geocortex users are enriching the communities they serve

March 15, 2019

How to Configure a Geocortex Essentials layer report with Geocortex Reporting 5 [Geocortex Tech Tip]

March 14, 2019

Region of Waterloo: How GIS & Geocortex technology helped meet local Source Protection Plan requirements

March 6, 2019

Integrating Business Intelligence and Data Sources with Geocortex Essentials [Webinar]

March 1, 2019

How to quickly add attachments to new features when editing [Geocortex Tech Tip]

February 22, 2019

Generating a report with sub reports from external data sources [Geocortex Tech Tip]

February 20, 2019

Geocortex Essentials 4.11: Saving Time & Increasing Efficiency

February 15, 2019

Accessing Samples and Building your First Workflow [Geocortex Tech Tip]

February 12, 2019

Open Beta of Geocortex Printing 5 Has Begun

February 8, 2019

Different Ways of Creating Selections of Features in Geocortex Viewer for HTML 5 [Geocortex Tech Tip]

February 6, 2019

4 Best Practices to Follow When Using Geocortex Workflow 5

February 1, 2019

Creating a Report that Displays a Screenshot of the Map [Geocortex Tech Tip]

January 28, 2019

Diving Into Geocortex Reporting 5 [Geocortex Tech Tip]

January 24, 2019

How Geocortex is Advancing Water Management Solutions

January 16, 2019

Creating Custom User Experiences with Geocortex Workflow 5 [Webinar]

January 11, 2019

Showing the search results using the item picker in Geocortex Workflow 5 [Geocortex Tech Tip]

January 9, 2019

City of Troy: Using GIS and asset management technologies to manage legislative requirements

January 4, 2019

Using scripting to put attachments in reports in Geocortex Reporting 5 [Geocortex Tech Tip]

Open: 2018
2018
December 21, 2018

Integrating Pictometry, Bing and other 3rd party maps within your Geocortex applications

December 19, 2018

Recapping the Texas Geocortex Regional User Group

December 14, 2018

How to use Geocortex Workflow 5 to populate the Attribute Table in Web AppBuilder for ArcGIS [Geocortex Tech Tip]

December 12, 2018

Finding yourself: Using geolocation in mobile and web applications [Webinar]

December 7, 2018

Enabling real-time user-to-user map collaboration within Geocortex Essentials

December 5, 2018

Reflecting on 2018

November 30, 2018

Creating mailing labels with reports with Geocortex Reporting 5 [Geocortex Tech Tip]

November 29, 2018

Alberta Energy Regulator: Supporting safe and responsible energy resource operations

November 26, 2018

Important update for ArcGIS and Transport Layer Security (TLS) Protocol Support!

November 23, 2018

Using fine-grained security to control access to layers, features, attributes and application functionality [Geocortex Tech Tip]

November 21, 2018

Enhancing Web AppBuilder for ArcGIS® with Geocortex Reporting [Webinar]

November 16, 2018

Using Geocortex Workflow 5 to automatically display a form for editing layer attributes [Geocortex Tech Tip]

November 15, 2018

Geocortex Achieves Esri’s “Release Ready Specialty” Designation

November 14, 2018

Celebrating GIS Day with York Regional Police: How GIS Data Has Mitigated Risk & Increased Efficiency in Crime Prevention

November 9, 2018

How to access a SQL database from a workflow using Geocortex Workflow 5 [Geocortex Tech Tip]

November 2, 2018

How to send an email from a workflow using Geocortex Workflow 5 [Geocortex Tech Tip]

October 26, 2018

How to add and configure charts inside reports with Geocortex Reporting 5 [Geocortex Tech Tip]

October 24, 2018

Geocortex Water Webinar Series

October 19, 2018

Integrating Geocortex Essentials with ArcGIS Online and ArcGIS Enterprise portal [Geocortex Tech Tip]

October 17, 2018

Cross-Platform Development with Xamarin [Webinar]

October 12, 2018

City of Fort Collins: Dynamic flood maps for public awareness, and flood insurance rate saving

October 2, 2018

Technology Q&A: Geocortex Workflow 5 “Behind the Firewall”

June 27, 2018

Geocortex Essentials 4.10 is here!

June 12, 2018

Geocortex and the GDPR

June 6, 2018

Geocortex at the 2018 Esri User Conference

May 15, 2018

Technology Q&A: The evolution of Geocortex and Web AppBuilder for ArcGIS

April 25, 2018

How to manage data collected from Geocortex Workflow 5 forms [Geocortex Tech Tip]

April 18, 2018

Delivering accessible mapping applications for everyone [Geocortex Tech Tip]

April 11, 2018

How to search for data in a non-spatial database [Geocortex Tech Tip]

April 5, 2018

Configuring Geocortex Analytics to monitor a new Portal for ArcGIS instance [Geocortex Tech Tip]

March 27, 2018

Getting started with forms in Geocortex Workflow 5 [Geocortex Tech Tip]

March 21, 2018

Using Geocortex Workflow with Web AppBuilder for ArcGIS [Geocortex Tech Tip]

March 15, 2018

Understanding tool usage in your GIS applications [Geocortex Tech Tip]

March 7, 2018

Running Geocortex Essentials workflows from an identify operation [Geocortex Tech Tip]

March 2, 2018

GIS Health Assessment: A new way to think about your system

February 28, 2018

Using the in-app help system in Geocortex Workflow 5 [Geocortex Tech Tip]

February 21, 2018

How to configure a personalized dashboard in Geocortex Analytics [Geocortex Tech Tip]

January 25, 2018

GIS is shifting to SaaS, and it’s a win for everyone


Categories

Popular Tags
Accessibility Active Operating Picture ArcGIS ArcGIS Online customer spotlight Customer Story Data Models Energy Esri Geocortex Geocortex 5-Series Geocortex Analytics Geocortex Essentials Geocortex Inline geocortex integrations geocortex mobile Geocortex Mobile Viewer geocortex printing Geocortex Reporting Geocortex Reporting 5 geocortex tech tip Geocortex Tech Tips geocortex training Geocortex Viewer for HTML5 geocortex web Geocortex Web Viewer Geocortex Workflow Geocortex Workflow 5 GIS GIS Day GIS Health Integrations mobile gis Oil & Gas Pipelines Portal for ArcGIS SaaS Tech Tip Tech Tips Transportation vertigis Water Industry Web AppBuilder Web GIS Xamarin

Contributors