community.pigment.com Open in urlscan Pro
2600:9000:214f:4000:10:8bf:5cc0:93a1  Public Scan

Form analysis
2 forms found in the DOM

GET /search/index

<form method="get" action="/search/index" data-bounded-context="Search">
  <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" data-bounded-context="Search"><span>
          <div class="algolia-search-container" aria-expanded="false" aria-owns="downshift-2-menu" 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" data-track-type="click keydown" data-element-name="Search input"
                  data-event-filter="enterKeydownFilter" 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__832623740" 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"> Enter your e-mail address </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="s2OsVgAUhl0o2OnGYFtn-tEnLjjhS3Kryev0zQ563MI">
</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 & Conversations570
      * Job Board82
      * Announcements29

 * Knowledge Base
    * 
    * * Search the Knowledge Base
      * Documentation
      * Getting Started23
      * Modeling & Formulas44
      * Functions107
      * Reporting & Data visualization40
      * Collaborating on Pigment21
      * Security & Permissions33
      * Importing and Exporting Data58
      * Test & Deploy5
      * Become a Pigment Pro
      * Modeling Principles7
      * Modeling Guides43
      * 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 ⭐

 * Introduction to Test & Deploy
 * 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
 * Create a Dependent Dropdown on a List


EXPLORE THE COMMUNITY

 * Recently Active
 * Help Others
 * Categories

D
dariousKeen Learner
asked in Questions & Conversations

FORMATE INPUT METRIC TO MATCH EXISTING METRICS


Hi Pigment Community, Hope you’re all doing well. I’m currently having a
formatting/metric structure issue and was wondering if anyone had a solution to
my problem. The current challenge I’m facing is that when I create a table using
2 existing metrics and 1 input metric, the format of my table follows the input
metric, when I would like it to follow the format of the existing metrics. To
further explain I have a list of managers and territories. Managers only operate
in one territory, so in a table manager A should only be seen under country X,
however I am seeing that Manager A is listed under Country A, B, C, etc...
Blocks: DIMENSION: Opp Owner Name METRIC: Revenue [$] Y-1 METRIC: Revenue [$]
Y-2 (no picture provided because its the same as Revenue [$] Y-1) METRIC: Yearly
Bookings [$] - Input - NBiz TABLE: Output Yearly Bookings ($) To help explain I
have attached images below that walk you through the issue I am facing. The
first image “Opp Owner Name” shows a dimension that has a

02
D
7 hours ago
MisbahBudding Pigmenteer
asked in Questions & Conversations

DYNAMIC VARIABLE NOT UPDATED PAGE SELECTORS


Is there a bug in Dynamic variable? I have a metric with Year format and This
year populates the actual months. When I apply this variable it doesn’t update
variable in page selectors instantaneously. Instead I have to wait for a minute
or two to see it get applied Or we need to refresh the browser url or
application in order for it to make work. Is this the intended behaviour or Am I
missing anything? Appreciate your responses! Thanks, Misbah

02

1 day ago
TatianaCommunity Manager
published in Announcements

🎊 CONGRATULATIONS TO OUR JULY 2024 PIGMENT ACADEMY CHAMPIONS! 🎊

Exciting news! Starting this month, we will be publishing updates on our Pigment
Academy champions to recognize their outstanding achievements and award the
Pigment Academy Badge 🏆 We’re excited to announce our top performers for the
month of July: 🏆 Top 5 Active Users by Course Completions: @Mikhail Luzhetskiy:
50 completions Brendan Cooke: 40 completions Sarah Guiettaf: 39 completions
@Rebecca Bai and @Martin Gros: 37 completions Daniel Lau - Aurora Solar: 34
completions Congratulations! Your hard work is truly inspiring. We're looking
forward to celebrating more achievements in the coming months!

2261

3 days ago
M

Moosa MalickNewly Minted Pigmenteer
asked in Questions & Conversations

SHARING CALENDAR DIMENSIONS


Hi community. Is it possible to add calendar dimensions e.g. Month from one
application, as widget in another applications board view? Cheers

01

3 days ago
A

