ContributionsMost RecentMost LikesSolutionsRe: JSON Fetch > Iterate over JSON Records > Create RecordsHi Doug, Thanks for the quick reply! I changed the schema with your recommendation, but still getting 1 record created that is completely blank. Below is what I'm getting when running the pipeline. The pipeline is also going idle after a few seconds... ------------------------------ Addie Brunson ------------------------------ JSON Fetch > Iterate over JSON Records > Create RecordsI'm having issues getting a pipeline to add records for each JSON object. I think it has to do with the JSON schema example in theIterate over JSON recordsstep, but I've tried a few different options without success. Here's what I'm looking at: Below is an example of the data from a user data call. This has 2 employee objects (or arrays? I'm not sure...) I'd like to create a record foreachemployee,pulling their email address from the data into a field. When I enter the example below in the JSON Schema Sample and run the pipeline, I get only a record created for employee 1. I've tried altering the JSON schema sample to what's shown below. When I take this approach, I get a record created, but it is completely blank (no email). Any help would be much appreciated! ------------------------------ Addie Brunson ------------------------------ Re: Query Help Hi Paul, No. It updates once per month. Thanks! Query HelpHello, I have a table with the following fields: Program Name (Type: Text) Health Date (Type: Date) Health Color (Type: Text) I would like to add a field that would automatically return the health color from the previous month. The desired end result would look something like: I'm guessing this would be a query formula but so far I haven't had any luck. Any help is much appreciated! Thank you. ------------------------------ Addie Brunson ------------------------------ Filtering Summary ReportsHello! I have a table with the following fields: Name (text) Check-in Period (date) Pulse (Numeric) I would like to have a report that shows ONLY employees whose average pulse over the current month and previous 2 months is less than or equal to 3. Currently, I've set up a summary report (see Current Summary Report & Current Summary Report Settings in attachment) to show the average pulse for the current month and previous 2 months. I'm struggling to filter the summary report to only show records where the average pulse is less than or equal to 3 (see Current Summary Report - I would like Employee 4 to be excluded since their average is above 3). Using the normal filter options, if I set up an additional filter to include only records with a pulse of less than or equal to 3, it filters out the individual records so they aren't included in the summarized data. For example, in Drilldown Report into Employee Name 2, the record on 03-26-2022 with a pulse of 4 would be filtered out, which would then change the average on the summary report. Any help would be much appreciated! ------------------------------ Addie Brunson ------------------------------ Re: Calculating Employee Tenure Thank you! Is there an easy way to remove the days calculation from the result? And, is there a way to remove years if an employee has been here for less than a year? -- Addie Brunson,Operations Analyst Spotlight | www.spotlightar.com 913.375.0574 Re: Calculating Employee TenureSure. Assuming I'd be looking at the data today (3/16/22): Employee start date is 11/1/21, result would say 4 months. Employee start date is 7/1/19, result would say 2 years 8 months. ------------------------------ Addie Brunson ------------------------------ Calculating Employee TenureHello, I am needing to calculate employee tenure in years and months. I currently have a date field "Start Date" for the date of hire. Is there a formula to easily calculate this? Thank you in advance! ------------------------------ Addie Brunson ------------------------------