community.pigment.com Open in urlscan Pro
2600:9000:214f:6e00: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__1241456979" 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="SglSt2YTTt1F2Y59NSkhpex7HqtTvMo6a_v9OBIYQos">
</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 & Conversations538
      * Job Board82
      * Announcements26

 * Knowledge Base
    * 
    * * Search the Knowledge Base
      * Documentation
      * Getting Started23
      * Modeling & Formulas43
      * Functions106
      * Reporting & Data visualization40
      * Collaborating on Pigment21
      * Security & Permissions31
      * Importing and Exporting Data57
      * 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!




🚧 WE'RE UNDERGOING SOME MAINTENANCE! 🚧

Some links and images are not displaying correctly in articles - we’re working
hard to get these updated and showing correctly again. Thanks for your patience!


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

M

MukulNewly Minted 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

13

52 minutes 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

16 hours ago
abhilashsawlaPigment Academic
asked in Questions & Conversations

HOW CREATE CURRENT DATE MATRIC, WHICH FETCH CURRENT DATE AUTOMATICALLY?


I want same feature like Today() in Excel.

89
M

1 day ago
C

ChediNewly Minted Pigmenteer
asked in Questions & Conversations

TEXT FUNCTION TO REMOVE MULTIPLE PARENTS FROM A LEVEL 0 SUB-ACCOUNT IN GL
METADATA


Hi. I’m new to Pigment so hoping someone has solved this problem before. Has
anyone been able to parse out the rightmost X number of characters that appear
after any number of colons in a dimension member? e.g. [60001 Personnel Costs :
XYZ : ABC: Salaries and Wages] should return [60001 - Salaries and Wages], where
XYZ and ABC are illustrative of potential sub-accounts that need to be removed.

22
C

3 days ago
M

MukulNewly Minted Pigmenteer
posted in Questions & Conversations

BILLS OF MATERIALS MANAGEMENT IN SUPPLY CHAIN USE CASE.

Hi , I am looking to figure out a solution for BOM Management in Pigment.
Background: I have 2 columns in source data, one for parent and one for
children. I want to create a hierachy using these 2 columns. The catch here is,
parent can be a children or children can be a parent. Let me know if anyone is
interested to work on this challenge with me.

04
M

3 days ago
K

KevinSeasoned Pigmenteer
asked in Questions & Conversations

READER ROLE - CAN'T VIEW BOARDS


I have created a group and have added members with access to a handful of
applications. For the time being, I have assigned them the reader role. However,
I can not get them to see the boards. The screenshot below is from me
impersonating one of the users. I’m stuck on what to do next. Do I need to go
through and change permissions to each of the boards? Or even each of the
blocks? Is there a quick way to have them see the boards? Do I need to edit the
reader role and change permissions there? I have read through several articles
and I can’t match the instructions to my workspace. Any help or insights would
be much appreciated. Kevin

24
K

5 days ago
C

connorsmithBudding Pigmenteer
posted in Questions & Conversations

SELECT MODIFIER WITH DYNAMIC OFFSET

