Stack Overflow
Stack Overflow

Questions tagged [foundry-contour]

Questions related to development using Palantir Foundry's Contour application are appropriate to use here.

Contour is the point-and-click data analysis tool that allows you to quickly access datasets, conduct common analytical and logical operations in sequence to explore your data, debug data quality, cleanse and transform your data, and create reports to share your findings with others.

31 questions
4
votes
2 answers

How to do a recursive self-join in Foundry Contour?

I have a dataset which represents objects in a hierarchy (there are no cycles). I want to analyse it in Contour and figure out for each object the list of top-level related objects. Say, my object A depends on objects B and C. Object C in turn…
Aron
  • 63
  • 3
3
votes
2 answers

Fill gaps in preceeding rows

I'm working with the expression builder of Palantir Contour. The following table is given, and I need to fill the gaps in the counter column. Problem: The rows before the first value shall be filled with first counter…
Daniel
  • 59
  • 4
2
votes
2 answers

How do I insert free text/arrows into a bar chart in Contour to identify specific events that happened on a specific date?

I have a bar chart with exact dates over several years (ex: January 1st, 2016 to February 30th, 2019) on the x-axis and the number of events per day on the y-axis (ex: number of gatherings). On this bar chart, I am trying to also indicate certain…
goldenrat
  • 25
  • 4
2
votes
1 answer

Is there a way to create dynamic parameter?

I have filter for my dataset: Keep rows where date is on or after $filter_date Can I set parameter $filter_date to be 60 days (or 8 weeks or 2 months) away from today?
Jonas Reklaitis
  • 107
  • 6
2
votes
1 answer

In Foundry Contour, How do I filter by multiple terms?

Background I'm working on one of the tutorial exercises "Bootcamp, Day 1" The Problem Specifically, the problem says Filter this Flights path to only: Flights between Delta Airlines hubs (ATL, JFK, LGA, BOS, DTW, MSP, SLC, SEA, LAX) I know in SQL…
Travis Heeter
  • 13,002
  • 13
  • 87
  • 129
2
votes
1 answer

Snapshotting of Contour results in Palantir Foundry

I'm preparing a Data quality Report based on couple Contour analyses and would like to do a daily snapshots of the reported incorrect records. Then I want to show these daily numbers as another report in the same dashboard to see the progress on the…
Hrusilov
  • 654
  • 5
  • 9
1
vote
1 answer

Create a table with a unique id and a set of distinct values in Contour

I know how to do this with a data transformation. Now, suppose someone without a technical background needs to create a table with two columns: id --> unique_id vendor --> set of distinct values from a column that is included in the original…
Sherar MDP
  • 241
  • 1
  • 5
1
vote
1 answer

Filtering on Range of Dates contour

My data is as following: Date_Column ------------------------------- Aug 29, 2022 1:23:41 PM +02:00 Sep 25, 2022 6:21:56 PM +02:00 ------------------------------- Goal is to have a filter in contour dashboard where a user can filter data as shown…
Bella_18
  • 624
  • 1
  • 14
1
vote
2 answers

Persisting values

I am working on a project where I have to save some values that are being entered by users. Is that possible? How/Where can I do that? I have been searching on google and have not found anything relevant.
Luis Garcia
  • 1,311
  • 6
  • 19
  • 37
1
vote
0 answers

Contour: Saving dataset with older version

I am doing analysis in Contour using the older version of the data. Now, I want to save the result as dataset but saving data with "Save as dataset" button saves latest version of the data. Please suggest how I save the result with older version.
Shama Bansal
  • 11
  • 1
1
vote
0 answers

How to transform palantir foundry struct values to columns and its value

input column values in below format { "actualDuration": null, "actualCloseDate": 1.25, "actualDoneDate": null } output expected column name-actualDuration column name- actualCloseDate column name-actualDoneDate null …
Mohan Rao
  • 11
  • 1
1
vote
1 answer

How can I get the minimum value of multiple columns in contour?

Context: I have a dataset with multiple numeric columns, which I am analysing in Contour. During one step of my analysis I want to find the minimum value of three different columns for every row. Question: Is there an expression function in Contour…
mpSchrader
  • 902
  • 3
  • 20
1
vote
1 answer

In Foundry Contour, how can I analyze a prior version of a dataset?

I'm using Foundry Contour and need to view a prior version of a dataset at a certain point in its history. How can this be done from within Contour?
Adil B
  • 14,635
  • 11
  • 60
  • 78
1
vote
1 answer

How can I convert a Unix timestamp to a date in Foundry Contour?

The Foundry Contour table and column editors make it easy to parse a string containing some combination of year, month, and day as a date, but I haven't been able to figure out how to convert a Long representing a Unix timestamp into a date. Is…
Adil B
  • 14,635
  • 11
  • 60
  • 78
1
vote
1 answer

In Contour, how do I filter down to the top N by values in a group?

In an analysis where each row contains e.g. a flight number, I'd like to filter down my active dataset to keep only the three most-delayed flight numbers for each carrier. How do I accomplish this in Contour?
Adil B
  • 14,635
  • 11
  • 60
  • 78
1
2 3