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

Submitted URL: http://community.gopigment.com/?wp-verify-link
Effective URL: https://community.gopigment.com/?wp-verify-link
Submission: On February 12 via api from DE — Scanned from DE

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: forgotPasswordPOST /member/forgotPassword

<form name="forgotPassword" method="post" action="/member/forgotPassword" class="form js-ajax-form--forgot" id="form--forgot__445265833" 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="Q5i-2o5Ltqv8KZCaVKCyEhIfWIQKkNmJZng7t03x9wY">
</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 & Conversations454
      * Job Board67
      * Announcements22

 * Knowledge Base
    * 
    * * Search the Knowledge Base
      * Documentation
      * Getting Started23
      * Modeling & Formulas40
      * Functions100
      * Reporting & Data visualization36
      * Collaborating on Pigment18
      * Security & Permissions27
      * Importing and Exporting Data53
      * Legal information1
      * Become a Pigment Pro
      * Modeling Principles7
      * Modeling Guides41
      * 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

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.

00
R

2 days ago
Y

YaejisNewly Minted Pigmenteer
asked in Questions & Conversations

SAVING CALCULATION


Hi! Can someone please help with setting up the formula for below? Thanks in
advance! ---- Dates: Given Data (yellow highlighted) Question: I am seeing for
formula to get the result below yellow highlighted row, “Result”. The
calculation starts from 3rd months from the start date, 10/31/2022. So it needs
to calculate “January value 18,792 minus start date value 18,792. The result for
2023 Jan is zero. Then, calculation is same concept but moves forward. It’s
always deducting the start date value, 18,792. For July 2023, calculation is
July 2023 19,355 minus the start date value 18,792, resulting 564. The
calculation should stop in Bridge end date, 12/31/2023. Thank you!

13
Y

2 days ago
P

PaylwardNewly Minted Pigmenteer
asked in Questions & Conversations

DEMO IDEAS


Hello, I have gone through all of the available training and videos for Pigment
modules and setting up Demos. I would like to know if there are any additional
Demo resources and data I can use to test my skills.

22

3 days ago
BenjiCommunity Manager
published in Job Board

THE FP&A JOBS REPORT #70 (CIRCLE, TIDE, OPENAI...)

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 [FINANCIAL SERVICES] Head of Strategic Finance
📍LA/NY, US Circle helps businesses and developers harness the power of
stablecoins for payments and internet commerce worldwide. [FINANCIAL SERVICES]
FP&A Director 📍London, UK Tide is a financial technology company that provides
business banking services tailored for small and medium-sized enterprises
(SMEs). Head of FP&A 📍Uusimaa, FI Finatal is a UK-based recruitment consultancy
firm specialising in finance and accounting roles within the private equity and
venture capital sectors. [MANUFACTURING] Head of FP&A 📍Augsburg, DE KUKA is one
of the world’s leading suppliers of intelligent automation solutions, offering
customers everything they need from a single source. Hiring? Submit a job! Other
Roles [FINANCE SERVICES] Strategic Finance Manager 📍London, UK Zilch i s

1160

3 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

3 days ago
C

Carolina LeeBudding Pigmenteer
asked in Questions & Conversations

BALANCE SHEET: NET INCOME


Which formula can I use for Net Income at my balance sheet in the begging of the
year where I need to transfer all Net income to Retained earnings / losses and
start accumulate again? See below an example. I read this article below but I
couldn’t understand:

14
P

3 days ago
M

mmusabSeasoned Pigmenteer
asked in Questions & Conversations

REPEATING SET OF VALUES UNTIL THE A CERTAIN CONDITION


Hi Team I have a calc which uses Year dimension and the year starts from 1 to
20. There is an assumption metric which defines what year the crops will be
harvested. So lets say currently the assumption is year 6 in which the crops
will be harvested, then from that year onward second rotation will start and
then follow similar process until Year 6 where it again will be harvested and
planted again. So as an example in excel, you can see from FY19 the year starts
as 0 as that is where initial plantation happen. Then it counts from Year 1 to 6
and then at Year 6 which is equal to our assumption metric (Year 6) as well, it
stops and then a new cycle starts from 0 to 6 all over again. How can we built
something like this easy way? I have tried thinking of using MOD in which lets
say in our Year dimension, we have count column as well that goes from 1 to 20 .
So what i am doing is saying if Year.Count/Assumption metric =0, then mark it as
harvest year. Now how can i get it to count and reset

01

4 days ago
P

ParapebuneNewly Minted Pigmenteer
asked in Questions & Conversations

HOW TO CREATE A WEIGHTED DISTRIBUTION


Hi! I have a sales volumes metric with dimensions Category, Channel, Product and
Month. Data was imported from a transaction list. I want to adjust this with
some volumes that are manually input by user per channel, but I want to spread
this values on every product using the same weighted distribution per category
and month as the initial data. For example, if on month Jun, on a product, the
volume was 15% of the total, I want to add on that product for Jun 15% of the
manually added volume. How do I achieve that? Thanks in advance!

01
S

4 days ago
SyuenCommunity Manager
published in Functions

IFDEFINED FUNCTION

Description Fills the defined values of an expression with a given value. Syntax
IFDEFINED(Expression containing values, Value if defined, Value if blank )
Arguments Argument Type Description Expression containing values (required) Any
Expression containing Values. Value if defined (required) Any Expression
containing value you want to fill if the argument Expression containing values
contains values. This needs to be the same type as the argument Value if blank.
Value if blank (optional) Any Expression containing the value you want to fill
if the argument Expression containing values contains no values (BLANK). This
needs to be the same type as the argument Value if defined. This is an optional
argument, so if no value is provided for this argument, it returns BLANK.
Returns Type Output Structure (Dimensions) Same type as Value if defined / Value
if blank All Dimensions in the arguments Expression containing values, Value if
defined, Value if blank. Examples Formula Result Description

