Request: I would like the ability to concatenate fields in Spectrum TC1.
Example: I want to create a custom field that concatenates the job code and the job description. (Example: "3655 Piper Creek") I don't see CONCATENATE in the Functions box of the Calculated Measures window.
Reason: The reason for this request is that I want to create pivot tables off of exported TC1 data sets. The pivot table filter is based on job number and job description. I want my users to be able to search on either the number or the name from the same list in the pivot table filter.
Sharon Williams
| Company | Hoopaugh Grading Company |
| I need it... | 3 months |
Dear Viewpoint Suggestion Box contributor;
We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs.
Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.
© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.
Good news - we are adding this field to be available natively very soon, along with a couple other common "Field - Description" concatenated values.
To answer your other question, even if a DAX function is not listed in the list, you can still use it - we just provided the list of the most commonly used DAX functions. I will note here, CONCATENATE will not achieve the result you're looking for with a calculated measure. Calculated measures are meant for aggregated values (i.e. value calculated across multiple values). A concatenated field in this example, is a calculated COLUMN (a newly appended column that is evaluated at a row by row context). Measures don't get evaluated row by row, therefore you wouldn't get the result you're looking for.
All that said, be on the lookout for the new additional fields with Job - Description as a standard field!