Pigment Community | Community

Explore the Community

Recently Active
Help Others
Categories

Looking to make a SWITCH?? Hiring a Full Time Pigment Solution Architect in NYC for Gusto

https://boards.greenhouse.io/gusto/jobs/6286911We have been customers for 1+ year and have already done the implementation. We love the tool a lot! We have a lot of net new builds and enhancements we want to do, so plenty of interesting problems to tackle. Gusto is $10b private SaaS company on the path to IPO, so a very exciting place to be and this role will directly report to me in Finance.Additional details:NYC based → we have most of the team there, so would like someone 3 days in office. We have relocation benefits. Level → flexible based on experience Visa Sponsorships → TBD, if we find a great candidate, we might sponsorApply on the link above AND directly email me at rohit.divate@gusto.com Thanks!

4 hours ago

OlaSeasoned Pigmenteer

Questions & Conversations

Link to a prefiltered board

When you apply a filter to a board you can see that the url is updated to include the current filter. The problem is just that the url only includes a GUID. Is there any way to find these guids in Pigment? For example when filtering on a specific employee in my employee dimension I can see that []=df7ce50d-304b-472e-a8e0-f448d960e8de is added to the url, and I would expect that each employee is related to a unique guid, so question is just how to get from dimension value to a guid. My use case is that I am having a grid view with a list of employees. For each employee I would like to link to another board with details about each employee and I would like this board to automatically be prefiltered based on which row I clicked on the first board.

11 hours ago

Sharon ConroyCommunity Manager

Security & Permissions

Troubleshoot Access Rights

Access issues can be frustrating, but resolving them doesn't have to be complicated. Here are some quick, actionable steps to help you get started troubleshooting access rights for Members in your Pigment Workspace.This article is aimed at Security Admins account types (or higher) tasked with resolving Members’ access rights issues.Members Can’t Edit a Cell Impersonate the MemberMembers Can’t Edit a CellThere are several reasons why a Member may encounter the error message: “You are not allowed to edit this cell.”Does the non-editable cell contain calculations, or contain overridden formulas? If so, manual inputs and edits cannot be performed. Use the cell status indicators to quickly identify and highlight cells that accept direct user input. For more information, see Use Cell Status Indicators for Better Grid Interaction. Does the Member have appropriate write access to that Metric they are trying to edit? To check a Member’s access rights in a Block: 1. Open the Block settin

240

1 day ago

A_GarneriSeasoned Pigmenteer

Questions & Conversations

How "RANK" (Sequential), ranks?

Hello Pigment,I would like to ask for your help regarding the RANK function, as I don’t fully understand the logic behind the ordering of its rank.Initially, I thought it considered the order of the list used as a dimension; that is, if my first 5 values to rank are equal, my rank 1 would be the first item in the list. However, this doesn’t always work that way. Here’s an example: Ideally, I want to create something like "ISFIRSTOCCURRENCE" that allows me to identify the first value created (like in Anaplan). My initial approach was essentially that: if my rank value is 1, then that is my first occurrence. However, I can’t achieve this correctly.What is the logic behind using "Sequential" as argument then? How does it behave? Or how does it find the values to rank? Do they rely on the ID behind the list items when the ranking attributes are the same?I found a post where they created a list of values to rank and used BY FIRSTOCCURRENCE, but that would require creating the list every ti

2 days ago

CalvinNewly Minted Pigmenteer

Questions & Conversations

Successful Data Import Notification for Multiple Selected Users

I’m wondering if it’s possible to send out a notification to multiple users when a successful data import has been completed? Ideally by e-mail or through Slack. In my experience so far only the user that initiated the data import receives the notification.

2 days ago

RoryCCommunity Manager

Pigment AI

Configure your Workspace for the Data Assistant