1490

4 days ago
M

Moosa MalickNewly Minted Pigmenteer
asked in Questions & Conversations

REMOVING BLANKS IN TRANSACTIONS LIST


Hi, Is there a way to remove blank cells in the grid of a transactions list. I
am applying a filter to the transactions list which gives me blank rows which I
want to get rid of. Thanks

04
M

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

00
R

2 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

3 days ago
M

mmusabSeasoned Pigmenteer
asked in Questions & Conversations

REPEATING SET OF VALUES UNTIL THE A CERTAIN CONDITION


Hi Team I have a calc which uses Year dimension and the year starts from 1 to
20. There is an assumption metric which defines what year the crops will be
harvested. So lets say currently the assumption is year 6 in which the crops
will be harvested, then from that year onward second rotation will start and
then follow similar process until Year 6 where it again will be harvested and
planted again. So as an example in excel, you can see from FY19 the year starts
as 0 as that is where initial plantation happen. Then it counts from Year 1 to 6
and then at Year 6 which is equal to our assumption metric (Year 6) as well, it
stops and then a new cycle starts from 0 to 6 all over again. How can we built
something like this easy way? I have tried thinking of using MOD in which lets
say in our Year dimension, we have count column as well that goes from 1 to 20 .
So what i am doing is saying if Year.Count/Assumption metric =0, then mark it as
harvest year. Now how can i get it to count and reset

01

4 days ago
P

ParapebuneNewly Minted Pigmenteer
asked in Questions & Conversations

HOW TO CREATE A WEIGHTED DISTRIBUTION


Hi! I have a sales volumes metric with dimensions Category, Channel, Product and
Month. Data was imported from a transaction list. I want to adjust this with
some volumes that are manually input by user per channel, but I want to spread
this values on every product using the same weighted distribution per category
and month as the initial data. For example, if on month Jun, on a product, the
volume was 15% of the total, I want to add on that product for Jun 15% of the
manually added volume. How do I achieve that? Thanks in advance!

01
S

4 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

10 days ago
P

ParapebuneNewly Minted Pigmenteer
asked in Questions & Conversations

MANUAL INPUT BOARD


Hi! I have a numeric metric of volumes of selling items with dimensions: item,
channel, category, month For this metric I have some volumes imported from a
transaction list. Apart of these volumes I want to use an input board which
allows me to manually input extra volumes per item/channel/category/month which
will finally add to the imported volumes. In the board, the input widget should
show all the items that were manually input and should have the option to input
a new volume based on the dimension selection. How do I do that? Thanks in
advance!

05

10 days ago
J

JoseBudding Pigmenteer
asked in Questions & Conversations

GETTING THE SEASONALITY FOR FORECAST_ETS FUNCTION


Dears, I have the historic sales per month, and we have strong seasonality, but
also and upward trend. I would like to use the FORECAST_ETS function, however, I
don’t understand how to get the value of seasonality. For example I know every
July and August we have a drop and then it gets higher on September. In this
case the seasonality would be 12? If I want something more exact can I use
Python and then get the equation and plug in pigment? For calculating a better
seasonality number, alpha, beta and gamma, is there a way to get those numbers
in Pigment, or I need to have another application, such as Python or R? Thanks
in advance! Jose

02

12 days ago
M

Mart.Just Arrived
asked in Questions & Conversations

CREATING A DIMENSION LIST AND TRANSACTION LIST


How do I create a dimension list (step by step process), How do we know what
fields would be a dimension, for example, would a product type classified as
text or dimension? or customer classification (New/Existing) be a text or
dimension.Also, how does this feed to the transaction list, when importing a csv
file.When the transaction list is then created, how do I create metrics, chart
and tables from this transaction list.

01

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

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

 * 454 topics
 * 1233 Replies


JOB BOARD

 * 67 topics
 * 1 Reply


ANNOUNCEMENTS

 * 22 topics
 * 30 Replies



Welcome to the Pigment Community! 🎉




10 months ago


EVENTS CALENDAR




CUSTOMER LEADERBOARD

 * Week
 * All time

Show full leaderboard
1
abhilashsawla

3721 points

3721 points

2
CamilleMomo

3243 points

3243 points

3
Sofia Costa

2320 points

2320 points

4
A

Alexandre

2062 points

2062 points

5
MKohli

1772 points

1772 points

6
R

rschimm

1713 points

1713 points

7
C

Chelsea

1474 points

1474 points

8
agnar

1318 points

1318 points

Show full leaderboard


BADGE WINNERS

 * Jan Kolarhas earned the badge Pigment Modeling Fundamentals Certified
 * Patriciahas earned the badge Pigment Modeling Fundamentals Certified
 * bmilikhas earned the badge Pigment Modeling Fundamentals Certified
 * Nikita Pohas earned the badge Pigment Modeling Fundamentals Certified
 * Leshas earned the badge Pigment Modeling Fundamentals Certified

Show all badges


EMPLOYEE LEADERBOARD

 * Week
 * All time

Show full leaderboard
1
Chris

11015 points

11015 points

2
Benoit

5065 points

5065 points

3
Benji

3651 points

3651 points

4
Pierre

2631 points

2631 points

5
Ben

2039 points

2039 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