community.pigment.com Open in urlscan Pro
2600:9000:214f:d400: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__747696567" 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="mLXPsvqp2mCPDw6GmSkwtapZqfY6ViZn_epFd7_1LVk">
</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
      * Welcome to the Community!5
      * Questions & Conversations682
      * Career Forum82
      * Company News37

 * Knowledge Base
    * 
    * * Search the Knowledge Base
      * Documentation
      * Getting Started22
      * Modeling & Formulas42
      * Functions108
      * Reporting & Data visualization46
      * Pigment AI5
      * Collaborating on Pigment20
      * Security & Permissions38
      * Importing and Exporting Data61
      * Test & Deploy7
      * 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

 * Connect Pigment With SAP S/4HANA Public Cloud
 * What is Pigment AI?
 * Introduction to Test & Deploy
 * Set Up a Pigment Workflow
 * Introduction to Access Rights
 * Create a Dependent Dropdown on a List


EXPLORE THE COMMUNITY

 * Recently Active
 * Help Others
 * Categories

X

Xia HeJust Arrived
asked in Questions & Conversations
Unable to find the block to complete the activity




0
71

56 minutes ago
Spandan98Budding Pigmenteer
asked in Questions & Conversations
Date and Employee Mapping in Pigment


Hello Pigment community, I want to map the two tables such that I can map the
sales of manager mapped according to their end date and start date, and list
their sales according to the employees under them. I am attaching the assignment
screenshot below, please kindly help me. Thanks!

0
60

3 days ago
A

AdamBudding Pigmenteer
asked in Questions & Conversations
Circular adjustment


Hi, I have the following challenge: Metric 1. simple metric with sales forecast
in units with one dimension only MONTH. So let’s say it is Jan: 20; Feb: 30;
Mar: 20; Apr: 15 Metric 2. active orders already made e.g. 35 with no dimension
at all, just one number. Now I need to adjust Metric 1 with Metric 2 applying
the rule that earlier months are adjusted as first. I.e. adjusted forecast would
be: Jan: 0; Feb: 15; Mar: 20; Apr: 15 How do I do it in Pigment? Regards, Adam

0
231

3 days ago
Spandan98Budding Pigmenteer
asked in Questions & Conversations
Creating a working calendar with holidays marked in Pigment


Hello Pigment community, How can I create a working calendar with holidays
marked as the attached image below. Please kindly help me in this project. I
hope you will do the needful. Thanks! Thanks!

0
243

3 days ago
Isabella Leslie-MillerCommunity Manager
published in Welcome to the Community!
Pigment Community Badge System 🥇🥈🥉

On this page we outline how you can obtain specific badges 🥇 Our badges 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. Badge Name Criteria Emerging Author Posts (question,
conversation, article): 5 Author Posts (question, conversation, article): 15
Distinguished Author Posts (question, conversation, article): 60 Expert Author
Posts (question, conversation, article): 120 Emerging Helper Answers: 1 Helper
Answers: 10 Distinguished Helper Answers: 25 Expert Helper Answers: 100 Emerging
Chatterbox Replies: 10 Chatterbox Replies: 25 Distinguished Chatterbox Replies:
100 Expert Chatterbox Replies: 250 Emerging Connoisseur Likes given: 10
Connoisseur Likes given: 50 Distinguished Connoisseur Likes given: 100 Expert
Connoisseur Likes given: 300 Star Likes received: 10 Superstar Likes received:
50 Icon Likes received: 100 Legend Likes received: 300 Innovat

11
4053

3 days ago
Spandan98Budding Pigmenteer
asked in Questions & Conversations
Data Access rights for specific columns in Pigment


Dear Pigment Community, I hope you're doing well! I am currently facing two
challenges in my Pigment setup and would greatly appreciate your guidance:
Freezing Data Entry for Weekends & Holidays: I would like to restrict data entry
for weekends (e.g., 06/01/2024 and 07/01/2024) and holidays (which I will
updating in a different dimension) while keeping data entry open for other days.
This restriction should apply consistently for all weekends throughout the year.
Customizing Date Formats in Column Headers: I want to display the date in the
column header in the format: 6th Jan 2024 and 7th Jan 2024 (instead of the
default format). This format should be applied consistently across all dates
throughout the year. If anyone has suggestions, solutions, or best practices for
implementing these features, I would greatly appreciate your input! Thank you in
advance for your help!

0
100

4 days ago
Spandan98Budding Pigmenteer
asked in Questions & Conversations
Count number of duplicate items in metric