Workspace administrators should select which Metrics are accessible by Pigment AI, configure Block settings and write predefined ‘suggested questions’.Select your Metrics Add AI Descriptions to Metrics Prepare your Workspace Create Suggested Questions Learn More Select your MetricsThe Data Assistant only reads the Metrics you specify. It is essential that you configure your Workspace based on the below guidance.To select which Metrics are accessible by the Data Assistant, you first need to allow bulk editing of Metrics: Go to your Workspace and select Settings in the sidebar. Select Advanced features under Account Settings. Toggle Edit Metric structure in bulk to On. Then select which Metrics you want AI to access, for all relevant Applications. Note: this requires Configure Blocks permission: In your Application, open the Blocks dropdown in the sidebar, and select All Blocks. Select the Metrics tab. Select the checkboxes by the Metrics you want the Data Assistant to access. F

2381

2 days ago

nancySeasoned Pigmenteer

Questions & Conversations

Maximum cardinality exceeded error

Hi Team, Could you please explain me about the error “Maximum Cardinality Exceed” and how can we resolve it? thank you all in advance

6 days ago

danishnoorani1Newly Minted Pigmenteer

Questions & Conversations

Pro Training: Workforce Planning EE_Load_HRIS Date configuration

The hire date for EE00001 is 10/01/2022, but when I apply the formula, it shows as January 2023. Am I missing something?EE_Load_HRIS:

9 days ago

OlaSeasoned Pigmenteer

Questions & Conversations

Trigger import through API without sending data

Is it possible to trigger an import from Netsuite, Amazon S3 or Salesforce using Pigment’s API?So in this case we don’t want to send the data in the request body, we just like to trigger an existing import using the API instead of having the import to run on a schedule. Just want to confirm if this is supported or not, can’t really tell by reading the documentation here:

9 days ago

CindyNewly Minted Pigmenteer

Questions & Conversations

Create a Metric off Transaction Table to sum by period but filter by load date

Hello. I have imported a transaction list into Pigment that has two date dimensions. One is “Month” and is = to an accounting period. The second date dimension is the “Load Date” added automatically during the import. Each month, I will append to the data list so at the end, this list could have GL data by period for each load month. I am able to sum the data by period OR by load month but I’m not able to say which load I want to use. My current formula is like this:'02. Test Pivoted Push'.Amount[BY SUM: '02. Test Pivoted Push'.Department, '02. Test Pivoted Push'.'GL Account', '02. Test Pivoted Push'.Month, '02. Test Pivoted Push'.Subsidiary, '02. Test Pivoted Push'.Vendor]I want to add in a condition where the results will be based on which load month is selected (something like ]'02. Test Pivoted Push'.'Load Date'= Set_Last_Opex_Push_Month] where ‘Set_Last_Opex_Push_Month’ will be determined by me.

10 days ago

OlaSeasoned Pigmenteer

Questions & Conversations

Link to a prefiltered board

11 hours ago

A_GarneriSeasoned Pigmenteer

Questions & Conversations

How "RANK" (Sequential), ranks?

2 days ago

CalvinNewly Minted Pigmenteer

Questions & Conversations

Successful Data Import Notification for Multiple Selected Users

2 days ago

danishnoorani1Newly Minted Pigmenteer

Questions & Conversations

Pro Training: Workforce Planning EE_Load_HRIS Date configuration

The hire date for EE00001 is 10/01/2022, but when I apply the formula, it shows as January 2023. Am I missing something?EE_Load_HRIS:

9 days ago

OlaSeasoned Pigmenteer

Questions & Conversations

Trigger import through API without sending data

9 days ago

VA NguyenNewly Minted Pigmenteer

Questions & Conversations

Formula Playground needs to be more intuitive

We had to create a workforce roster of all employees with on target cash (or OTE) in local and USD and it was very challenging to do this. Internally, on our team, we tried to troubleshoot it ourselves and spent a few hours with no success. Then we engaged our solutions consultant to do this and it took him 25 minutes to go through the spiderweb of how to take local currency multiplied by current fx rates to get USD. In my past experience using other systems like Adaptive, this would take 3 minutes. I’m bumping this up because I think there is an opportunity to create an easier/more intuitive formula playground or builder for some calculations.

14 days ago

pigment_enthusiastSeasoned Pigmenteer

Questions & Conversations

