community.pigment.com Open in urlscan Pro
2600:9000:214f:fe00: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"><button type="submit" aria-label="Enter" class="search-box__submit" data-toggle="button"><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><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" id="downshift-2-input"><button type="reset" aria-label="Clear search" class="search-box__reset" data-toggle="button" 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__1972026868" 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="rr5eGNjKlvyMnfO1Cxdx8NHKGCSKW0hwurB808XJPSA">
</form>

Text Content

Skip to main 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 & Conversations627
      * Job Board82
      * Announcements33

 * Knowledge Base
    * 
    * * Search the Knowledge Base
      * Documentation
      * Getting Started21
      * Modeling & Formulas43
      * Functions108
      * Reporting & Data visualization41
      * Pigment AI4
      * Collaborating on Pigment21
      * Security & Permissions35
      * 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

OlaFrequent Reader
asked in Questions & Conversations
Trigger import through API without sending data


Is it possible to trigger an import from Netsuite, Amazon S3 or Salesforce using
Pigment’s API? So in this case we don’t want to send the data in the request
body, we just like to trigger an existing import using the API instead of having
the import to run on a schedule. Just want to confirm if this is supported or
not, can’t really tell by reading the documentation here:

01

16 hours ago
C

CindyNewly Minted Pigmenteer
asked in Questions & Conversations
Create a Metric off Transaction Table to sum by period but filter by load date


Hello. I have imported a transaction list into Pigment that has two date
dimensions. One is “Month” and is = to an accounting period. The second date
dimension is the “Load Date” added automatically during the import. Each month,
I will append to the data list so at the end, this list could have GL data by
period for each load month. I am able to sum the data by period OR by load month
but I’m not able to say which load I want to use. My current formula is like
this: '02. Test Pivoted Push'.Amount[BY SUM: '02. Test Pivoted Push'.Department,
'02. Test Pivoted Push'.'GL Account', '02. Test Pivoted Push'.Month, '02. Test
Pivoted Push'.Subsidiary, '02. Test Pivoted Push'.Vendor] I want to add in a
condition where the results will be based on which load month is selected
(something like ]'02. Test Pivoted Push'.'Load Date'= Set_Last_Opex_Push_Month]
where ‘Set_Last_Opex_Push_Month’ will be determined by me.

01

17 hours ago
D

Dastan S.Newly Minted Pigmenteer
asked in Questions & Conversations
Calculation with Aggregations


Hi Pigment community, I am trying to calculate our revenue per employee metric.
The metric should show Rev/FTE by month, and then, when aggregated by quarter,
it should take the total revenue for the quarter and divide it by average
monthly employees. The issue is that, for quarter it is summing up the total
employees instead of taking average. This is what I am getting in Pigment, for
instance: But what I want is the following: I tried showing “Total Revenue” as %
of metric “Employees”, but even there it is still taking the sum of 3 months
employees. I created table with Quarter dimension only, which fixes this, but I
wanted to have months there too.

12
D

2 days ago
RoryCCommunity Manager
published in Pigment AI
Features Supported by the Data Assistant