Hello Pigment Community, I’m currently facing an issue with counting duplicate
items in Pigment. As shown in the image below, I’ve successfully extracted words
from a sentence. Now, I’d like to conditionally format and highlight repeated
words starting from their second occurrence. I understand that using a counter
to track how often a word appears is key here, but I’m struggling to come up
with the correct formula to achieve this. Could someone kindly guide me on how
to proceed? Your help would be greatly appreciated! Thanks in advance!

0
311

5 days ago
OlaSeasoned Pigmenteer
asked in Questions & Conversations
Combine "Show value as" with aggregations


We have created an income statement where we have one metric for Income and
another metric for COGS. Both these metrics is by the dimension Account and in
our table we use Account Group and Account on the Rows which gives us a dynamic
income statement where it is possible to expand and collapse rows to see the
hierarchy: - Income - Account Group -Account Our challenge is that we like to
have the exact same view that shows us Income and COGS per Order. We can achieve
this by using “Show value as” to show our metrics in relation to total number of
orders and it also works fine when filtering the table by Location or
Subsidiary. However, show value as does not work in combination with grouping by
Account Group and Account, since number of orders is not by account. If we add
the dimension Account to our metric for Number of orders we can get it right on
the lowest level, but in this case the aggregations by account and account group
becomes wrong. Is there any workaround for this? How can

0
984
E

5 days ago
Isabella Leslie-MillerCommunity Manager
published in Company News
The Pigment Awards are open - submit now!News

We’re thrilled to announce the Pigment Awards 2024, recognizing the
achievements, innovation, and leadership within our incredible community. This
is your chance to showcase how you or your team have driven change, optimized
processes, and inspired others using Pigment! 🏅 Award Categories: The
Game-Changer: Business transformation project of the year. The Optimizer: Best
process optimization initiative. The Trailblazer: Best use of AI in finance. The
Visionary: Most innovative use of Pigment. The Bar-Raiser: Celebrating
individual excellence. 📅 Nominations are open now until December 31, 2024.
Winners will be announced in February 2025, with prizes including a celebratory
dinner or charity donation. 📝 Submit your nomination now! Let’s celebrate the
game-changers and innovators shaping the future with Pigment. Will you or your
team be among this year’s winners? 🚀 #PigmentAwards2024 #CommunitySuccess
#Innovation

1
190

5 days ago
Spandan98Budding Pigmenteer
posted in Questions & Conversations
Resources to become an expert in Pigment

Hello Pigment Community, I’m new to Pigment and eager to become an expert in
using the platform. To accelerate my learning journey, I would greatly
appreciate your help with the following: Practice Assignments: A list of
exercises or projects, starting from beginner to advanced levels, that I can
work on to build and refine my Pigment skills. Video Tutorials: Resources or
video walkthroughs demonstrating how to implement large-scale projects in
Pigment. Having access to these resources would significantly enhance my
understanding and hands-on experience. If anyone can point me in the right
direction or share relevant materials, I’d be incredibly grateful! Looking
forward to learning from this amazing community. Thank you so much for your time
and support!

0
465

6 days ago
Show more activity
X

Xia HeJust Arrived
asked in Questions & Conversations
Unable to find the block to complete the activity




0
71

56 minutes ago
Spandan98Budding Pigmenteer
asked in Questions & Conversations
Date and Employee Mapping in Pigment


Hello Pigment community, I want to map the two tables such that I can map the
sales of manager mapped according to their end date and start date, and list
their sales according to the employees under them. I am attaching the assignment
screenshot below, please kindly help me. Thanks!

0
60

3 days ago
A

AdamBudding Pigmenteer
asked in Questions & Conversations
Circular adjustment


Hi, I have the following challenge: Metric 1. simple metric with sales forecast
in units with one dimension only MONTH. So let’s say it is Jan: 20; Feb: 30;
Mar: 20; Apr: 15 Metric 2. active orders already made e.g. 35 with no dimension
at all, just one number. Now I need to adjust Metric 1 with Metric 2 applying
the rule that earlier months are adjusted as first. I.e. adjusted forecast would
be: Jan: 0; Feb: 15; Mar: 20; Apr: 15 How do I do it in Pigment? Regards, Adam

0
231

3 days ago
Spandan98Budding Pigmenteer
asked in Questions & Conversations
Creating a working calendar with holidays marked in Pigment


Hello Pigment community, How can I create a working calendar with holidays
marked as the attached image below. Please kindly help me in this project. I
hope you will do the needful. Thanks! Thanks!

0
243

3 days ago
Spandan98Budding Pigmenteer
asked in Questions & Conversations
Data Access rights for specific columns in Pigment


