community.pigment.com Open in urlscan Pro
2600:9000:214f:e200: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" 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__977200976" 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="qw26SgjeqD5n91F75FXyy_NDsP_Pubovw-6Vknbibi4">
</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 & Conversations546
      * Job Board82
      * Announcements26

 * Knowledge Base
    * 
    * * Search the Knowledge Base
      * Documentation
      * Getting Started23
      * Modeling & Formulas44
      * Functions106
      * Reporting & Data visualization40
      * Collaborating on Pigment21
      * Security & Permissions32
      * Importing and Exporting Data58
      * 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
 * Create a Dependent Dropdown on a List


EXPLORE THE COMMUNITY

 * Recently Active
 * Help Others
 * Categories

W

Weining BenSeasoned Pigmenteer
asked in Questions & Conversations

USER-DEPENDANT DROPDOWN LIST ON TABLE


Hi,We have a table, as below, used for assigning departments to employees.
Additionally, we have an ARM_department metric for managing users’ department
access right. I want users to see only the departments to which they have access
in the dropdown list (rather than all departments) to avoid mistakes. I know
that something can be set for Department dimension, but this would affect the
entire workspace, right? Is there a way to restrict it only in this table?
Thanks for any advice, Weining

00
W

13 minutes ago
M

MukulBudding Pigmenteer
asked in Questions & Conversations

HOW TO DYNAMICALLY SETUP HISTORICAL PERIOD BASED ON CURRENT DATE?


I have created a metric. Based on current date it will fetch the current month.
I have another metric for defining Historical period. I am trying to drive this
by above grid. However I am getting an error while applying the formula. What is
that I am missing or doing wrong. Please suggest the right logic

27

3 hours ago
RebeEmployee
posted in Community Welcome Guide

PIGMENT COMMUNITY GUIDELINES

Welcome to the Pigment Community! We are so happy to have you here! We are here
to create a space where Pigment users can share knowledge, learn, collaborate
and connect with one another. These Community Guidelines should not only help
you understand how to act within the community but also help you understand what
to expect from others in this space. Your participation here is subject to these
Guidelines. Be Respectful We are ALL Pigmenters! All of us come from diverse
backgrounds and we welcome that here in this forum, with that being said please
be committed to treating your fellow Pigmenters with the utmost kindness and
respect. This is a welcoming community of users (most importantly human beings)
and we must make it a priority to keep this forum a safe space where everyone
feels comfortable. No name-calling, offensive behavior, or bullying is allowed
EVER . Engage with the Community Our moderators will post helpful content but we
really want to learn and hear from you ! Take a lo

92

3 hours ago
Jared DolichBudding Pigmenteer
asked in Questions & Conversations

BEST PRACTICE QUESTION: LIST PROPERTY OR METRIC?


When mapping to address mismatched dimensions between source and target is there
a best practice to use a list property or metric? Seems to me the list property
is the better choice since it’s the obvious place to look which prevents
creating duplicates, which of course, can easily become out of sync. If list
property is the way to go are there any downsides? Thoughts?

11

3 hours ago
D

Dastan S.Just Arrived
asked in Questions & Conversations

FINDING THE SPECIFIC TEXT INSIDE A TEXT, BUT IN A REVERSE ORDER


I am trying to create a logic to extract part of a text. For example, here:
“41111 Revenue : Subscription : Platform” I want to transform the above text as:
“41111 - Platform”. The issue is, when I use FIND function to find “:” symbol,
it only returns the position if the first occurrence. But, I want to return the
position of the first occurrence from the end. I could use nested IFs to find
the first occurrence, slice the text, and find first occurrence from the sliced
text. However, some accounts have 3 and more “:” symbols: 51111 Cost of Revenue
: Subscription : Allocation In - Subscription : Allocation In - Sales &
Marketing Is there a way to locate the last occurrence of the text, instead of
the first?

01

3 hours ago
C

CindyJust Arrived
asked in Questions & Conversations

SEARCH UPDATE HISTORY BY BLOCK AND GL?


The update history is a fantastic feature. Recently my team had asked me to find
who changed something and it was very cumbersome having to comb through the
block when I’m looking for changes that ultimately impacted just one GL account.
Is there anything on the pipeline that would allow us to search by block by also
by GL?

00
C

9 hours ago
Isabella Leslie-MillerCommunity Manager
published in Community Welcome Guide

PIGMENT COMMUNITY RANK SYSTEM🎖️