Aggregate the metric's data based on a dimension

I am trying to consolidate the no. of projects assigned to an employee by below formula:('Assigned Project'[BY COUNTUNIQUE: 'd. Integer','d. Employee'])The metric is of dimensions: Project, Integer, employee .In rows, i have all the dimensions of the metric, but am getting the “1” as the result, and the result is correct if I keep only employees in the rows.I need to fetch the total no. of projects assigned to an employee. (Metric is having 3 dimensions: Project, Integer, employee ). If an employee has total 4 projects assigned, it should show: “4” as the output for that employee instead of “1” value in each of 4 rows.

14 days ago

pigment_enthusiastSeasoned Pigmenteer

Questions & Conversations

Get the dimension list value based on a metric

Hi,I have a metric Project Allotted of data type: Project dimension;metric having dimensions: Employee, Project Role and Integers.how can I fetch the employee name in a metric “Emp” of data type: Employee and with dimensions: Project Role and Project from the above ABC metric and with Lastnonblank integer?

15 days ago

VianneyOccasional Observer

Questions & Conversations

Can Pigment recognise a date dimension list if not linked with the native "Day" Dimension in Pigment ?

Hello hello Pigment communityI am struggling over an issue and maybe someone can help me. My goal is here to setup a dashboard to analyse our commercial pipeline. So all the client listed in our pipeline are potentiel leads. We have in this data several columns of date : last interaction date, last modified date, expected close date, etc… with also another column : “extract date” indicating the date of the extract of the whole data. The difficulty is that i cannot link all of theses column with the “Day” dimension in Pigment because i can’t have in the same metric several dimension linked with the “Day Dimension”. Hence i will have to create dimension for all of theses columns, not linked to the “Day dimension”, in order to be able to use them in my metrics. But my question is : if i create a dimension in which my data is several “date”, will pigment be able to recognize and organize it (in a graph for example) if the data is not linked with a native Pigment dimension ? For example, if

15 days ago

OlaSeasoned Pigmenteer

Questions & Conversations

Calculating Variance percentage for YTD values

We are trying to create a Income Statement for actuals vs Budget and previous years (PY in the table below) value. Showing both monthly value and YTD. We have our metrics on the rows in the table below. YTD is created as a calculated item using Cumulate and all PY columns are also created as calculated items, using an Offset on version Actuals. The problem is that I can’t get the column to the very right “Var PY %” to show the right value, no matter how I define the calculation priority. If I put it before YTD it is blank and if I put it after YTD it calculates the variance as a percentage for each month and then sums all these percentages together which results in a totally incorrect value. Any ide how to set up the calculations to make this work?

16 days ago

Explore the Community

Connect with other users, discuss how you're using Pigment, and get inspired

Community Welcome Guide

5 topics
8 Replies

Questions & Conversations

631 topics
1711 Replies

Job Board

82 topics
1 Reply

Announcements

33 topics
35 Replies

Customer Leaderboard

Show full leaderboard

Badge winners

Carlos Peraltahas earned the badge Read and Interpret Formulas Certified
divik.sharmahas earned the badge Read and Interpret Formulas Certified
Raúlhas earned the badge Read and Interpret Formulas Certified
Florenthas earned the badge Read and Interpret Formulas Certified
Amrutha Padakantihas earned the badge Read and Interpret Formulas Certified

Show all badges

Employee Leaderboard

Show full leaderboard

Welcome to the Pigment Community!

Explore the Community

Get Started with Pigment

Browse Documentation

Become a Pigment Pro

Featured Articles

Explore the Community

Explore the Community

Community Welcome Guide

Questions & Conversations

Job Board

Announcements

Customer Leaderboard

Badge winners

Employee Leaderboard

Need more help?

Contact Customer Support

Contact Partner Support

Welcome to the Pigment Community!

Featured Articles

Explore the Community

Community Welcome Guide

Questions & Conversations

Job Board

Announcements

Customer Leaderboard

Badge winners

Employee Leaderboard

Need more help?

Sign up

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Scanning file for viruses.

This file cannot be downloaded