Most of what you see in Views can be produced by the Data Assistant using simple
commands. At present, the Data Assistant does not support the following: Queries
on Lists and Tables Queries on Snapshots Custom aggregators (including average)
Sorting by Dimension property Pivoting Dimensions’ Rows and Columns Combined
charts Complex calculations Application variables Formatting Learn More Queries
on Lists and Tables If you have key information stored in Lists, consider
creating Metrics from that data so the AI can answer queries on it. For example:
you have a Dimension List that contains prospects over time your Members want to
know total prospects at year-end you create a dedicated Metric “Prospects count”
that counts up the number of prospects per Month from your List, and set it as
AI-accessible the Data Assistant fetches your Metric even though the source data
is in a List Queries on Snapshots For example: Scenarios that come from Snapshot
Scenarios Custom aggregators (including ave

0120

2 days ago
K

Krete J.Just Arrived
asked in Questions & Conversations
Automatic - scheduled Excel data import to Pigment - some easiest workaround?


I have read through most of the articles and questions. As I understand
currently there is no simple way to upload data from Excel to Pigment
transaction list by automatic schedule. But what would be easiest workaround? Is
it even in the roadmap? We have Excel that business owners keep up to date and
would like to load it daily to Pigment without anybody

00
K

2 days ago
V

VA NguyenNewly Minted Pigmenteer
asked in Questions & Conversations
Formula Playground needs to be more intuitive


We had to create a workforce roster of all employees with on target cash (or
OTE) in local and USD and it was very challenging to do this. Internally, on our
team, we tried to troubleshoot it ourselves and spent a few hours with no
success. Then we engaged our solutions consultant to do this and it took him 25
minutes to go through the spiderweb of how to take local currency multiplied by
current fx rates to get USD. In my past experience using other systems like
Adaptive, this would take 3 minutes. I’m bumping this up because I think there
is an opportunity to create an easier/more intuitive formula playground or
builder for some calculations.

12
V

3 days ago
P

pigment_enthusiastSeasoned Pigmenteer
asked in Questions & Conversations
Aggregate the metric's data based on a dimension


I am trying to consolidate the no. of projects assigned to an employee by below
formula: ('Assigned Project'[BY COUNTUNIQUE: 'd. Integer','d. Employee'])The
metric is of dimensions: Project, Integer, employee .In rows, i have all the
dimensions of the metric, but am getting the “1” as the result, and the result
is correct if I keep only employees in the rows.I need to fetch the total no. of
projects assigned to an employee. (Metric is having 3 dimensions: Project,
Integer, employee ). If an employee has total 4 projects assigned, it should
show: “4” as the output for that employee instead of “1” value in each of 4
rows.

01
P

3 days ago
nancySeasoned Pigmenteer
asked in Questions & Conversations
Maximum cardinality exceeded error


Hi Team, Could you please explain me about the error “Maximum Cardinality
Exceed” and how can we resolve it? thank you all in advance

04
P

3 days ago
V

VicoNewly Minted Pigmenteer
asked in Questions & Conversations
Error: Cannot access modalities of List 'Budget 2024' through Property 'Load
Type' because it is not unique


Hi people, I’m trying to create this metric when I receive the error: 'Budget
2024'.Amount['Budget 2024'.'Load Type'IN ('Budget 2024'.'Load Type'."Budget
TopLine",'Budget 2024'.'Load Type'."Budget Other Costs")][BY SUM: 'Budget
2024'.'Country Input'.'Country Pigment', 'Budget 2024'.Month, 'Budget
2024'.Product, 'Budget 2024'.Service, 'Budget 2024'.'Budget Line']+'Budget
2024'.Amount['Budget 2024'.'Load Type'= 'Load Type'."Budget OpEx"][BY SUM:
'Budget 2024'.Month,'Budget 2024'.'Budget Line'][BY: 'Product Input'."TBD",
Service.Name."TBD", 'Country Pigment'."Unallocated Country"] I highlighted in
red what Pigment is displaying, but I have no idea what’s going on. I wil really
appreciate any help.

06
V

3 days ago
P

pigment_enthusiastSeasoned Pigmenteer
asked in Questions & Conversations
Get the dimension list value based on a metric


Hi,I have a metric Project Allotted of data type: Project dimension; metric
having dimensions: Employee, Project Role and Integers. how can I fetch the
employee name in a metric “Emp” of data type: Employee and with dimensions:
Project Role and Project from the above ABC metric and with Lastnonblank
integer?

06

4 days ago
Show more activity
OlaFrequent Reader
asked in Questions & Conversations
Trigger import through API without sending data


Is it possible to trigger an import from Netsuite, Amazon S3 or Salesforce using
Pigment’s API? So in this case we don’t want to send the data in the request
body, we just like to trigger an existing import using the API instead of having
the import to run on a schedule. Just want to confirm if this is supported or
not, can’t really tell by reading the documentation here:

01

16 hours ago
C

CindyNewly Minted Pigmenteer
asked in Questions & Conversations
Create a Metric off Transaction Table to sum by period but filter by load date