On this page we outline how you can obtain specific ranks 🥇 Our ranks are
designed to award different kinds of contributing to the Community. We want to
ensure our members receive recognition for their activity and have something to
show for their efforts. Ranks are awarded automatically, with the most
prestigious rank you qualify for, being your rank. Name Criteria Just Arrived 1
Log-in Newly Minted Pigmenteer 1 Reply / 1 Post Budding Pigmenteer 5 Replies, 1
Like Received, 1 Post Seasoned Pigmenteer 10 Replies, 5 Likes Received, 3 Posts
Advanced Pigmenteer 50 Replies, 20 Likes Received, 10 Posts Expert Pigmenteer
100 Replies, 50 Likes Received, 25 Posts Occasional Observer 25 Log-ins, 5 Likes
Given Frequent Reader 50 Log-ins, 10 Likes Given Keen Learner 100 Log-ins, 25
Likes Given Pigment Academic 250 Log-ins, 100 Likes Given Pigment Professor 500
Log-ins, 250 Likes Given Genius 100 Replies, 15 Answers, 20 Posts Mastermind 200
Replies, 30 Answers, 50 Posts

71561

21 hours 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?

01

2 days ago
K

KevinSeasoned Pigmenteer
asked in Questions & Conversations

ASSIGNING DIMENSION TO METRIC CALCULATION


I have various forecasts and weights that are derived in different models and
need to piece together a daily forecast. Long story short, what I have below is
the daily forecast but is set up by the date the week starts and the day of the
week. I need to “convert” that all into one metric with just the day dimension.
I have created another metric that has the same dimensions but the result is
itself the day dimension. And so what I want to do is somehow assign the values
in the first metric to the day dimension in the second metric. The block is
fully aligned but I am not sure how to code this properly. I’ve played around
with the BY modifier but I just can’t seem to get this working. I10[BY CONSTANT:
I11] Any sort of modifiers I throw on just give me one row for the day of the
week. Any tips you have would be greatly appreciated. Thank you

01
K

3 days ago
PierreCommunity Manager
published in Modeling & Formulas

ITERATIVE CALCULATION & CIRCULAR REFERENCING

A common modeling need when building a Pigment Application is to have an
iterative calculation. An iterative calculation in Pigment is where a formula
iterates over all the items in a Dimension, performing a specified calculation
on each item in sequence. To support iterative calculations, Pigment provides
two functions: PREVIOUS(). To create an iterative calculation while referencing
the same metric. PREVIOUSBASE (). To create an iterative calculation while
referencing another metric. About Block-Level Circular Dependencies Multiple
Block Circular Dependency Single Block Circular Dependency Single Block
Iterative Calculation Examples of how to use the PREVIOUS function Dynamic
Offset Limitations When Using PREVIOUS Multi-Block Iterative Calculation Concept
Create an Iterative Calculation Further Information About Block-Level Circular
Dependencies The Pigment modeling engine computes Blocks in sequence, meaning
one after the other. Each time a Block is updated, all of its dependent Blo

6770

3 days ago
Show more activity
W

Weining BenSeasoned Pigmenteer
asked in Questions & Conversations

USER-DEPENDANT DROPDOWN LIST ON TABLE


Hi,We have a table, as below, used for assigning departments to employees.
Additionally, we have an ARM_department metric for managing users’ department
access right. I want users to see only the departments to which they have access
in the dropdown list (rather than all departments) to avoid mistakes. I know
that something can be set for Department dimension, but this would affect the
entire workspace, right? Is there a way to restrict it only in this table?
Thanks for any advice, Weining

00
W

13 minutes ago
Jared DolichBudding Pigmenteer
asked in Questions & Conversations

BEST PRACTICE QUESTION: LIST PROPERTY OR METRIC?


When mapping to address mismatched dimensions between source and target is there
a best practice to use a list property or metric? Seems to me the list property
is the better choice since it’s the obvious place to look which prevents
creating duplicates, which of course, can easily become out of sync. If list
property is the way to go are there any downsides? Thoughts?

11

3 hours ago
D

Dastan S.Just Arrived
asked in Questions & Conversations

FINDING THE SPECIFIC TEXT INSIDE A TEXT, BUT IN A REVERSE ORDER


I am trying to create a logic to extract part of a text. For example, here:
“41111 Revenue : Subscription : Platform” I want to transform the above text as:
“41111 - Platform”. The issue is, when I use FIND function to find “:” symbol,
it only returns the position if the first occurrence. But, I want to return the
position of the first occurrence from the end. I could use nested IFs to find
the first occurrence, slice the text, and find first occurrence from the sliced
text. However, some accounts have 3 and more “:” symbols: 51111 Cost of Revenue
: Subscription : Allocation In - Subscription : Allocation In - Sales &
Marketing Is there a way to locate the last occurrence of the text, instead of
the first?

01

3 hours ago
C

CindyJust Arrived
asked in Questions & Conversations

SEARCH UPDATE HISTORY BY BLOCK AND GL?


The update history is a fantastic feature. Recently my team had asked me to find
who changed something and it was very cumbersome having to comb through the
block when I’m looking for changes that ultimately impacted just one GL account.
Is there anything on the pipeline that would allow us to search by block by also
by GL?

00
C

9 hours 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?

01

2 days ago
M

matt.tafesseJust Arrived
asked in Questions & Conversations

ADD 'PREVIOUS' FUNCTION TO EQUATION


