community.gopigment.com Open in urlscan Pro
2600:9000:214f:4400: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__504763208" 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="jNFRbkm0QBjFS-ahgDILHyXp_XhF_ToNra_Rkvo2wMc">
</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 & Conversations483
      * Job Board73
      * Announcements22

 * Knowledge Base
    * 
    * * Search the Knowledge Base
      * Documentation
      * Getting Started23
      * Modeling & Formulas40
      * Functions100
      * Reporting & Data visualization38
      * Collaborating on Pigment21
      * Security & Permissions28
      * 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 ⭐

 * Set Up a Pigment Workflow
 * How to set up an Org Chart
 * 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...)
 * Create a Dependent Dropdown on a List


EXPLORE THE COMMUNITY


 * Recently Active
 * Help Others
 * Categories

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.

24
J

2 days ago
P

PetterNewly Minted Pigmenteer
asked in Questions & Conversations

ERROR: FUNCTION ERROR: FUNCTION IF ARGUMENT 2 AND 3 NEED TO HAVE THE SAME TYPE


Hi! I’m having issues with a formula. My formula is currently looking like this:
The result I get is the error message Function error: function IF argument 2 and
3 need to have the same type. Any idea of what I need to do to get the dummy
name in the CC# column?

04

2 days ago
G

Gali BaramNewly Minted Pigmenteer
asked in Questions & Conversations

DATES EXPORTED INCORRECTLY THROUGH GSHEET CONNECTOR


I’m running into an issue with the dates getting mixed-up when I load data from
Pigment to google sheets (see the formula bar in the screenshot, the date ). The
issue is that the title which is a text field appears as the header, and gets
translated to a date incorrectly. I tried switching the header in Pigment, but
the start/end date fields aren’t listed as options. Did anyone else encounter
this? Any suggested solutions?

00
G

2 days ago
P

PatMacBudding Pigmenteer
asked in Questions & Conversations

CONDITIONAL FORMATTING - HOW DO YOU OVERRIDE SPECIFIC CELLS WITH STATIC
FORMATION?


Is there a way to apply conditional formatting to a column/row with the option
of removing the formatting on specific cells within that column/row? In the
attached example, I would like the bottom row to not be subject to the
conditional formatting.

22
P

3 days ago
Thu MaiBudding Pigmenteer
asked in Questions & Conversations

NATIVE SCENARIO


Hi Pigmenteers 🤗 I have 2 questions related to Pigment’s native scenarios:1.
What are the main benefits of using native scenarios instead of custom scenario
list? 2. I also learn that once you enable native scenarios in Pigment, the
native scenarios will be applied to all the metrics in the application, is there
a way we could remove it out of some specific metrics?

01

3 days ago
Thu MaiBudding Pigmenteer
asked in Questions & Conversations

ABILITY TO ADD MULTIPLE METRICS WITH SAME DIMENSIONS AT THE SAME TIME


Hi Pigmenteers 🤗 I have an input table with 10 input metrics (same dimensions,
serve the same purpose). I know how to create them 1 by 1 directly from the
table (more convenient), but I’m curious whether there is a way in Pigment we
can create them all at the same time? 🤔

02

3 days ago
D
dariousFrequent Reader
asked in Questions & Conversations

FORECAST FUTURE CUSTOMERS USING THE AVERAGE MONTHS TO CONVERT


