community.gopigment.com Open in urlscan Pro
2600:9000:26db:2c00:10:8bf:5cc0:93a1  Public Scan

Form analysis
2 forms found in the DOM

GET /search/index

<form method="get" action="/search/index">
  <div class="searchbox searchbox--large qa-search-area">
    <div class="searchbox__input algolia-search--forum qa-menu-search-input">
      <div class="search-and-filter-wrapper"><span>
          <div class="algolia-search-container" role="combobox" aria-haspopup="listbox" aria-labelledby="downshift-2-label">
            <div class="algolia-search-container--empty-input">
              <div class="search-box"><input aria-label="Search" type="search" placeholder="How can we help?" autocomplete="off" autocorrect="off" autocapitalize="off" class="search-box__input" aria-autocomplete="list"
                  aria-labelledby="downshift-2-label" id="downshift-2-input"><button type="submit" aria-label="Enter" class="search-box__submit"><svg aria-hidden="true" width="16" height="16" class="" viewBox="0 0 24 24"
                    xmlns="http://www.w3.org/2000/svg">
                    <path
                      d="M15.5 14H14.71L14.43 13.73C15.41 12.59 16 11.11 16 9.5C16 5.91 13.09 3 9.5 3C5.91 3 3 5.91 3 9.5C3 13.09 5.91 16 9.5 16C11.11 16 12.59 15.41 13.73 14.43L14 14.71V15.5L19 20.49L20.49 19L15.5 14ZM9.5 14C7.01 14 5 11.99 5 9.5C5 7.01 7.01 5 9.5 5C11.99 5 14 7.01 14 9.5C14 11.99 11.99 14 9.5 14Z"
                      fill="currentColor"></path>
                  </svg></button><button type="reset" aria-label="Clear search" class="search-box__reset" style="opacity: 0;"><svg aria-hidden="true" width="16" height="16" viewBox="0 0 16 16" fill="none" class="">
                    <path
                      d="M8.00065 1.33334C4.31398 1.33334 1.33398 4.31334 1.33398 8.00001C1.33398 11.6867 4.31398 14.6667 8.00065 14.6667C11.6873 14.6667 14.6673 11.6867 14.6673 8.00001C14.6673 4.31334 11.6873 1.33334 8.00065 1.33334ZM11.334 10.3933L10.394 11.3333L8.00065 8.94001L5.60732 11.3333L4.66732 10.3933L7.06065 8.00001L4.66732 5.60668L5.60732 4.66668L8.00065 7.06001L10.394 4.66668L11.334 5.60668L8.94065 8.00001L11.334 10.3933Z"
                      fill="currentColor"></path>
                  </svg></button></div>
            </div>
          </div>
        </span></div>
    </div>
  </div>
</form>

Name: forgotPassword — POST /member/forgotPassword

<form name="forgotPassword" method="post" action="/member/forgotPassword" class="form js-ajax-form--forgot" id="form--forgot__2038497061" data-mn="ItemView" data-mn-app="frontend">
  <div class="js-notification" data-mn="CompositeView" data-mn-app="frontend">
    <div class="box box__pad is-hidden">
      <ul></ul>
    </div>
  </div>
  <div class="form__row">
    <div class="first">
      <label class="label required" for="forgotPassword_username"> Username or e-mail </label>
    </div>
    <div class="second">
      <input type="text" id="forgotPassword_username" name="forgotPassword[username]" required="required">
    </div>
  </div>
  <div class="form-row first">
    <button type="submit" id="forgotPassword_submit" name="forgotPassword[submit]" class="btn btn--cta qa-submit-button"> Send <div class="loader"></div></button>
    <a href="#" class="group__item end js-open-modal qa-forgot-password-overview-link" data-modal="login" data-mn="ItemView" data-mn-app="frontend">Back to overview</a>
  </div>
  <input type="hidden" id="forgotPassword__token" name="forgotPassword[_token]" value="BAX-1Vv5spigvSkA5e3jAew20BbfVqNQLJyQXLjq1X0">
</form>

Text Content

COOKIE POLICY

We use cookies to enhance and personalize your experience. If you accept you
agree to our full cookie policy. Learn more about our cookies.

Accept cookies Deny all
Cookie settings
×


COOKIE SETTINGS


