GSA 5.2.7. Pro Comparasion and presentation of several Date - Fields

[Björn Schaefer]

Hi everybody

I'd like to generate an analytic map, showing different states from Objects: There is a datasource, containing 5 columns, each showing a date, some rows / cells are empty.


the workflow runs from left Column to the right one, so KdGespraech ist the first step, HAvollfertigAm the last one.

The analytic map should show only one geometry (with different Style-Options like from red to green points)

Is there any simple way to create something like that?

thanks in advance!

 

[Frank Pistorius]

Hi Björn,

This can indeed be done by introducing an additional field on your business collection that represents the active stage.

I've set up an excel sheet with similar information as you have.



In this case, I've added additional lat/lon information to be able to place the elements on the map later on.
In your situation, I presume the location of the data comes from somewhere else.

I've used this source collection (sheet) in a Stages business collection and instead of picking up the lat/lon information from the sheet, I've created a true location field using the Point() expression. With the data being in WGS84, I've indicated the CS to be 4326.



This is basically a simple starting point.

I've left this collection as is and created another collection (Stages Enhanced) to show the expression to use to determine the active stage.



With this expression in place, the data looks as is shown below:



Here we can see that the correct active stage is determined. With the active stage known, we can now use it to set up a style dependency.



In the style designer, I've set up a qualitative dependency on the Active Stage field as shown below.



Rendering the data shows the styles dependent on the active stage:



In case you want to do use this in Analysis, I would suggest to still create the additional Active Stage field at the business level.
By making the additional information available early on, it is available in more places as is shown here.

Hopefully, this helps you further in setting up the Active Stage for your project.
Attached, you'll find a self-contained project used in the above example.

Regards,

Frank

 

[Björn Schaefer]

Hi Frank

many many thanks for this description! You're right, a position is given, but not included within the snapshot shown above.
Your idea to use the "unset" validator (!=null) is the jumping point, 'cause I thougt about comparing date formats (older / younger than), but this would make it much more complex.

Have a great weekend!