Dear Pigment Community, I hope you're doing well! I am currently facing two
challenges in my Pigment setup and would greatly appreciate your guidance:
Freezing Data Entry for Weekends & Holidays: I would like to restrict data entry
for weekends (e.g., 06/01/2024 and 07/01/2024) and holidays (which I will
updating in a different dimension) while keeping data entry open for other days.
This restriction should apply consistently for all weekends throughout the year.
Customizing Date Formats in Column Headers: I want to display the date in the
column header in the format: 6th Jan 2024 and 7th Jan 2024 (instead of the
default format). This format should be applied consistently across all dates
throughout the year. If anyone has suggestions, solutions, or best practices for
implementing these features, I would greatly appreciate your input! Thank you in
advance for your help!

0
100

4 days ago
Spandan98Budding Pigmenteer
asked in Questions & Conversations
Count number of duplicate items in metric


Hello Pigment Community, I’m currently facing an issue with counting duplicate
items in Pigment. As shown in the image below, I’ve successfully extracted words
from a sentence. Now, I’d like to conditionally format and highlight repeated
words starting from their second occurrence. I understand that using a counter
to track how often a word appears is key here, but I’m struggling to come up
with the correct formula to achieve this. Could someone kindly guide me on how
to proceed? Your help would be greatly appreciated! Thanks in advance!

0
311

5 days ago
OlaSeasoned Pigmenteer
asked in Questions & Conversations
Combine "Show value as" with aggregations


We have created an income statement where we have one metric for Income and
another metric for COGS. Both these metrics is by the dimension Account and in
our table we use Account Group and Account on the Rows which gives us a dynamic
income statement where it is possible to expand and collapse rows to see the
hierarchy: - Income - Account Group -Account Our challenge is that we like to
have the exact same view that shows us Income and COGS per Order. We can achieve
this by using “Show value as” to show our metrics in relation to total number of
orders and it also works fine when filtering the table by Location or
Subsidiary. However, show value as does not work in combination with grouping by
Account Group and Account, since number of orders is not by account. If we add
the dimension Account to our metric for Number of orders we can get it right on
the lowest level, but in this case the aggregations by account and account group
becomes wrong. Is there any workaround for this? How can

0
984
E

5 days ago
H

HarshilNewly Minted Pigmenteer
asked in Questions & Conversations
Dynamic Variable Not Updating by Scenario


I created a dynamic variable called “TvA Actuals Range” and set it equal to the
“IsActuals” date range. The issue is that the date range is not updating based
on the scenario. Can you please advise?

0
101

6 days ago
Spandan98Budding Pigmenteer
asked in Questions & Conversations
Quarter and Year dimensionality problem


How to add a grid on a board with input fields? For example I have data for
quarters and I want to set targets of a year which can be entered by the user on
a board. How can I achieve this?

0
252

10 days ago
B
BenedikteOccasional Observer
asked in Questions & Conversations
Error: Unknown Block (List or Metric)


Hi, I am getting an error in my metric that is saying that block that I am
referring to is not existing, but in fact it is a block that I am using actively
in my management reporting. So I do not understand why it seems like the Block
is not possible to retrive.Can someone please help me out regarding this? :)
Best regards,Benedikte

0
182

10 days ago
Show more activity


EXPLORE THE COMMUNITY

Connect with other users, discuss how you're using Pigment, and get inspired


WELCOME TO THE COMMUNITY!

 * 5 topics


QUESTIONS & CONVERSATIONS

 * 682 topics


CAREER FORUM

 * 82 topics


COMPANY NEWS

 * 37 topics



Welcome to the Pigment Community! 🎉




1 year ago



CUSTOMER LEADERBOARD

 * Week
 * All time

Show full leaderboard
1
CamilleMomo

5760 points

5760 points

2
abhilashsawla

3953 points

3953 points

3
CDALMAY

3458 points

3458 points

4
Sofia Costa

2490 points

2490 points

5
A

Alexandre

2483 points

2483 points

6
R

rschimm

2353 points

2353 points

7
MKohli

1903 points

1903 points

8
agnar

1568 points

1568 points

Show full leaderboard


BADGE WINNERS

 * Jordan C.has earned the badge Pigment Like a Pro
 * Wafaehas earned the badge Read and Interpret Formulas Certified
 * luciemaheyhas earned the badge Pigment Modeling Fundamentals Certified
 * Wafaehas earned the badge Pigment Like a Pro
 * Ehabhas earned the badge Innovator

Show all badges


EMPLOYEE LEADERBOARD

 * Week
 * All time

Show full leaderboard
1
Benoit

6560 points

6560 points

2
Pierre

3389 points

3389 points

3
Ben

2496 points

2496 points

4
KarlW

2440 points

2440 points

5
Keiran

2124 points

2124 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?

Login with Saml2 Log in with your Pigment account


LOG INTO THE PIGMENT COMMUNITY

SINGLE SIGN-ON NEED HELP?

Login with Saml2 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