Dear Pigment Community, I'm currently tackling a challenge with a modeling
project and could really use your expertise. Goal: Forecast future customers
using the average months to convert. Issue: I have a metric for my forecasted
number of customers, but I'm stuck on how to shift these values forward into the
future based on my metric that calculates average months to convert. Desired
outcome: My ideal solution would take the forecasted customer values and shift
them forward into the future by ‘x’ months based on what the average months to
convert value is. Please find images and further explinations bellow. This
metric contains the number of custstomers expected. I want to use this metric to
push the values in # cust fcst forward into the future by the number of average
months. Example using the images above: metric[# Customers FCST]: France,
Inbound Nov 23 value will be shifted to Mar 24, 4 months into the future because
the metric[Avg months to convert previous year] value is 4. I'm

01

4 days ago
Sharon ConroyCommunity Manager
published in Modeling & Formulas

CREATE A DEPENDENT DROPDOWN ON A LIST

Setting up dependent dropdowns on a List is a two step process. The first step
is to establish a configuration Metric that shows the connection between the
dropdowns. The second step is to map the Dimensions to the location where you’ll
use the dropdowns. You can now do both steps in the same process in our
configuration Metric wizard. Before you Begin Create a Dependent Dropdown on a
List Create a New Configuration Metric Editing Dropdown Connections To perform
this task, you need the Can Configure Block permission. Before you Begin When
you set up a configuration Metric, it must be of Boolean type. The Metric's
structure must contain the exact same Dimensions as the Properties you wish to
connect. The Metric needs to establish a relationship with a minimum of two
Dimensions. Shared Metrics with these criteria can be used as configuration
Metric. The Metric's structure must match the Dimensions that are used as
dropdowns in List Properties. After you set up the configuration Metr

1320

4 days ago
Sharon ConroyCommunity Manager
published in Security & Permissions

ADDING AND SWITCHING ACCOUNTS IN PIGMENT

Adding and switching users in Pigment is easy. You can also modify your current
user set-up. This article will quickly walk you through the permissions needed
and the process to invite users into your Pigment Workspace. Adding Users
Switching to Primary Owner Bulk Inviting members Members status Edit Account
Type Changing Application Owners Grant an Admin role to Applications Adding
Users To add members, navigate to the Member section in the Sidebar. In the top
right, click the @Invite new members button. If you don’t see this button, it is
because you do not have an account type of Admin, Security Admin or Primary
owner. Once you click on the button, you will be prompted with a modal. You’ll
have the option to add users individually or through bulk import with a CSV. A
members status will be listed as Pending, until they confirm their email.
Members settings in Pigment Switching to Primary Owner The Primary Owner has the
ability to set another member as the Primary Owner. When they cl

0200

5 days ago
A

Adrien LEmployee
asked in Questions & Conversations

KEY SHORTCUT


Are any Key shortcuts in Development? A shortcut from Editing to User mode in
Board would be helpful, and one for aligning Widget might be great.

10
A

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

24
J

2 days ago
G

Gali BaramNewly Minted Pigmenteer
asked in Questions & Conversations

DATES EXPORTED INCORRECTLY THROUGH GSHEET CONNECTOR


I’m running into an issue with the dates getting mixed-up when I load data from
Pigment to google sheets (see the formula bar in the screenshot, the date ). The
issue is that the title which is a text field appears as the header, and gets
translated to a date incorrectly. I tried switching the header in Pigment, but
the start/end date fields aren’t listed as options. Did anyone else encounter
this? Any suggested solutions?

00
G

2 days ago
P

PatMacBudding Pigmenteer
asked in Questions & Conversations

CONDITIONAL FORMATTING - HOW DO YOU OVERRIDE SPECIFIC CELLS WITH STATIC
FORMATION?


Is there a way to apply conditional formatting to a column/row with the option
of removing the formatting on specific cells within that column/row? In the
attached example, I would like the bottom row to not be subject to the
conditional formatting.

22
P

3 days ago
Thu MaiBudding Pigmenteer
asked in Questions & Conversations

NATIVE SCENARIO


Hi Pigmenteers 🤗 I have 2 questions related to Pigment’s native scenarios:1.
What are the main benefits of using native scenarios instead of custom scenario
list? 2. I also learn that once you enable native scenarios in Pigment, the
native scenarios will be applied to all the metrics in the application, is there
a way we could remove it out of some specific metrics?

01

3 days ago
D
dariousFrequent Reader
asked in Questions & Conversations

FORECAST FUTURE CUSTOMERS USING THE AVERAGE MONTHS TO CONVERT


Dear Pigment Community, I'm currently tackling a challenge with a modeling
project and could really use your expertise. Goal: Forecast future customers
using the average months to convert. Issue: I have a metric for my forecasted
number of customers, but I'm stuck on how to shift these values forward into the
future based on my metric that calculates average months to convert. Desired
outcome: My ideal solution would take the forecasted customer values and shift
them forward into the future by ‘x’ months based on what the average months to
convert value is. Please find images and further explinations bellow. This
metric contains the number of custstomers expected. I want to use this metric to
push the values in # cust fcst forward into the future by the number of average
months. Example using the images above: metric[# Customers FCST]: France,
Inbound Nov 23 value will be shifted to Mar 24, 4 months into the future because
the metric[Avg months to convert previous year] value is 4. I'm

01

4 days ago
A

Adrien LEmployee
asked in Questions & Conversations

KEY SHORTCUT


Are any Key shortcuts in Development? A shortcut from Editing to User mode in
Board would be helpful, and one for aligning Widget might be great.

10
A

6 days ago
O

OumaJust Arrived
asked in Questions & Conversations

ALTERNATIVE OF GROUP BY IN PIGMENT


Hello Pigment! I am having an issue with a formula. I have a dimension called
'MRR-D Invoice '. I want to create the column “latest_suscription_duration”
which takes the same value as“subscription_duration” according to the max end
date, and that, for each customer. This is similar to a group by function in
sql. Anyone knows how to do that ? I tried this but it gave me weird results
because I didn’t group by customer reference : 'MRR-D Invoice
.'Subscription_duration'[BY max 'MRR-D Invoice '.'End_date' ] PS : End_date is a
dimension, Subscription_duration is an integer Customer_reference End_date
Subscription_duration Latest _subsciption_duration Customer A 24-Jan 3 3
Customer A 21-Jan 12 3 Customer A 23-Jan 4 3 Customer B 24-Feb 12 12 Customer B
23-Feb 12 12

01

11 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

18 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

20 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

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

 * 483 topics
 * 1313 Replies


JOB BOARD

 * 73 topics
 * 1 Reply


ANNOUNCEMENTS

 * 22 topics
 * 30 Replies



Welcome to the Pigment Community! 🎉




1 year ago


EVENTS CALENDAR

Apr
4
Webinar
Rock your workflows with Pigment
Show more


CUSTOMER LEADERBOARD

 * Week
 * All time

Show full leaderboard
1
abhilashsawla

3761 points

3761 points

2
CamilleMomo

3619 points

3619 points

3
Sofia Costa

2360 points

2360 points

4
A

Alexandre

2113 points

2113 points

5
MKohli

1782 points

1782 points

6
R

rschimm

1773 points

1773 points

7
C

Chelsea

1474 points

1474 points

8
E

Elodie

1415 points

1415 points

Show full leaderboard


BADGE WINNERS

 * Vikatzenhas earned the badge Pigment Modeling Fundamentals Certified
 * charles.louis-lucashas earned the badge Pigment Modeling Fundamentals
   Certified
 * michelfhas earned the badge Pigment Modeling Fundamentals Certified
 * Alexandre Jacobhas earned the badge Pigment Modeling Fundamentals Certified
 * michelfhas earned the badge Emerging Author

Show all badges


EMPLOYEE LEADERBOARD

 * Week
 * All time

Show full leaderboard
1
Benoit

5169 points

5169 points

2
Benji

4213 points

4213 points

3
Pierre

2652 points

2652 points

4
Ben

2105 points

2105 points

5
KarlW

2022 points

2022 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