community.gopigment.com Open in urlscan Pro
2600:9000:214f:7800: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__1105147542" 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="FEHzTSREcUoZhhHvbX51GuBMXrd6PowoRTJOqXMMF5A">
</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 & Conversations463
      * Job Board71
      * Announcements22

 * Knowledge Base
    * 
    * * Search the Knowledge Base
      * Documentation
      * Getting Started23
      * Modeling & Formulas40
      * Functions100
      * Reporting & Data visualization38
      * Collaborating on Pigment20
      * Security & Permissions27
      * Importing and Exporting Data53
      * 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
 * Metric to Metric Importing
 * The Pigment Community is levelling up – introducing our new badge and rank
   system! 🏅
 * 7 questions to ask before bringing new data into Pigment
 * Pigment in Action: How to calculate streak cumulations
 * How Pigment implements new use cases in our internal Workspace
 * How to make your formulas easier to understand
 * The FP&A Jobs Report #66 (Spring Health, Lego, Microsoft, Qonto...)


EXPLORE THE COMMUNITY


 * Recently Active
 * Help Others
 * Categories

BenjiCommunity Manager
published in Job Board

THE FP&A JOBS REPORT #73 (GONG, CANVA, AIRBNB, TESLA...)

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 [SOFTWARE] FP&A Director 📍Remote, US Gong is a
revenue intelligence platform that utilizes artificial intelligence to analyse
sales interactions, providing insights and recommendations to improve sales
effectiveness and drive revenue growth for businesses. [SOFTWARE] Head of FP&A
📍San Francisco, US Canva is a global online visual communications platform on a
mission to empower the world to design. Senior FP&A Controller
📍Levallois-Perret, FR GEODIS is a leading global logistics provider
acknowledged for its expertise across all aspects of the supply chain. VP of
Strategic Finance 📍Paris, FR Qonto is a French fintech company that provides
online business banking services, offering business bank accounts, corporate
cards, and financial management tools. Hiring? Submit a job! Other Positions
[RETAIL] Group FP&A Man

070

2 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

01

2 days ago
J

justinspielmanJust Arrived
asked in Questions & Conversations

CREATING QUARTER-END / YEAR-END SUMMARIES OF CUMULATIVE METRICS


Hi, I’m trying to add a view of a monthly total headcount metric (a cumulative
value, dimensioned by month) to quarterly and annual tables that will show only
the final headcount from the last month of each period. For example, I know
Pigment’s default behavior is to sum this cumulative headcount across every
month of a year if I add the headcount metric to an annual table directly, but I
need to isolate December 31 headcount only. Is there a relatively simple way to
create these period-end summary numbers? Thanks!

02

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

10
A

6 days ago
N

Naomi VriendBudding Pigmenteer
asked in Questions & Conversations

HOW CAN WE GET A DAY DIMENSION TO STOP SHOWING DATE AND TIME?


Hey there, I’m trying to use yesterday’s revenue to forecast the rest of the
month’s revenue.For that, we created a Day dimension, which is a calendar type.
Strangely, when displayed in the dimension itself, it looks normal (like a
date).However, when we add it to a metric pivot it always adds the time. How do
we stop it from doing this?I’ve already checked the Day dimension Special
Properties and Default Display Name and it just uses the Name column for this.
Images below. Any help is much appreciated! Day dimension Day dimension used in
a metric pivot

02

9 days ago
E

ElodieSeasoned Pigmenteer
asked in Questions & Conversations

FORMULA ERROR - TIMED OUT


Hello, I am trying to calculate the number of employees who left by hire date
cohort and number of months that they stayed in the society. Here is the formula
I have (but doesn’t work because it is too complicated I think): Employee [BY
COUNT: Employee.'Cohort Month', Employee.'Month tenure cohort',
Employee.Country, Employee.'First Job Position'.'Team Graph HR'] The Cohort
month corresponds to the month of arrival. The Month tenure cohort corresponds
to the number of months the employee stayed in the society. I want this metric
by team department (Team Graph HR) of their first job position (because some
employees can evolve from one job to another in the company). Could you please
help me finding the best formula here? Thanks! Elodie

03
E

9 days ago
R

RohitDivate_GustoJust Arrived
asked in Questions & Conversations

HAS ANYONE TRIED INTEGRATING CAPIQ WITH PIGMENT FOR PUBLIC COMPANY BENCHMARKING?


Curious to know if there any 1st or 3rd party connectors to get capiq data
directly in pigment automatically. It’s not too difficult to upload a CSV on a
monthly cadence, but would be great if there was a live connection. The
alternative is to send this to an internal DWH then to Pigment, but that might
be a lot of internal work from our BI teams.

01

9 days ago
BenjiCommunity Manager
published in Job Board

THE FP&A JOBS REPORT #72 (AIVEN, DELIVEROO, OPTIMIZELY...)

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 [RESEARCH SERVICES] FP&A Director 📍Washington, US
The Urban Institute is a non-profit research organisation focused on conducting
social and economic policy research to address urban and societal challenges.
[IT SERVICES & CONSULTING] FP&A Controller 📍Bussy-Saint-Georges, FR TD SYNNEX
is a global technology distribution company that provides a wide range of IT
products and solutions to businesses. [RETAIL] FP&A Director 📍Vienna, AT C&A is
an international fashion retail chain headquartered in Belgium, offering
affordable clothing and accessories. [RETAIL] Contrôleur de Gestion 📍Lezennes,
FR Leroy Merlin is a French multinational home improvement and gardening
retailer, offering a wide range of products including building materials, tools,
furniture, and decor for home renovation and construction projects. Hiring