Hello! The SELECT modifier can be used to Offset a dimension (ex. SELECT: Month
- 1), but is it possible to assign different Offset amounts based on one of a
dimension of the Metric? Here is the example I am stuck at now: I am trying to
assign specific Offset amounts to a metric (0. UFR - Live) based on the Customer
Payment Term dimension (ex. For any data in the Net 30 → 1 month offset, Net 60
→ 2 month offset, etc) Ideally I could assign an Offset Integer as a Property of
the Customer Payment Term dimension and that would determine the Offset (ex.
[SELECT: Month - ‘Customer Payment Term’.’Offset Integer’] Is there a better and
more sustainable approach rather than a massive nested IF statement? Thank you!

24

5 days ago
M

MohanNewly Minted Pigmenteer
asked in Questions & Conversations

EXTRACT DAY FROM A DATE IN TEXT FORMAT


Hello, I have a Date field called “Delivery Date” (Ex : 10/06/2024). From here,
I want to extract the day of the week in text format (Example :10/06/2024 is
“Monday”) and my calculated field should show similar to the example here. I
tried WEEKDAY(‘Delivery Date’) and it returns day of the week but in number
format and I tried again TEXT(WEEKDAY(‘Delivery date”), again it does not work.
How to convert weekday into Text format like Mon,Tue,etc…? thanks Mohan

13
M

5 days ago
OlaBudding Pigmenteer
asked in Questions & Conversations

FORECAST_ETS VS SEASONAL_LINEAR_REGRESSION


Could anyone provide some guidance on when to use the function
SEASONAL_LINEAR_REGRESSION over FORECAST_ETS? In our specific case we have a
metric with a yearly seasonality and the overall trend for the metric is going
slightly downwards. We would like to use our actuals data to automatically
calculate values for all forecast months. I can see that both functions gives me
reasonable values for my forecast, but FORECAST_ETS gives me a clearer trend
downwards while SEASONAL_LINEAR_REGRESSION gives me more flat forecast. So my
question is really, which one would make most sense to use in our case and why?

21

7 days ago
K

kristian.bartelNewly Minted Pigmenteer
posted in Questions & Conversations

CREATING AN APPLICATION GUIDE, BOARD/BLOCK STRUCTURES

Hi all, Curious to see how people have approached (1) creating an application
guide for new users (specifically something to quick start leaders that don’t
necessarily have the time to go through more in-depth tutorials), and (2)
board/block structure. I know there’s some documentation on board/block
structure, but just curious to get some more context on how people approach it,
particularly for revenue focused planning. Thanks!

00
K

9 days ago
Show more activity
M

MukulNewly Minted 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

13

52 minutes 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

16 hours ago
OlaBudding Pigmenteer
asked in Questions & Conversations

FORECAST_ETS VS SEASONAL_LINEAR_REGRESSION


Could anyone provide some guidance on when to use the function
SEASONAL_LINEAR_REGRESSION over FORECAST_ETS? In our specific case we have a
metric with a yearly seasonality and the overall trend for the metric is going
slightly downwards. We would like to use our actuals data to automatically
calculate values for all forecast months. I can see that both functions gives me
reasonable values for my forecast, but FORECAST_ETS gives me a clearer trend
downwards while SEASONAL_LINEAR_REGRESSION gives me more flat forecast. So my
question is really, which one would make most sense to use in our case and why?

21

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

12 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

13 days ago
G

Gabriel OrtizNewly Minted Pigmenteer
asked in Questions & Conversations

EXCEL CONNECTOR AND DATE FORMAT


Hello Pigment community, I am trying to use the excel connector for Pigment and
I have realized that when pulling the data the dates are formatted as text. When
I change the format to date and I pull the data again it reverts to the text
format. Is there a solution to this limitation? Thank you in advance, Gabriel
Ortiz

11
W

13 days ago
R

Rahul KumarNewly Minted Pigmenteer
asked in Questions & Conversations

R&D CAPITALIZATION SCHEDULE


Hi All, I am trying to create a R&D cost Capitalization schedule and need some
help. Essentially which I am trying to do is spread the cost over 3 years but
then add the incremental monthly amount as well. For example: If Jan 2024, my
R&D cost is $1200 and $2400 for Feb, then I should see $100 (1200 / 12) for Jan
2024 till Dec 2024 and for Feb cost, it should be $300 ($2400/12 + 100). I hope
i am clear in my ask. Thanks

01

17 days ago
C

connorsmithBudding Pigmenteer
asked in Questions & Conversations

"FAILED TO ACQUIRE A SHARED LOCK DURING METRIC CREATION" ERROR MESSAGE


I have recently been getting the following error message semi frequently:“Failed
to acquire a shared lock during metric creation” It is mostly happening when I
am trying to edit P2P imports (ie. within a Metric, click Import Data, click
Edit on an existing import configuration) Anyone know what this means?

01
M

23 days ago
M

MarieJNewly Minted Pigmenteer
asked in Questions & Conversations

FORMULA TIMED OUT DUE TO DIMENSION LIST TOO LONG


Bonjour, Je suis face à une difficulté et le message d’erreur ‘Formula timed
out’ sur mon P&L; J’ai un metric qui calcule mon Budget P&L à partir de
plusieurs sources (Revenue, Coût, HR, etc.) ; j’aimerais créer un autre metric
reprenant le P&L avec une dimension en plus (une dimension Fournisseur présente
uniquement sur les coûts) ; grâce à laquelle je peux voir mes coûts à la
granularité fournisseur directement dans le P&L. J’ai donc modifié la structure
du metric (en rajoutant la dimension fournisseurs, et modifié la formule avec
des ADD sur les autres metrics alimentant cette dernière) ; néanmoins je retombe
systématiquement sur un message formula timed out > 3 minutes. Je suppose que
c’est lié à ma liste fournisseur (qui est longue) , mais je ne vois pas comment
faire pour optimiser la formule ?

21

26 days ago
B

BenedikteNewly Minted Pigmenteer
asked in Questions & Conversations

ERROR DURING FORMULA COMPUTATION. SOME VALUES OVERFLOWS 10^14


Hi, I have been getting this error message in my formulas, and need some help to
solve this, anyone that have knowledge of this error? Thank you very much in
advance! Regards,Benedikte

14
B

26 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

 * 538 topics
 * 1484 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
Thu Mai

26 points

26 points

2
M

Mukul

15 points

15 points

3
K

Kevin

10 points

10 points

4
David Mandl

10 points

10 points

5
L

Laura Veronica

1 point

1 point

6
T

Tri Le

1 point

1 point

Show full leaderboard
1
CamilleMomo

4868 points

4868 points

2
abhilashsawla

3822 points

3822 points

3
Sofia Costa

2390 points

2390 points

4
A

Alexandre

2223 points

2223 points

5
R

rschimm

2112 points

2112 points

6
MKohli

1863 points

1863 points

7
Sam Gale

1502 points

1502 points

8
C

Chelsea

1474 points

1474 points

Show full leaderboard


BADGE WINNERS

 * Thu Maihas earned the badge Emerging Helper
 * Justinhas earned the badge Read and Interpret Formulas Certified
 * Jamie Whas earned the badge Read and Interpret Formulas Certified
 * Jamie Whas earned the badge Pigment Modeling Fundamentals Certified
 * NathanCullhas earned the badge Partner Solution Consultant Certified

Show all badges


EMPLOYEE LEADERBOARD

 * Week
 * All time

Show full leaderboard
1
Benoit

5873 points

5873 points

2
Pierre

2867 points

2867 points

3
KarlW

2248 points

2248 points

4
Ben

2216 points

2216 points

5
Keiran

1873 points

1873 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