Hello. I have imported a transaction list into Pigment that has two date
dimensions. One is “Month” and is = to an accounting period. The second date
dimension is the “Load Date” added automatically during the import. Each month,
I will append to the data list so at the end, this list could have GL data by
period for each load month. I am able to sum the data by period OR by load month
but I’m not able to say which load I want to use. My current formula is like
this: '02. Test Pivoted Push'.Amount[BY SUM: '02. Test Pivoted Push'.Department,
'02. Test Pivoted Push'.'GL Account', '02. Test Pivoted Push'.Month, '02. Test
Pivoted Push'.Subsidiary, '02. Test Pivoted Push'.Vendor] I want to add in a
condition where the results will be based on which load month is selected
(something like ]'02. Test Pivoted Push'.'Load Date'= Set_Last_Opex_Push_Month]
where ‘Set_Last_Opex_Push_Month’ will be determined by me.

01

17 hours ago
K

Krete J.Just Arrived
asked in Questions & Conversations
Automatic - scheduled Excel data import to Pigment - some easiest workaround?


I have read through most of the articles and questions. As I understand
currently there is no simple way to upload data from Excel to Pigment
transaction list by automatic schedule. But what would be easiest workaround? Is
it even in the roadmap? We have Excel that business owners keep up to date and
would like to load it daily to Pigment without anybody

00
K

2 days ago
V

VA NguyenNewly Minted Pigmenteer
asked in Questions & Conversations
Formula Playground needs to be more intuitive


We had to create a workforce roster of all employees with on target cash (or
OTE) in local and USD and it was very challenging to do this. Internally, on our
team, we tried to troubleshoot it ourselves and spent a few hours with no
success. Then we engaged our solutions consultant to do this and it took him 25
minutes to go through the spiderweb of how to take local currency multiplied by
current fx rates to get USD. In my past experience using other systems like
Adaptive, this would take 3 minutes. I’m bumping this up because I think there
is an opportunity to create an easier/more intuitive formula playground or
builder for some calculations.

12
V

3 days ago
P

pigment_enthusiastSeasoned Pigmenteer
asked in Questions & Conversations
Aggregate the metric's data based on a dimension


I am trying to consolidate the no. of projects assigned to an employee by below
formula: ('Assigned Project'[BY COUNTUNIQUE: 'd. Integer','d. Employee'])The
metric is of dimensions: Project, Integer, employee .In rows, i have all the
dimensions of the metric, but am getting the “1” as the result, and the result
is correct if I keep only employees in the rows.I need to fetch the total no. of
projects assigned to an employee. (Metric is having 3 dimensions: Project,
Integer, employee ). If an employee has total 4 projects assigned, it should
show: “4” as the output for that employee instead of “1” value in each of 4
rows.

01
P

3 days ago
P

pigment_enthusiastSeasoned Pigmenteer
asked in Questions & Conversations
Get the dimension list value based on a metric


Hi,I have a metric Project Allotted of data type: Project dimension; metric
having dimensions: Employee, Project Role and Integers. how can I fetch the
employee name in a metric “Emp” of data type: Employee and with dimensions:
Project Role and Project from the above ABC metric and with Lastnonblank
integer?

06

4 days ago
V
VianneyOccasional Observer
asked in Questions & Conversations
Can Pigment recognise a date dimension list if not linked with the native "Day"
Dimension in Pigment ?


Hello hello Pigment community I am struggling over an issue and maybe someone
can help me. My goal is here to setup a dashboard to analyse our commercial
pipeline. So all the client listed in our pipeline are potentiel leads. We have
in this data several columns of date : last interaction date, last modified
date, expected close date, etc… with also another column : “extract date”
indicating the date of the extract of the whole data. The difficulty is that i
cannot link all of theses column with the “Day” dimension in Pigment because i
can’t have in the same metric several dimension linked with the “Day Dimension”.
Hence i will have to create dimension for all of theses columns, not linked to
the “Day dimension”, in order to be able to use them in my metrics. But my
question is : if i create a dimension in which my data is several “date”, will
pigment be able to recognize and organize it (in a graph for example) if the
data is not linked with a native Pigment dimension ? For example, i