Hello - I’m looking to add a previous function to the below equation “if('Is
Forecast?',('Go Forward Cohort'[select:'Go Forward LTV Driver'."Borrower
Retention"][BY:->'Map to Cohort Month']),(('2.002 Cohort View - Borrower
Retention Lookup')))” I believe this formula works similar to excel where the
data is either coming from the ‘Go Forward Cohort Metric’ or the ‘Cohort View
Metric’ depending on the ‘Is Forecast’ boolean. I want the previous function to
pull the last row of data thats a result of the if statement. Thanks in advance

00
M

5 days ago
N

NipsaJust Arrived
asked in Questions & Conversations

VERSION LOCKING


Hi Team, We have a requirement of locking our Versions for any more inputs. Do
we have Version Locking capability or Cellular Level Access restriction
capability in Pigment? Any leads will be appreciated. Thanks, Nipsa

02

6 days ago
OlaBudding Pigmenteer
asked in Questions & Conversations

ISSUES WITH TIME AGGREGATIONS


I have a board with year as a filter on top of the board and it is possible to
select multiple years in this filter. On my board I also have a KPI that should
show outgoing HC for the last month based on the selected years. When I look at
my data with Years on the rows it looks like the picture below when I use “Last”
as time aggregator. However when I remove years from the rows all values are
blank. If I change the time aggregator to “Last Non Blank” it shows me values,
but the problem is that “Last Non Blank” doesn’t always give me the values for
dec in the last year, it returns the cells shown in the second picture below. It
feels like a bug that the cells are blank when using “Last” as aggregator in
this case or am I doing something wrong?

13
T

7 days ago
M

matt.tafesseJust Arrived
asked in Questions & Conversations

IF STATEMENT DETERMINED BY BOOLEAN


Hello - I am trying to update a formula based on a boolean that is determined by
the latest date in a data upload. I believe the following equation is close to
what I need. Formula: “if('Is Forecast?','Go Forward Cohort'[select:'Go Forward
LTV Driver'."Borrower Retention"][BY:->'Map to Cohort Month'] , if('Is
Actual?',('2.002 Cohort View - Borrower Retention Lookup')[remove lastnonblank:
Month][remove lastnonblank: Cohort][ADD: Cohort]))” There are two issues:1. I
want to add a previous function to the first part of the if statement. If there
is no data to pull from the “go forward cohort metric” I want the function to
pull the last data point there is 2. When updating to the above formula my
application will time out. Is there a more efficient formula that will prevent
this? Thank you!

21

19 days ago
A

AabhiiJust Arrived
asked in Questions & Conversations

PIGMENT TO AZURE EXPORT 404 ERROR


Hi all, I am trying to export data in a given metric to azure data factory. I am
following the guide in the pigment documentation exactly, however when i go to
pull the data, I get a 404 error. I have set up the export keys and I am using
the correct applicationID and the correct metricID. Any insights into what else
I may be missing would be great. Thank you

11

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
 * 4 Replies


QUESTIONS & CONVERSATIONS

 * 546 topics
 * 1495 Replies


JOB BOARD

 * 82 topics
 * 1 Reply


ANNOUNCEMENTS

 * 26 topics
 * 33 Replies



Welcome to the Pigment Community! 🎉




1 year ago



CUSTOMER LEADERBOARD

 * Week
 * All time

1
Jared Dolich

60 points

60 points

2
Thu Mai

30 points

30 points

3
MARCO_BMG

30 points

30 points

4
W

Weining Ben

20 points

20 points

5
C

Cindy

20 points

20 points

6
M

Mukul

10 points

10 points

7
sethbradley

10 points

10 points

8
S

Stefano Leone

10 points

10 points

Show full leaderboard
1
CamilleMomo

4888 points

4888 points

2
abhilashsawla

3853 points

3853 points

3
Sofia Costa

2390 points

2390 points

4
A

Alexandre

2233 points

2233 points

5
R

rschimm

2132 points

2132 points

6
MKohli

1873 points

1873 points

7
Sam Gale

1502 points

1502 points

8
C

Chelsea

1474 points

1474 points

Show full leaderboard


BADGE WINNERS

 * MARCO_BMGhas earned the badge Innovator
 * Matt Dhas earned the badge Chatterbox
 * Rishi Kumarhas earned the badge Read and Interpret Formulas Certified
 * esheinhas earned the badge Pigment Modeling Fundamentals Certified
 * Jared Dolichhas earned the badge Emerging Author

Show all badges


EMPLOYEE LEADERBOARD

 * Week
 * All time

1
Pierre

30 points

30 points

2
Carole

11 points

11 points

3
Mat

1 point

1 point

4
Benoit

1 point

1 point

Show full leaderboard
1
Benoit

5929 points

5929 points

2
Pierre

2978 points

2978 points

3
KarlW

2248 points

2248 points

4
Ben

2216 points

2216 points

5
Keiran

1893 points

1893 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