AlinaBudding Pigmenteer
asked in Questions & Conversations

MAXIMUM CARDINALITY EXCEEDED WHEN USING CALCULATIONS


Hi, I was trying to use Calculations and faces maximum cardinality issue. I have
metrics for BoP, EoP and 2 metrics I need to add. So, the logic would be EoP =
BoP + Metric 1 + Metric 2 Each of them has 6 dimension, and unfortunately I
can’t get rid of any dimensions. We used the logic of where BoP = EoP {select
month -1] and EoP is calculated as previous month + Metric 1 + Metric 2 but we
faced formula timeout recently. Maybe anyone has any ideas how it can be solved?

12
A

3 days ago
MARCO_BMGNewly Minted Pigmenteer
asked in Questions & Conversations

ACCESS RIGHTS ON DATA LEVEL (ACTUAL VS FORECAST)


Hi Pigment community, I want to manage the edit rights in a Board, so that users
only can edit/add data for Forecast data and should not edit/override the
Actuals data . I created a Period Type metric: I added the Period Type to the
Year metric: I created a custom Access Rights Metric named “Forecast Rule” for
the Period Type and Year metric. I updated the access to Actual on Read / No
Write and to Forecast Read / Write for all users: I defined the rule so that it
should be applied to all metrics using these Dimensions ( I also tried with
“Period Type” only): I created a Board that shows my sales data for projects and
I still can edit/override the Actuals data in 2023: After reading the Knowledge
Base articles for managing Access rights, I tried many different things in my
configuration, but was not able to figure out the proper way. I also found no
other solution in the forum, so I would be happy if someone can help me
understand and solve this issue. Best regards,Marco

02

4 days ago
A

AlinaBudding Pigmenteer
asked in Questions & Conversations

SET UP NOTIFICATIONS WHEN LOAD HAPPENED


Is it possible to set up notification every time when the load automatically
happened from a native integration? Does it depend on the type of plan?

04
A

5 days ago
M

Maxim KudashkinEmployee
posted in Questions & Conversations

HOW TO FIX SPECIAL CHARACTERS IN YOUR NAME IN PIGMENT ACADEMY

Hello Pigment Community! If you’ve noticed that special characters (i.e. è or á)
in your name aren’t displaying correctly in Pigment Academy, here’s a quick and
easy fix: Login to Pigment Workspace: Start by logging into your Pigment
workspace. Access Account Settings: Click on your profile name in the bottom
left corner and select 'Account settings' from the menu options. Pigment -
Account Settings Update Your Name: Under the "My Profile" page, update your name
by adding a random character (e.g., a letter or a number) at the end. Settings -
My Profile Save Changes: Click 'Save changes' to update your profile. Remove the
Random Character: Once the changes are saved, go back and remove the previously
added character from your name. Save Changes Again: Click 'Save changes' once
more. This process will refresh your profile information and should resolve any
issues with special characters not displaying correctly in Pigment Academy. We
hope this helps! If you continue to experience issues,

30
M

7 days ago
Sharon ConroyCommunity Manager
published in Test & Deploy

UNDERSTAND TEST & DEPLOY FOR PIGMENT FEATURES

Here we give you a feature-by-feature breakdown of how T&D (Test & Deploy) works
in various areas of Pigment. In this article, we refer to source (Dev)
environment and target (Prod) environment, and we talk about managed and
unmanaged Applications. Managed Applications are the Applications in both the
Dev and the Prod environments and are managed by T&D. However, unmanaged
Applications refer to Applications that exist only in the Prod environment, and
therefore they’re not managed by the T&D process. What changes does T&D support?
Workspace-Level Features Security and Member Management Application-Level
Features Block-Level Features View-Level Features Imports, Automations &
Scenarios Related Information What changes does T&D support? Two main types of
changes are managed by T&D: Structural changes. We talk more about this here, or
if you need a refresher, see What are structural changes? Data changes. Although
data isn’t managed through T&D, the data changes we’re referring to

1510

10 days ago
Sharon ConroyCommunity Manager
published in Test & Deploy

PERFORM A DEPLOYMENT