We use 3 different kinds of cookies. You can choose which cookies you want to
accept. We need basic cookies to make this site work, therefore these are the
minimum you can select. Learn more about our cookies.


Basic
Functional

Normal
Functional + analytics

Complete
Functional + analytics + social media + embedded videos

Accept cookies




 * Community
    * 
    * * Home
      * Recently active topics
      * Unanswered questions
      * Explore the Community
      * Community Welcome Guide5
      * Questions & Conversations473
      * Job Board72
      * Announcements22

 * Knowledge Base
    * 
    * * Search the Knowledge Base
      * Documentation
      * Getting Started23
      * Modeling & Formulas40
      * Functions100
      * Reporting & Data visualization38
      * Collaborating on Pigment21
      * Security & Permissions27
      * Importing and Exporting Data54
      * Legal information1
      * Become a Pigment Pro
      * Modeling Principles7
      * Modeling Guides42
      * Strategic Resources9
      * Newsletter Archives 21
      * Customer Resources
      * Academy Resources 7

 * Academy
 * Product Roadmap
 * Events
 * Groups



 * Create topic
   Login





WELCOME TO THE PIGMENT COMMUNITY!





EXPLORE THE COMMUNITY

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


GET STARTED WITH PIGMENT

Find everything you need to get going


BROWSE DOCUMENTATION

Learn about Pigment features


BECOME A PIGMENT PRO

All the best practices and the guides from the Pigment team


⭐ FEATURED ARTICLES ⭐

 * How to set up an Org Chart
 * The Pigment Community is levelling up – introducing our new badge and rank
   system! 🏅
 * 7 questions to ask before bringing new data into Pigment
 * Metric to Metric Importing
 * Pigment in Action: How to calculate streak cumulations
 * How to make your formulas easier to understand
 * The FP&A Jobs Report #74 (Walmart, Deel, Amazon...)


EXPLORE THE COMMUNITY


 * Recently Active
 * Help Others
 * Categories

BenjiCommunity Manager
published in Job Board

THE FP&A JOBS REPORT #74 (WALMART, DEEL, AMAZON...)

For all the new joiners, a quick reminder of what you get with this
newsletter:👉🏾 Around 10 fresh job offers👉🏻 From top companies worldwide👉
Every week Executive Roles [IT SERVICES & CONSULTING] FP&A Senior Director /
Finance Ops Sr. Director 📍Santa Clara, US Hitachi Vantara is a subsidiary of
Hitachi Ltd. focused on providing data storage, analytics, and infrastructure
solutions for businesses. [SOFTWARE] Associate FP&A Director 📍Newark, US
Audible is an audiobook and spoken-word entertainment service owned by Amazon,
offering a vast selection of audiobooks, podcasts, and original content that
users can stream or download for listening on various devices. [RETAIL] FP&A
Director 📍Bentonville, US Walmart Inc. is a multinational retail corporation
based in the United States, operating a chain of hypermarkets, discount
department stores, and grocery stores. [STAFFING & RECRUITING] Head of Group
FP&A 📍Geneva, CH Eleven appears to be a global recruitment agency specializing
in recr

040

2 days ago
W

Weining BenBudding Pigmenteer
asked in Questions & Conversations

PRORATA FOR OVERLAP PERIOD


Hello, We import our sick leave period data into a transaction list in Pigment:
Each employee could have several records of different periods. But it's possible
to have overlap periods for one person, for exemple: Emp_2 has an overlap period
from 03/04/2023 - 03/08/2023. So for this case, I have two needs: 1. Create a
metric to affiche those employees who have overlap period 2. Even it's error and
we warn it, we still want to calculate these sick leave period from the earliest
start date to the lastest end date. PS: I’m not sure if it’s helpful to create
unique ID for all records in the transaction list. We can do it if need. Thanks
you in advance for any advice!!

00
W

3 days ago
G

Gali BaramNewly Minted Pigmenteer
asked in Questions & Conversations

CALCULATING MOVINGAVERAGE() TREATING BLANKS AS ZERO'S USING ISDEFINED() TIMES
OUT


Hi, I’m trying to calculate a moving average where blanks are counted as zero’s.
When trying to leverage the “is defined” formula I get a calculation time-out
error. Please advise.

02
G

3 days ago
W

Weining BenBudding Pigmenteer
asked in Questions & Conversations

COUNT NUMBER OF OCCURRENCES AND MARK THE LAST OCCURRENCE