16
V
4 days ago
OlaFrequent Reader
asked in Questions & Conversations
Calculating Variance percentage for YTD values


We are trying to create a Income Statement for actuals vs Budget and previous
years (PY in the table below) value. Showing both monthly value and YTD. We have
our metrics on the rows in the table below. YTD is created as a calculated item
using Cumulate and all PY columns are also created as calculated items, using an
Offset on version Actuals. The problem is that I can’t get the column to the
very right “Var PY %” to show the right value, no matter how I define the
calculation priority. If I put it before YTD it is blank and if I put it after
YTD it calculates the variance as a percentage for each month and then sums all
these percentages together which results in a totally incorrect value. Any ide
how to set up the calculations to make this work?

03

5 days ago
R

rykasaNewly Minted Pigmenteer
asked in Questions & Conversations
Referencing the same number in a month over time


I have Services Bookings that I need to turn into Services Revenue over a set of
months based on % of completion. Each Services Bookings (ex: $100K) relates to a
product (Product A) that has a set number of services hours (ex: 300 hours) that
amortize over a set of months (ex: month 1=50, month 2=150, month 3=100). To
calculate revenue by month, I need to multiply Revenue $ per Hour ($100K/300
hours) by hours in each month. How do I reference the same Revenue $ per Hour in
each of the 3 months? As I book deals over time, each month will have different
Services Bookings that will impact the Revenue $ per Hour for that Services
Booking Month.

03

9 days ago
P

pigment_enthusiastSeasoned Pigmenteer
asked in Questions & Conversations
Boolean metric - True, False, Blank


I have a metric with so many IFs conditions,Out of those, there’s one condition
which checks the other boolean metric is False Or Is Blank.ISBLANK(Is active?) :
I am using this logic, its giving me the cardinality error.If I am replacing it
with Is Active <> TRUE, it doesn’t give the error ; but it checks only the
values which aren’t true, i.e. False, and doesn’t checks the Blank values.Any
suggestions? to resolve this as I need to check both “((Active? = FALSE) OR
ISBLANK(Active?))”

03

10 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

 * 627 topics
 * 1701 Replies


JOB BOARD

 * 82 topics
 * 1 Reply


ANNOUNCEMENTS

 * 33 topics
 * 35 Replies



Welcome to the Pigment Community! 🎉




1 year ago



CUSTOMER LEADERBOARD

 * Week
 * All time

1
C

chris.heredia

10 points

10 points

2
Lehtohen

10 points

10 points

3
Thu Mai

2 points

2 points

4
M

mdorhout

1 point

1 point

5
CDALMAY

1 point

1 point

Show full leaderboard
1
CamilleMomo

5427 points

5427 points

2
abhilashsawla

3943 points

3943 points

3
CDALMAY

2697 points

2697 points

4
Sofia Costa

2450 points

2450 points

5
A

Alexandre

2393 points

2393 points

6
R

rschimm

2302 points

2302 points

7
MKohli

1873 points

1873 points

8
Sam Gale

1522 points

1522 points

Show full leaderboard


BADGE WINNERS

 * Ekin Yelkenhas earned the badge Read and Interpret Formulas Certified
 * Cindyhas earned the badge Emerging Author
 * RoryChas earned the badge Emerging Author
 * cLoiseauhas earned the badge Read and Interpret Formulas Certified
 * Sylvainhas earned the badge Pigment Modeling Fundamentals Certified

Show all badges


EMPLOYEE LEADERBOARD

 * Week
 * All time

Show full leaderboard
1
Benoit

6314 points

6314 points

2
Pierre

3223 points

3223 points

3
Ben

2466 points

2466 points

4
KarlW

2392 points

2392 points

5
Keiran

2010 points

2010 points

Show full leaderboard



NEED MORE HELP?


CONTACT CUSTOMER SUPPORT

Contact our Support team and we'll be happy to help you get up and running!


CONTACT PARTNER SUPPORT

Contact our Support team and we'll be happy to assist you!


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