When T&D (Test & Deploy) is set up on your Workspace, you’ll start making
changes and you’ll want to push those changes to your Production environment.
This is what we call a deployment. What is a deployment? Who can perform a
deployment? How to perform a deployment? What can prevent a Member performing a
deployment? Permission Issues References to Disconnected Items Deploy a Subset
of Changes Rollback a Set of Changes Related Information What is a deployment? A
deployment is the action of making your Prod environment structurally identical
to your Dev environment, by pushing changes made in Prod to Dev. Deployment in
T&D occurs in 2 steps: Both the Dev and Prod environments are compared, and a
list of all structural changes, or the changes supported by T&D, are displayed.
After you review the structural changes, you push those changes from Dev to
Prod. The deployment captures all changes made in any Application within the Dev
environment. The standard Enterprise plan on Pigment includ

1330

10 days ago
Show more activity
M

Moosa MalickNewly Minted Pigmenteer
asked in Questions & Conversations

SHARING CALENDAR DIMENSIONS


Hi community. Is it possible to add calendar dimensions e.g. Month from one
application, as widget in another applications board view? Cheers

01

3 days ago
A

AlinaBudding Pigmenteer
asked in Questions & Conversations

MAXIMUM CARDINALITY EXCEEDED WHEN USING CALCULATIONS


Hi, I was trying to use Calculations and faces maximum cardinality issue. I have
metrics for BoP, EoP and 2 metrics I need to add. So, the logic would be EoP =
BoP + Metric 1 + Metric 2 Each of them has 6 dimension, and unfortunately I
can’t get rid of any dimensions. We used the logic of where BoP = EoP {select
month -1] and EoP is calculated as previous month + Metric 1 + Metric 2 but we
faced formula timeout recently. Maybe anyone has any ideas how it can be solved?

12
A

3 days ago
MARCO_BMGNewly Minted Pigmenteer
asked in Questions & Conversations

ACCESS RIGHTS ON DATA LEVEL (ACTUAL VS FORECAST)


Hi Pigment community, I want to manage the edit rights in a Board, so that users
only can edit/add data for Forecast data and should not edit/override the
Actuals data . I created a Period Type metric: I added the Period Type to the
Year metric: I created a custom Access Rights Metric named “Forecast Rule” for
the Period Type and Year metric. I updated the access to Actual on Read / No
Write and to Forecast Read / Write for all users: I defined the rule so that it
should be applied to all metrics using these Dimensions ( I also tried with
“Period Type” only): I created a Board that shows my sales data for projects and
I still can edit/override the Actuals data in 2023: After reading the Knowledge
Base articles for managing Access rights, I tried many different things in my
configuration, but was not able to figure out the proper way. I also found no
other solution in the forum, so I would be happy if someone can help me
understand and solve this issue. Best regards,Marco

02

4 days ago
A

AlinaBudding Pigmenteer
asked in Questions & Conversations

SET UP NOTIFICATIONS WHEN LOAD HAPPENED


Is it possible to set up notification every time when the load automatically
happened from a native integration? Does it depend on the type of plan?

04
A

5 days ago
RasagyaNewly Minted Pigmenteer
asked in Questions & Conversations

MAX FUNCTION NOT WORKING ON PRIOR MONTHS


Hi all - I’m looking to calculate the maximum value of the last 3 months but
seem to be getting incorrect values with my current formula. Adding screenshots
below. Tried “MAX(Value, Value[select: Month - 1], Value[select: Month - 2])”
but it seems to be causing a mismatch in dimensionality somehow.

05

13 days ago
V

VKTRJust Arrived
asked in Questions & Conversations

HOW TO CHANGE THE SCALE OF Y-AXIS IN A COMBINED CHART?


Hi, I am trying to change the scale of the Y-axis on a combined chart, but am
not seeing the option of a “Fixed” scale. Interestingly, on a Secondary Y scale
this is possible (pls see below) In a separate discussion below, it was stated
that this should just be an issue with bar charts, but I cannot find the option
in the combined chart either. Thanks for the help!

01
K

19 days ago
MARCO_BMGNewly Minted Pigmenteer
asked in Questions & Conversations