Hello, I currently have the following table, in the first column I fill in
tickets manually.And now I have two needs: I hope to count the number of
corresponding Tickets through the second column. I hope to mark the last ticket
in sequence. I tried using the Rank function, but couldn't achieve these two
needs accurately. Can you give me some suggestions? Thank you in advance!!

04
W

3 days ago
Thu MaiNewly Minted Pigmenteer
asked in Questions & Conversations

SPARSE ENGINE CONCEPT


Hi Pigmenteers! While I’m taking Pigment trainings and explore my personal
application, I figure out that there is no information about the size of my
application or total number of cells, etc.. and the reason behind is that
Pigment is a sparse engine. Therefore, can you help explain to me more about the
concept of sparse engine - what is a sparse engine, how does it actually work
and what is the benefit compared to non-sparse engine?

13

4 days ago
R

Rahul KumarJust Arrived
asked in Questions & Conversations

USING SCENARIOS IN FORMULA


Hello Everyone, I am working on a headcount report where in I have Actuals and
Budget along with the variance. Now I want to reference scenarios in the
formulas somehow to create a metric to use this logic: If Actuals is blank and
Budget is there, it means that that seat is not filled yet. Is there anyway to
do it?

20
R

4 days ago
W

Weining BenBudding Pigmenteer
asked in Questions & Conversations

CAN WE SWAP DIMENSION AND DATA OF A METRIC?


Hi, I currently have two metrics and three dimensions involved (Job position,
Employee, Month): Metric Manager_job position, with two dimensions Month and
Employee, data type is Job position, where I store the manager’s job position
for each employee by month Metric Employee_job position, with two dimensions
Month and Employee, data type is Job position, where I store their own job
position for each employee by month I tried to create a metric with Month and
Employee dimension, data type Employee, which shows me the Manager’s Name
(dimension Employee) for each employee by month, but I didn’t success to make
it. Can you give me some advice? Thanks in advance!

16
W

4 days ago
M

MKSMPBBudding Pigmenteer
asked in Questions & Conversations

HOW TO PULL THE AMOUNT FOR THE LAST NON-BLANK MONTH ONLY


The below pulls through monthly costs from an input. 'Cloud Cost Input From
Marketing'[by constant: 'Cloud Cost From Marketing Team'."Staging"] I would like
to pull through only the latest available month but have tried lastnonblank and
either im doing it wrong or its not working. Any help would be appreciated,

010
M

4 days ago
Sharon ConroyCommunity Manager
published in Collaborating on Pigment

SET UP A PIGMENT WORKFLOW

Pigment Automations uses a series of up to 10 linked actions to create a
workflow to defined Members. This article discusses how to set up a workflow in
Automations. Before you Begin Set Up a Workflow Administer the Workflow
Application Settings Task Management Locating Specific Tasks or Automations This
topic is for Pigment Members who are workflow owners. A workflow owner is
responsible for creating the series of tasks that make up the workflow,
monitoring their status, performing actions on the tasks and workflow, such as
updating assignees, sending reminders and so on. If you’ve been assigned a task
in a workflow and need more information on performing it, see Interact with Your
Assigned Tasks. Before you Begin Permissions. You need the Configure Automations
Permission to be able to Create/Edit/Delete/Enable/Disable an Automation. This
Permission has been granted to all Members having the Configure Blocks
Permission. You need the View History Permission to view the execution detail

0780

4 days ago
C

CindyJust Arrived
asked in Questions & Conversations

SHOW QUARTER AND YEAR END HEADCOUNT WITHOUT SUMMING PERIODS


I am trying to show just the quarter end and year end headcount. However, rather
than taking the last month in the quarter or the year, the quarter end numbers
sums every month. How do I set up headcount so the quarter does not show a sum
of the periods but rather the last period? For now, I’ve created a report with
just the last months of the quarter but I plan to add headcount to the bottom of
a PnL which has accounts summed in the quarter.

01

5 days ago
Show more activity
W

Weining BenBudding Pigmenteer
asked in Questions & Conversations

PRORATA FOR OVERLAP PERIOD


