Unable to Create Water Strike Tables in Template Studio


 Product(s):Keynetix
 Version(s):1.0
 Area:Assist

Unable to Create Water Strike Tables in Template Studio

Issue Summary

If your find your having trouble setting up a waterstrike table in Template Studio please download the attached example and review it in Template Studio.

/cfs-file/__key/communityserver-wikis-components-files/00-00-00-01-05/0474.MissingImage.png

Resolution

Once you open the example go to "Table Columns" from the ribbon, there you will see the columns and how they are setup.

The way its setup is that it uses, firstly the "Water Strike - General" table to bring that data back for columns;

The "Time Elapsed" and the "Rose to" columns are pulled through from the "Water Strike - Details" table using expressions. These are;

fixed(numberordefault(max([Aggregate.WaterStrikeDetails.TimeElapsed]), 0), 0, false)

fixed(numberordefault(min([Aggregate.WaterStrikeDetails.DepthWaterValue]), 0), 2, false)