Hi all,
I noticed that within a Data Label Object, you can select the description (from the picklist) as a header. Is there a way to use that value to write expressions?
For example, my goal is to have an automatic legend for each borehole log that detects sample types used in that borehole
This could logically be created by using the following formulas
1st column cells
joinDistinct([AggregateAll.SampleInformation.Type], '', ' = \n')
2nd column cells
joinDistinct([AggregateAll.SampleInformation.Type - Description], '', '\n')
The issue is that [SampleInformation.Type - Description] is not the proper syntax to reference the picklist description. Does anyone know the syntax?
Thanks
---Edit----
I created another header within the Group SampleInformation, named TypeDescription with a calculation expression that prints the Description I need. This technically solves the problem, but I am still interested in answering the question above as it would have saved some time/work. This secondary header will also need to be updated with a new description if a new sample type starts getting used, something that I know I'll forget to do until I notice the error on a borehole log.
Hi Josheph & Fahimeh,
I know this is an older post, but a bit of an update/clarification on this... There are some ways to pull out the description for a picklist field within an expression...
In Template Studio, you can use the syntax [Group.Header.Description] to pull out the descriptions for a picklist field.
However, that syntax is not supported in an "Aggregate" expression similar to those in Joseph's original post.
For example...
This would work:
[SampleInformation.Type.Description]
This would not work:
joinDistinct([Aggregate.SampleInformation.Type.Description],'','/')
Please also note that the [Group.Header.Description] syntax is only supported in Template Studio, and wouldn't work, for example, in a calculation within Professional. And there might be certain cases for use in Template Studio where the syntax doesn't work, such as within Tables or in Aggregate expressions (as noted above).