A unique column in the Foundry system that utilizes function-backed technology to calculate the monthly usage of engines over a

Question

A unique column in the Foundry system that utilizes function-backed technology to calculate the monthly usage of engines over a

In my dataset of ‘Engine Hours’, I have the following information:

Engine#	Date Recorded	Hours
ABC123	Jan 21, 2024	9,171
ABC123	Dec 13, 2023	9,009
ABC123	Oct 6, 2023	8,936
XYZ456	Jan 8, 2024	5,543
XYZ456	Nov 1, 2023	4,998
XYZ456	Oct 10, 2023	4,002

In another set of data for ‘Engine’, I display the latest Engine Hours in a Workshop Object Table by linking it to the 'Engine Hours' objects with an aggregation on the property 'Maximum' to show the most recent recorded hours.

Engine#	Date Recorded	Latest Hours
ABC123	Jan 21, 2024	9,171
XYZ456	Jan 8, 2024	5,543

Now, I am looking to add a column that shows the average monthly usage over a rolling 3-month period. I believe this can be achieved using a Function-Backed Column, but I lack the knowledge of TypeScript to create it myself. I have tried searching for similar examples within Palantir Learning resources and online, but haven't found a solution yet.

Does anyone have a template or example code for a similar Function-Backed Column that I could use for this specific case?

Thank you!

javascript typescript palantir-foundry

Answer 1

Answer №1

To support a derived column in an Object Table within Workshop, you would typically require a Function.

Here is a demonstration of how this can be achieved by dividing the logic into two separate functions:

The first function operates on a set of objects and generates a mapping between each object and the calculated value (e.g., the average over the last 3 months).
The second function computes the desired value for a specific object.

There are several benefits to utilizing this approach:

You can utilize the second function to populate various widgets (such as a Metric Card) by simply passing an object and retrieving the corresponding value without duplicating the logic.
The parallelization of Function 1 using Promises/asynchronous computation enables efficient processing.

Limitations:

Standard enforced limits apply to any applied function, including constraints on memory load (maximum of 100k objects) and compute time (max of 30 seconds).

// Necessary imports...
/*
* 1/ This function returns a "FunctionsMap", acting as a map linking object instances
* with the display value in the derived column for each instance
*/
@Function()
public getDerivedColumn(myEngines: ObjectSet<Engine>): FunctionsMap<Engine, Double>{
    // Implementation details...
}

/* 2/ Function for calculating value for a single object */
@Function()
public async computeMetric(currentEngine : Engine): Promise<Double> {
    // Implementation details...
}

Please note that while this code snippet has not been tested extensively, it should closely align with your requirements.

Additional information on function-backed columns in Workshop

Answer 2

To support a derived column in an Object Table within Workshop, you would typically require a Function.

Here is a demonstration of how this can be achieved by dividing the logic into two separate functions:

The first function operates on a set of objects and generates a mapping between each object and the calculated value (e.g., the average over the last 3 months).
The second function computes the desired value for a specific object.

There are several benefits to utilizing this approach:

You can utilize the second function to populate various widgets (such as a Metric Card) by simply passing an object and retrieving the corresponding value without duplicating the logic.
The parallelization of Function 1 using Promises/asynchronous computation enables efficient processing.

Limitations:

Standard enforced limits apply to any applied function, including constraints on memory load (maximum of 100k objects) and compute time (max of 30 seconds).

// Necessary imports...
/*
* 1/ This function returns a "FunctionsMap", acting as a map linking object instances
* with the display value in the derived column for each instance
*/
@Function()
public getDerivedColumn(myEngines: ObjectSet<Engine>): FunctionsMap<Engine, Double>{
    // Implementation details...
}

/* 2/ Function for calculating value for a single object */
@Function()
public async computeMetric(currentEngine : Engine): Promise<Double> {
    // Implementation details...
}

Please note that while this code snippet has not been tested extensively, it should closely align with your requirements.

Additional information on function-backed columns in Workshop

Answer 3

Answer №2

If you're looking to utilize the pipeline builder tool for incorporating data into the Workshop module dashboard, it can be easily accomplished.

You'll come across the average functionality within the tool, requiring some basic mathematical operations in the pipeline builder to prepare the data accordingly.

If you require detailed guidance on navigating this process through the user interface, feel free to reach out. It's designed to simplify management and comprehension of tasks.

Answer 4

If you're looking to utilize the pipeline builder tool for incorporating data into the Workshop module dashboard, it can be easily accomplished.

You'll come across the average functionality within the tool, requiring some basic mathematical operations in the pipeline builder to prepare the data accordingly.

If you require detailed guidance on navigating this process through the user interface, feel free to reach out. It's designed to simplify management and comprehension of tasks.

A unique column in the Foundry system that utilizes function-backed technology to calculate the monthly usage of engines over a

Answer №1

Answer №2

Similar questions

Loading local JSON data using Select2 with multiple keys can greatly enhance the functionality

Using styled-components and typescript to override props

Tips for establishing communication between a server-side and client-side component in Next.js

Modify the color of every element by applying a CSS class

Encountering an issue when trying to upload numerous base64 images to Cloudinary through Node.js and receiving an error with code -4064, specifically 'ENAMETOOLONG'

What is the best way to ensure all requests have been completed before proceeding?

jQuery - Enhancing User Experience with Dynamic Screen Updates

Is there a way to alter the background color of a Material UI card when it is being hovered over

Here's a unique rewrite: "Learn how to manipulate the CSS class of a textarea element (specifically in NicEdit) by utilizing the addClass

Tips for showing more rows by clicking an icon within an Angular 2 table

Retrieving information from a JSON web service can easily be done using just JavaScript and jQuery

Looking to increase the resolution of a 512x512 heightmap array of pixels in a png image to 2017x2017 using JavaScript for implementation as a heightmap in Unreal Engine 4?

Display <div> exclusively when in @media print mode or when the user presses Ctrl+P

Using Parseint in a Vue.js method

passport.authenticate method fails due to empty username and password values

Angular 4 Web Application with Node-Red for Sending HTTP GET Requests

Exploring the option of eliminating the email field from the PHP redirect function and transforming it into a pop-up notification

Customizing ExtJS 4.1: Mastering field overrides

Dividing a string into an array and displaying it in a table using Laravel

Creating an Account with Firebase