Pigment Community | Community

Explore the Community

Recently Active
Help Others
Categories

I am working on setting up an integration between TeamOhana (headcount platform) and Pigment, which needs to be connected through an API request. Using this link, I have been able to set up the API connection and the action button to trigger the integration but I am unsure of where is the data getting pulled into? Do I need to set up a transaction list beforehand and then somehow link API request so the transaction data in Pigment gets updated? Essentially where is my data going if the API request result shows successful?FYI: It is Authentication: Bear <token> set up.

7 hours ago

Cedric LJSeasoned Pigmenteer

Questions & Conversations

Using dec 24 FTE as a reference value for the forecasted months

Hello,In the below metric I want to use Dec 24 FTE (128.65) as a reference value for the forecasted months based on the metrics CALC_FTE.I used [Select:Month-1] but it’s only working for the first projected month which is jan 25 but not for the forecasted months.For example in february and other forecasted months we should have 128.65+24Thanks for your help

183

8 hours ago

Shane CrinesNewly Minted Pigmenteer

Questions & Conversations

Pigment Rounding Down for Certain Numbers

Has anyone ever noticed Pigment will occasionally round down for certain numbers when using percentages? I was using a fixed 2.95% and it showed up as 2.9% when using one decimal. I ran a test below starting with 0.95% + 1% and noticed other instances of this happening like 5.95% → 5.9%.

433

14 hours ago

NathanEmployee

Modeling Principles

Multi Dimensional Modeling

Pigment is a business modeling platform based on the concept of multi dimensionality.You use multi dimensionality every day at work: you plan by periods, by country, by department, by cost nature, etc. Pigment makes it easy to build data & calculations using the dimensions you need to describe your business. Let’s review how to manipulate Metrics of different Dimensions in Pigment. How should you think about Multi Dimensionality? I always think about multi dimensionality like this: What are the dimensions of my source and what do I want as a result? If they both have the same Dimension there’s nothing to do (example: Bonus Amount = Annual Salary by Employee x Bonus Rate by Employee) If the result I want has more/different Dimensions than the source, then how do I map/allocate it? (example: Tax Rate by Country → Tax Amount by Employee) If they have fewer Dimensions, then how do I sum/remove the one I no longer need? (Spend by Vendors → Total Spend) Below, you’ll find a detail

28803

2 days ago

francoisEmployee

Modeling Principles

How to make your formulas easier to understand

When modeling in Pigment, it's easy to be focused on your output and not thinking about others trying to read your formula. This guide will give you a few tips on how you can make your formulas easier for others to understand. Table of ContentsTip 1 - Use line breaks and tabulations Tip 2 - End your parenthesis at the beginning of the line Tip 3 - Factor your multiplications, additions and modifiers Keeping a good formula hygiene Even though Pigment uses all kinds of functionality to make your formulas more understandable, like having the opportunity to name your dimensions and metrics with user friendly names, but if you like to use Pigment at its full potential you'll get complex formulas quite soon. Chaining modifiers, crossing different sources, and adding conditions will all make your formula more difficult to read. Here are a few tricks to make it easier for you to read your own formulas, for your colleagues, and for us Pigment teams to help you build meaningful calculations f

17257

2 days ago

emilialuJust Arrived

Questions & Conversations

Adding a new Version

Hello, There was a change in the FTE number forecast for the months to go. I would like to add a new version to Pigment to reflect that. Could you please help me by explaining how I can do that? Thank you.

161

3 days 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.

462

3 days ago

SuzzyOccasional Observer

Questions & Conversations

What is the formula to get average of specific month

Hi Team - I’d like to seek your help on how to do the formula for specific months?Previously I’m using Moving Average, however I realized that it’s better to lock the average to specific months. For context this is my current formula → MovingAverage(Actuals,3) - so that it will get the average of the latest 3mos. What I want now is to just get the average of the months of July, Aug, Sep.In addition, the metric in which I will be using the formula allows manual input override. Once I update the formula of the average, will it override the manual input?Thank you in advance for your help!

140

3 days ago

Noella ThierryNewly Minted Pigmenteer

Questions & Conversations

Transfer value from one quarter to another without values moving when changing switchover dates

Hello!I want to transfer values from one quarter to another, based on certain conditions written by IF[...] and I am using filter and select as shown below:[filter: 'Actuals & Dimensions (Datahub)'::Quarter.'Quarter -1'][Select: 'Actuals & Dimensions (Datahub)'::Quarter-1])))However, when switching the switchover date, the values that I moved from Q to Q+1 will not be in Q+1 anymore. do you have an idea of a better clean way to code this?Thank you very much :))

275

4 days 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

723

4 days ago

P_AgrawalJust Arrived

Questions & Conversations

API Import Set up

7 hours ago

emilialuJust Arrived

Questions & Conversations

Adding a new Version

161

3 days ago

OlaSeasoned Pigmenteer

Questions & Conversations

Link to a prefiltered board

462

3 days ago

SuzzyOccasional Observer

Questions & Conversations

What is the formula to get average of specific month

140

3 days ago

Noella ThierryNewly Minted Pigmenteer

Questions & Conversations

Transfer value from one quarter to another without values moving when changing switchover dates

275

4 days ago

A_GarneriSeasoned Pigmenteer

Questions & Conversations

How "RANK" (Sequential), ranks?

723

4 days ago

LouieOccasional Observer

Questions & Conversations

Previous Function with Multiplication

Hi Pigmenters,Any suggestions on how to write a more elegant formula to achieve the results shown in the Excel please.Here s the current solution: ifblank(ifblank(Metric, 1)*previous(Month), Metric) Thanks, Louie

603

4 days ago

Antonin GRNewly Minted Pigmenteer

Questions & Conversations

Create a block through an API

Hello, I am exploring API’s capabilities in Pigment and by now I found that API can be used to : Import / Export data Manage users in the case we use SCIM Monitor application Audit logsI did not find any documentation about managing (create, modify, delete) blocks. For example, I would like to create a metric. Is there a way to do it through an API ? Thanks a lot for your answer, Antonin

182

5 days ago

VicoNewly Minted Pigmenteer

Questions & Conversations

Import SFTP - Most recent file is not working

Hi! Can anyone help me with the correct format for this import? Last time that I updated the file was on Sept 25th 2024. I’ve checked this document and seems to be ok,so, not sure what may be going on:

140

6 days ago

YaejisNewly Minted Pigmenteer

Questions & Conversations

Find the text referencing the txn lsit

Hi! Can you please help creating a formula for below? In <BT: Interchange + Pass Through Transactions> transaction list & <Card Type> property dimension “does_not_apply” only, review <Description> property text and populate the <Card Type> dimension in <Text> property if the <Description> property contains the text listed in the <BT: does_not_apply Remap> transaction list? Thank you!

220

7 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

642 topics
1734 Replies

Job Board

82 topics
1 Reply

Announcements

33 topics
35 Replies

Customer Leaderboard

Show full leaderboard

Badge winners

CDALMAYhas earned the badge Helper
Alexandre SAMUELhas earned the badge Partner Solution Consultant Certified
Khanh Dohas earned the badge Pigment Modeling Fundamentals Certified
Etienne Rivierehas earned the badge Read and Interpret Formulas Certified
Carlos Peraltahas earned the badge Pigment Modeling Fundamentals 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