DETAILED VIDEO INSTRUCTIONS FOR MODELING IN PIGMENT


Hi Pigment Community, I am a beginner in financial modeling and have a very
shallow learning curve in Pigment and often don't progress well. I have to
constantly look up tutorials and forums to do simple things that I often don't
fully understand. What would help me a lot would be a detailed video of a
project where the budget or forecast in Pigment is set up step by step and all
the steps in Pigment are explained. Especially modeling with dimensions,
transaction lists etc. is difficult for me without a lot of previous experience.
(E.g. which metrics do you basically need and how are they created from the raw
data?) Are there any such videos available? I haven't found any suitable
examples on YouTube or Google. Is there an overview page of all Pigment videos
from the Academy? That would also help a bit without always having to search in
the respective topic subpages. Thank you!M

03

20 days ago
L

laura.cNewly Minted Pigmenteer
asked in Questions & Conversations

PIGMENT WORKFLOW TO INPUT DIMENSION


Hello everyone, I know that automation/workflow needs to be designed with
Metrics but I would like some people to input a dimension (with Data Type
“Text”) and then select from several elements in several properties (each
property being of the Data Type “Dimension”). In the following example (which is
a Dimension), I want some employees to input the Name of the subject they will
be working on and then select the start date of the subject, the end date, link
is to a project, a product and an activity. I have absolutely no idea of how to
do that. Any tips? Many thanks Laura

03

20 days ago
G

gozseker1Just Arrived
asked in Questions & Conversations

CONDITIONAL NUMBER FORMATTING


Looking to toggle between whole $ numbers and %’s for budget driver values - I
would like to be able to set up any value between 0 and 1 to show up as e.g. 5%
vs 0.05, but the same metric also has $20,0000 type direct annual input amounts.
Is this possible?

02

25 days ago
M

MarieJNewly Minted Pigmenteer
asked in Questions & Conversations

EXPORT PIGMENT TO GOOGLE SHEET / EXCEL


Bonjour, Y’a t’il un moyen de conserver la mise un forme d’un tableau lors d’un
export via connecteur de Pigment vers Google Sheet ou Excel ? (A chaque fois
toute la mise en forme saute). Par ailleurs, est-il possible d’exporter des
graphs de la même manière ?

01

25 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
 * 8 Replies


QUESTIONS & CONVERSATIONS

 * 570 topics
 * 1561 Replies


JOB BOARD

 * 82 topics
 * 1 Reply


ANNOUNCEMENTS

 * 29 topics
 * 34 Replies



Welcome to the Pigment Community! 🎉




1 year ago



CUSTOMER LEADERBOARD

 * Week
 * All time

1
Bill in North Carolina

20 points

20 points

2
D
darious

15 points

15 points

3
Thu Mai

6 points

6 points

4
J

Jan Veerman Planadigm

5 points

5 points

5
Misbah

5 points

5 points

Show full leaderboard
1
CamilleMomo

5169 points

5169 points

2
abhilashsawla

3873 points

3873 points

3
Sofia Costa

2410 points

2410 points

4
A

Alexandre

2283 points

2283 points

5
R

rschimm

2152 points

2152 points

6
MKohli

1873 points

1873 points

7
CDALMAY

1824 points

1824 points

8
Sam Gale

1512 points

1512 points

Show full leaderboard


BADGE WINNERS

 * Bill in North Carolinahas earned the badge Emerging Author
 * Martin Groshas earned the badge Pigment Academy Champion
 * Rebecca Baihas earned the badge Pigment Academy Champion
 * Mikhail Luzhetskiyhas earned the badge Pigment Academy Champion
 * Alinahas earned the badge Emerging Chatterbox

Show all badges


EMPLOYEE LEADERBOARD

 * Week
 * All time

Show full leaderboard
1
Benoit

6078 points

6078 points

2
Pierre

3168 points

3168 points

3
Ben

2356 points

2356 points

4
KarlW

2330 points

2330 points

5
Keiran

1999 points

1999 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 E-mail address. We'll send you an e-mail with instructions to reset
your password.

Enter your e-mail address

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