0220

9 days ago
Sharon ConroyCommunity Manager
published in Reporting & Data visualization

APPLY DEFAULT FORMATTING ACROSS ALL INSTANCES OF A METRIC

Default formatting in Pigment is used when you want to apply a specific
formatting or style to text or numerical values across all Views and usages
where a specific Metric is used. Coming Soon! Before you Begin Apply Default
Formatting to Metrics Format Numerical Metrics Values Number display Format Text
Metrics It allows you to format a Metric only once without needing to reformat
it repeatedly. Let’s say you have a Metric that you use in several Views,
Tables, and reports. Your Metric needs to be displayed as a percentage, and with
one decimal only. By applying a default formatting to this Metric, you can
format it a single time instead of manually formatting it in each location it’s
used. For more information on formatting in Pigment, check out these articles:
Format and Style Your Data in Pigment Apply Static Formatting to Define
Different Views Apply Conditional Formatting to Highlight Data Changes Before
you Begin Here are some considerations before you apply default formatting t

0240

10 days ago
Sharon ConroyCommunity Manager
published in Reporting & Data visualization

APPLY STATIC FORMATTING TO DEFINE DIFFERENT VIEWS

Static formatting in Pigment is used when you want to apply formatting or a
certain style to your data in Lists, Metrics, and Tables in Grid or KPI display
mode. Static formatting is applied to a specific View, allowing you to have
multiple Views with different formatting. This can include specific cells, font
style, value displaying, and colors. It's useful when you want to present your
data in a more efficient and visually appealing way. Apply Static Formatting
Static Formatting Options Selection Colors and style Values Number display Text
display Apply Static Formatting Click Format. Static formatting opens and the
following selection shortcut is available: Selection Shortcuts Static Formatting
Options Selection When you select a header, you will be given the three options
on what should be formatted, the selected areas will pulse to highlight what
will be formatted. Whole row / Whole Column. Selects the cells and headers,
depending on which header is selected. Header. When selected

0200

12 days ago
Show more activity
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

01

2 days ago
J

justinspielmanJust Arrived
asked in Questions & Conversations

CREATING QUARTER-END / YEAR-END SUMMARIES OF CUMULATIVE METRICS


Hi, I’m trying to add a view of a monthly total headcount metric (a cumulative
value, dimensioned by month) to quarterly and annual tables that will show only
the final headcount from the last month of each period. For example, I know
Pigment’s default behavior is to sum this cumulative headcount across every
month of a year if I add the headcount metric to an annual table directly, but I
need to isolate December 31 headcount only. Is there a relatively simple way to
create these period-end summary numbers? Thanks!

02

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

10
A

6 days ago
R

RohitDivate_GustoJust Arrived
asked in Questions & Conversations

HAS ANYONE TRIED INTEGRATING CAPIQ WITH PIGMENT FOR PUBLIC COMPANY BENCHMARKING?


Curious to know if there any 1st or 3rd party connectors to get capiq data
directly in pigment automatically. It’s not too difficult to upload a CSV on a
monthly cadence, but would be great if there was a live connection. The
alternative is to send this to an internal DWH then to Pigment, but that might
be a lot of internal work from our BI teams.

01

9 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

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

1 month 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
G

Grégoire LeveilléNewly Minted Pigmenteer
asked in Questions & Conversations

KEEPING ONLY THE FIRST NON BLANK VALUE OF A METRIC


Hello Pigment Community, I want to have a metric that has clients in lines and
months in columns and that is filled with 1 only for the first month the client
bought a thing. So in the end, on each line there should be only one 1 in the
month of the first buy. For the moment I created a metric with clients in line
and months in columns that is filled with 1 for all the months when the client
bought a thing. My idea was to use this metric and the firstnonblank modifier
but it does not work… Could you help me please ?

16

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

 * 463 topics
 * 1260 Replies


JOB BOARD

 * 71 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

3461 points

3461 points

3
Sofia Costa

2330 points

2330 points

4
A

Alexandre

2103 points

2103 points

5
MKohli

1772 points

1772 points

6
R

rschimm

1733 points

1733 points

7
C

Chelsea

1474 points

1474 points

8
E

Elodie

1405 points

1405 points

Show full leaderboard


BADGE WINNERS

 * JDLovehas earned the badge Pigment Modeling Fundamentals Certified
 * CharanSinghhas earned the badge Pigment Modeling Fundamentals Certified
 * PatMachas earned the badge Emerging Chatterbox
 * RachaelShas earned the badge Pigment Modeling Fundamentals Certified
 * Shreyashas earned the badge Pigment Modeling Fundamentals Certified

Show all badges


EMPLOYEE LEADERBOARD

 * Week
 * All time

Show full leaderboard
1
Chris

11045 points

11045 points

2
Benoit

5095 points

5095 points

3
Benji

3904 points

3904 points

4
Pierre

2632 points

2632 points

5
Ben

2069 points

2069 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