Hello, We import our sick leave period data into a transaction list in Pigment:
Each employee could have several records of different periods. But it's possible
to have overlap periods for one person, for exemple: Emp_2 has an overlap period
from 03/04/2023 - 03/08/2023. So for this case, I have two needs: 1. Create a
metric to affiche those employees who have overlap period 2. Even it's error and
we warn it, we still want to calculate these sick leave period from the earliest
start date to the lastest end date. PS: I’m not sure if it’s helpful to create
unique ID for all records in the transaction list. We can do it if need. Thanks
you in advance for any advice!!

00
W

3 days ago
G

Gali BaramNewly Minted Pigmenteer
asked in Questions & Conversations

CALCULATING MOVINGAVERAGE() TREATING BLANKS AS ZERO'S USING ISDEFINED() TIMES
OUT


Hi, I’m trying to calculate a moving average where blanks are counted as zero’s.
When trying to leverage the “is defined” formula I get a calculation time-out
error. Please advise.

02
G

3 days ago
R

Rahul KumarJust Arrived
asked in Questions & Conversations

USING SCENARIOS IN FORMULA


Hello Everyone, I am working on a headcount report where in I have Actuals and
Budget along with the variance. Now I want to reference scenarios in the
formulas somehow to create a metric to use this logic: If Actuals is blank and
Budget is there, it means that that seat is not filled yet. Is there anyway to
do it?

20
R

4 days ago
A

Antoine-2Newly Minted Pigmenteer
asked in Questions & Conversations

DEPENDENT DROPDOWN IN A FORM


Hello,I need to create a form for end users to assign a cross-dimension
(direction and activity) to 2 new dimensions (Analytical Dim level 1 and
Analytical Dim level 2). To do this, I was thinking of: Creating a table with
the direction/activity cross and the associated data. Creating 2 metrics with
the direction and activity dimensions A. to select: Analytical Dim level 1 B. to
select: Analytical Dim level 2 However, I would like the selection of
"Analytical Dim level 1" to only display the child items of Analytical Dim level
2. Is it possible to do this and if so, how? Thank you in advance for your help.

21

6 days ago
Y

yplinJust Arrived
asked in Questions & Conversations

HOW DO I TURN MY VARIANCE TO POINTS VS BPS


Could someone please help let me know if I could have my calculation shown in
points vs bps? Thank you

12

6 days ago
K

KevinSeasoned Pigmenteer
asked in Questions & Conversations

IS IT POSSIBLE TO USE PREVIOUS() SIMULTANEOUSLY ACROSS MULTIPLE DIMENSIONS?


I am building an attrition model based on month dimension and a dimension called
‘30 Day Cohort’. I am almost certain that I will run into a circular reference
if I do not use the Previous function. However, because I am working with 2
dimensions I am unclear on how to reference the previous month and previous ‘30
Day Cohort’ dimension simultaneously. Is this possible? Can I combine multiple
Previous functions? Is it possible to nest two Previous functions? To start my
model, I have “initialized” the metric with both the starting values in the
first month and the forecasted new subscribers in the first ‘30 Day Cohort’ (0
in my case): What I would like to do is calculate a formula on the value in the
previous month and previous cohort and then do so recursively (this is why I
think I need to use the Previous function). So for Oct 23 and cohort 1, I would
want to do my calculation based on the Sep 23 and cohort 0 value (1,895); for
Oct 23 and cohort 2, I would want to do my calculation b

18
B

1 month ago
OlaNewly Minted Pigmenteer
asked in Questions & Conversations

CONDITIONAL RECIPIENTS AND SCENARIOS


I have configured an Automation that triggers in my scenario “Forecast”. The
automation contains a conditional recipient, but the issue is that the recipient
is defined by my metrics value in scenario “Baseline” instead of the value in
scenario “Forecast”. Is this the way it is supposed to work or is there any way
around it?

00

1 month ago
B

Brian LeseJust Arrived
asked in Questions & Conversations

LOOKER WEBHOOK IMPORT ISSUE


I am attempting to import data from Looker via webhook but am receiving a CSV
Format & Mapping error each time. I have the saved import configuration ID
correct in the webhook address, but when importing, it seems like Pigment does
not recognize the column headers. I was careful to import the same exact CSV
when setting up the configuration, it should have the same headers. Would anyone
be able to advise on this?

01

2 months ago
A

anjanaNewly Minted Pigmenteer
asked in Questions & Conversations

UPDATE A FORMULA


I have a formula on my data load table, which automatically attributes a ‘clean’
code to an uploaded busline code. For eg. If a country NG uses XXXNOTALLOC , the
clean code attributed to it is XXXNOTALOCNG The formula is the following :
if(('Actuals P&L Data Load'.'Busline Code - Warehouse' = Busline."LOCCENTRALTN"
or 'Actuals P&L Data Load'.'Busline Code - Warehouse' = Busline."LOCCENTRAL")and
'Actuals P&L Data Load'.id_company='Legal
Entity'."JT_TN",Busline."LOCCENTRALTNSSC", if('Actuals P&L Data Load'.'Busline
Code - Warehouse' = Busline."LOCCENTRAL" or 'Actuals P&L Data Load'.'Busline
Code - Warehouse'.'is not alloc',ifblank(item('Actuals P&L Data Load'.'Busline
Code - Warehouse'.'Original - Busline'& 'Actuals P&L Data Load'.'Company Country
- Warehouse'.Code,Busline),'Actuals P&L Data Load'.'Busline Code - Warehouse'),
'Actuals P&L Data Load'.'Busline Code - Warehouse')) I dont want this to happen,
I want to code to stay at XXNOTALLOC. I am not sure if this will have
repurcussions

08
A

2 months ago
E

ELeff_AccBudding Pigmenteer
asked in Questions & Conversations

FILTERING DIMENSION SELECTIONS


Is there existing functionality to facilitate the filtering of a dimension input
metric, say on a Department dimension, whereby subsequent selections would then
be filtered based on only valid intersections that apply? I currently have two
input metrics, one by dimension Department and the other by dimension Position.
Is there a way that when the selection is made for Department, say “Accounting”,
only the relevant Job Positions are now available within that dimension
drop-down, so that something like Job Position “Legal Analyst” isn’t a viable
option?

03

2 months ago
Show more activity


EXPLORE THE COMMUNITY

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


COMMUNITY WELCOME GUIDE

 * 5 topics
 * 1 Reply


QUESTIONS & CONVERSATIONS

 * 473 topics
 * 1295 Replies


JOB BOARD

 * 72 topics
 * 1 Reply


ANNOUNCEMENTS

 * 22 topics
 * 30 Replies



Welcome to the Pigment Community! 🎉




11 months ago


EVENTS CALENDAR




CUSTOMER LEADERBOARD

 * Week
 * All time

Show full leaderboard
1
abhilashsawla

3751 points

3751 points

2
CamilleMomo

3585 points

3585 points

3
Sofia Costa

2330 points

2330 points

4
A

Alexandre

2113 points

2113 points

5
MKohli

1782 points

1782 points

6
R

rschimm

1753 points

1753 points

7
C

Chelsea

1474 points

1474 points

8
E

Elodie

1405 points

1405 points

Show full leaderboard


BADGE WINNERS

 * PDIA_BARTLEhas earned the badge Pigment Modeling Fundamentals Certified
 * Weining Benhas earned the badge Emerging Author
 * aseghirhas earned the badge Pigment Modeling Fundamentals Certified
 * Gali Baramhas earned the badge Innovator
 * Romain Vrijenshas earned the badge Pigment Modeling Fundamentals Certified

Show all badges


EMPLOYEE LEADERBOARD

 * Week
 * All time

Show full leaderboard
1
Benoit

5107 points

5107 points

2
Benji

3950 points

3950 points

3
Pierre

2652 points

2652 points

4
Ben

2099 points

2099 points

5
KarlW

2015 points

2015 points

Show full leaderboard




NEED MORE HELP?


CONTACT SUPPORT

Contact our support team and we'll be happy to help you get up and running!

Powered by Gainsight
Terms & ConditionsCookie settings



SIGN UP

Already have an account? Login

SINGLE SIGN-ON NEED HELP?

Log in with your Pigment account


LOG INTO THE PIGMENT COMMUNITY

SINGLE SIGN-ON NEED HELP?

Log in with your Pigment account

Enter your username or e-mail address. We'll send you an e-mail with
instructions to reset your password.

Username or e-mail

Send

Back to overview


SCANNING FILE FOR VIRUSES.

Sorry, we're still checking this file's contents to make sure it's safe to
download. Please try again in a few minutes.

OK


THIS FILE CANNOT BE DOWNLOADED

Sorry, our virus scanner detected that this file isn't safe to download.

OK