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

Back to summary

Submitted URL:
http://community.gopigment.com/?wp-cs-dump
Effective URL:
https://community.gopigment.com/?wp-cs-dump
Submission: On April 22 via api (April 22nd 2024, 7:17:11 am UTC) from DE — Scanned from DE

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__1222039109" 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="A003iJWAxZ95rhwXAcEgDnmAZXk_Iyoiwy_w0_yQrto">
</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 & Conversations501
* Job Board75
* Announcements24

* Knowledge Base
*
* * Search the Knowledge Base
* Documentation
* Getting Started23
* Modeling & Formulas41
* Functions105
* Reporting & Data visualization39
* Collaborating on Pigment21
* Security & Permissions30
* Importing and Exporting Data55
* 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

YaejisNewly Minted Pigmenteer
asked in Questions & Conversations

AMORTIZATION BASED ON START/END DATES

Hi Pigment team! I am trying to setup a amortization schedule as following. Can
you please help? Orange is given resources Green is the output that I would like
to have in the table/metric Blue is just validation for myself which aligns with
the orange Total column and doesn’t need to be in the model Following is the
formula I used in excel: For 1/31/2023 Column alone, formula is
=($V5/$AS5)*((AV$4-$AQ5)+1) For 2/28/2023 and onwards, formula is
=IF(EOMONTH($AR264,0)<AW$4,0,IF(AW$4<=$AR264,($V264/$AS264)*(TEXT(AW$4,"d")),($V264/$AS264)))
I tried using the following formula in playground for 1/31/2023 column, but it
doesn’t seem to work. IF(Month.'Start Date'=DATE(2023,01,1),('RSU Accounting
Data'.'Expense Amortized Future'/'RSU Accounting Data'.'Amortization # of Days')
* DAY(Month.'End Date')) Thanks for helping out!

06
Y

2 days ago
Sharon ConroyCommunity Manager
published in Reporting & Data visualization

APPLY CONDITIONAL FORMATTING BASED ON ANOTHER METRIC

Conditional formatting based on another Metric allows you to apply conditional
formatting on a Metric or Dimension Item based on the outcome of a Metric within
the same table. The flexibility to format based on more specific conditions
gives you greater depth when analyzing your data. COMING SOON! Completely new to
conditional formatting? Not a problem. We recommend that you first take a look
at Apply Conditional Formatting to Highlight Data Changes . This article
introduces you to conditional formatting. It describes how to apply conditional
formatting, explains conditional formatting rules, and also helps you understand
formatting options. Considerations Before you start applying conditional
formatting based on the outcome of another Metric, here’s some useful
information to keep in mind: Application compatibility: You can apply
conditional formatting based on another Metric to a Metric Header. In this
instance, Pigment compares all cells belonging to the other Metric to those
condit

190

2 days ago
PierreCommunity Manager
published in Functions

DOUBLE_EXPONENTIAL_SMOOTHING FUNCTION

Description Compute a double exponentially smoothed version of the input Block
over the ranking Dimension. Syntax DOUBLE_EXPONENTIAL_SMOOTHING(Input Block [,
Ranking Dimension [, alpha, beta]) Arguments Argument Type Dimensions
Description Input Block (required) Number Any Dimensions This is the data source
which will be smoothed. The Metric must be defined at least on the Ranking
Dimension Dimension. Ranking Dimension (optional) Dimension NA This is a
Dimension applied to the time series taken in the Input Block. This is optional
if it’s a datetime Dimension from the calendar. If this is not the case, then
this is mandatory. It’s also mandatory if the Metric is defined on several time
Dimensions. alpha (optional) Number no Dimension Data smoothing factor, with a
value between 0 and 1. The default value is 0.25 . beta (optional) Number no
Dimension Trend smoothing factor, with a value between 0 and 1. The default
value is 0.1 . Returns Type Dimensions Number Dimensions of Input Block B

0290

3 days ago
Sharon ConroyCommunity Manager
published in Security & Permissions

SET UP ACCESS RIGHTS ON SCENARIOS

Coming Soon When you set up Access Rights for Scenarios, you’re ensuring that
only specific users have the appropriate level of access to view and modify
Scenario data within your Workspace. Because you are configuring access rights
according to Role, you control who can read, write, or simply have no access to
specific Scenarios. This helps to maintain data security and confidentiality, as
well as encouraging collaboration and efficiency in Scenario planning and in
decision-making processes. You need to be a Workspace Security Admin Account
Type in order to define access rights on any/all Scenarios. We strongly
recommend that you read Access Rights on Scenarios before you set up Access
Rights on Scenarios. You have two options to set up Access Rights for each
Scenario. The first option is at the Application level, within the Roles,
Permissions, and Access page. Here, you configure Scenario restrictions on a
role-by-role basis for the application. The other option is at Scenario level,

160

3 days ago
Sharon ConroyCommunity Manager
published in Security & Permissions

ACCESS RIGHTS ON SCENARIOS

Coming Soon When working in Scenarios in Pigment, you can enhance data security
by restricting the access rights on the Scenario to defined Members based on
their Role in the Application. Scenarios data will be restricted and the names
are only displayed in the Page Selectors on Views and Boards for certain Members
with assigned access rights. This allows you to keep the data on specific
Scenarios private, and also makes it easier to find and select relevant
Scenarios for those users on a View or Board. Required Reading Considerations
for Scenario Access Rights Working with Default Scenarios Inputting data
Importing data Handling data privacy Read-only Scenarios Scenario access rights
and regular access rights You need to be a Workspace Security Admin Account Type
in order to define access rights on all Scenarios. Here’s an example of how
you’d use restricted Scenarios. Let’s say you want to develop a Scenario for
Workforce and Opex planning applications where the potential to-be-hired

1140

3 days ago
H

HarshilNewly Minted Pigmenteer
asked in Questions & Conversations

SHOW SCENARIO VARIANCE AND YOY VARIANCE IN THE SAME TABLE

How can I show the scenario variance and YoY variance in the same table? I’d
also like to be able to collapse month » quarter » year as needed. Currently,
it’s showing YoY columns for all scenarios. Also, is there a way to restrict
which metrics a calculated item pertains to? Lastly, is there a way to hide
columns in a table? Thanks!

01
M

3 days ago
C

Chris EJust Arrived
asked in Questions & Conversations

NETSUITE BALANCE SHEET - MONTH OVER MONTH HISTORICAL

I am trying to rebuild our Balance Sheet reporting from NetSuite into Pigment
using a Saved Search. However, because our Balance Sheet is consolidated between
entities that use different currencies, the Saved Search transaction amounts do
not match the reported amounts in NetSuite by period. This seems to be a
difference in currency exchange rate methodologies between the way the Saved
Search pulls FX (by transaction) and the way the Balance Sheet report pulls FX
(by reporting period). Has anyone been able to solve this and pull in historical
Balance Sheets month over month to match the reporting?

01
A

4 days ago
K

KevinSeasoned Pigmenteer
asked in Questions & Conversations

CHART LEGEND NOT DISPLAYING BOTTOM CENTER

I am unable to properly display the metric in a chart legend below the line
chart. The first screenshot has the legend in the bottom right and everything is
fine. But when I moved it to the bottom center, the second value is not
displayed. This chart is in a second view with one of the metrics hidden so
perhaps that is causing the issue. But clearly the data is being displayed as
needed but without the proper legend text. Any help to fix this would be much
appreciated.

00
K

5 days ago
Sharon ConroyCommunity Manager
published in Modeling & Formulas

CREATE A DEPENDENT DROPDOWN ON A TABLE

When working with Table Views, you can create dependent dropdown menus to filter
the available items in dropdown menus for Metrics. These can be filtered based
on the cell coordinates, selected items in other Dimension Metrics within the
same Table, or a combination of both. This filtering is configured at the Table
level through rules that map Dimensions of the configuration Metric to
Dimensions of the Metrics in the Table. Before you begin Create a Dependent
Dropdown on a Table Create a New Configuration Metric Editing Dropdown
Connections To perform this task, you need the Can Configure Block permission.
Let’s say you have two Metrics, one for Employees and one for Employee
Departments, and these are both segmented by Month. Dependent dropdowns allow
you to filter the available departments based on where the employee was located
that month using a transaction list. This type of filtering is common in
situations where the inputs are driven by time Dimensions, which are possible in
Ta

1250

5 days ago
PierreCommunity Manager
published in Functions

SIMPLE_EXPONENTIAL_SMOOTHING FUNCTION

Description Computes an exponentially smoothed version of the input Block over a
ranking Dimension. Syntax SIMPLE_EXPONENTIAL_SMOOTHING(Input Block [, Ranking
Dimension [, alpha]}) Arguments Argument Type Dimensions Description Input Block
(required) Number Any Dimensions This is the data source which will be smoothed.
The Metric must be defined at least on the Ranking Dimension Dimension. Ranking
Dimension (optional) Dimension Not applicable This is a Dimension applied to the
time series taken in the Input Block. This is optional if it’s a datetime
Dimension from the calendar. If this is not the case, then this is mandatory.
It’s also mandatory if the Metric is defined on several time Dimensions. alpha
(optional) Number no Dimension Data smoothing factor, with a value between 0 and
1. The default value is 0.5 . Returns Type Dimensions Number Dimensions of Input
Block Before the first non-blank value of the Input Block, the function returns
blank. Between the first and the last non-bla

1330

5 days ago
Show more activity
H

HarshilNewly Minted Pigmenteer
asked in Questions & Conversations

SHOW SCENARIO VARIANCE AND YOY VARIANCE IN THE SAME TABLE

01
M

3 days ago
C

Chris EJust Arrived
asked in Questions & Conversations

NETSUITE BALANCE SHEET - MONTH OVER MONTH HISTORICAL

01
A

4 days ago
K

KevinSeasoned Pigmenteer
asked in Questions & Conversations

CHART LEGEND NOT DISPLAYING BOTTOM CENTER

00
K

5 days ago
J

jameslJust Arrived
asked in Questions & Conversations

BALANCE SHEET

Hi, I am trying to build a balance sheet in Pigment. My saved search in Netsuite
lists all transactions but, to show the balance, I need to sum all of the
transactions from all previous months. How do I do this in Pigment?
Alternatively, given I don’t actually need balances broken down by transaction
in Pigment, would I be better off to try and find a way of extracting balances
from Netsuite so that I can use those? (though I am not sure how I do that so
any idea on that gratefully received too)

01
L

9 days ago
K

keerthanarameshBudding Pigmenteer
asked in Questions & Conversations

BREAKDOWN BY SAME DIMENSION

I was able to Breakdown by Department>Internal Group property for one metric in
a table but I’m not able to Breakdown by Department again for another metric I’m
able to breakdown by department in either of those metrics but not both. I’m
using breakdown option at various places in this table which allows the same
dimension to be broken down among different metrics multiple times but not this
one specifically. What could be the reason for this?

02
K

11 days ago
DmitriiSeasoned Pigmenteer
asked in Questions & Conversations

SCENARIOS IN SECURITY METRICS?

I have an app with scenarios. Scenarios are enabled: But when I create a metric
in security folder, there are no scenarios and values are propagated to all
scenarios. But I want to lock/unlock write rights for specific scenarios, so I
need scenarios on the security folder too. If I move the metric outside the
security folder, the scenarios appear, but then this metric cannot be used in
the access rights rules (which is not intuitive). Any tips, thoughts?

11 days ago
A

Adrien LEmployee
asked in Questions & Conversations

KEY SHORTCUT

Are any Key shortcuts in Development? A shortcut from Editing to User mode in
Board would be helpful, and one for aligning Widget might be great.

31
S

17 days ago
N

Not Jeremy SternNewly Minted Pigmenteer
asked in Questions & Conversations

AGGREGATE VS. IMPORT FOR PARENT/CHILD DIMENSION RELATIONSHIP

We have two dimensions that have a parent/child relationship - L0 Company and L1
Parent Company. For the exercise, here are some details: L0 has 500,000 items,
L1 has 400,000 items This property will be upstream of a fairly complex cohorted
revenue model Both dimensions are provided to us from Snowflake The date
formatted property “First ARR Date” exists at the L0 Company level We need First
ARR Date in L1 Parent Company in Pigment, what is the preferred way to do this
to maximize performance? Aggregate from L0 to L1 in Pigment using a BY MIN
Aggregate in Snowflake & import the First ARR Date into both our L0 and L1
dimensions A third option? Further, would the right way to do this change if the
balance of list items between lists changed?

00
N

17 days ago
OlaOccasional Observer
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?

18 days ago
C

Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations

BUILDING A BALANCE SHEET IN PIGMENT

I am trying to build a balance sheet but I did not find any article about it. So
i create a saved search in netsuite that is linked to metric in Pigment by using
a transaction list.I’m trying to display data for multiple periods ( ex: dec 21,
dec22...) in the same metric but looks like i have to create different
transaction lists for different periods and then create a table to aggregate all
the periods. Happy to have your insight on the most efficient way to build a
balance sheet, thanks

22 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

* 501 topics
* 1367 Replies

JOB BOARD

* 75 topics
* 1 Reply

ANNOUNCEMENTS

* 24 topics
* 30 Replies

Welcome to the Pigment Community! 🎉

1 year ago

EVENTS CALENDAR

CUSTOMER LEADERBOARD

* Week
* All time

1
CamilleMomo

20 points

2
H

Harry Child

20 points

3
C

chris.heredia

10 points

4
V

Vikatzen

6 points

Show full leaderboard
1
CamilleMomo

4036 points

2
abhilashsawla

3761 points

3
Sofia Costa

2350 points

4
A

Alexandre

2143 points

5
R

rschimm

1863 points

6
MKohli

1843 points

7
C

Chelsea

1474 points

8
E

Elodie

1455 points

Show full leaderboard

BADGE WINNERS

* Harry Childhas earned the badge Innovator
* MOSESDhas earned the badge Pigment Modeling Fundamentals Certified
* Wojtek Migdalskihas earned the badge Innovator
* Wojtek Migdalskihas earned the badge Pigment Modeling Fundamentals Certified
* Kaberahas earned the badge Pigment Modeling Fundamentals Certified

Show all badges

EMPLOYEE LEADERBOARD

* Week
* All time

Show full leaderboard
1
Benoit

5417 points

2
Pierre

2757 points

3
KarlW

2184 points

4
Ben

2116 points

5
Keiran

1748 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!

Already have an account? Login

SINGLE SIGN-ON NEED HELP?

LOG INTO THE PIGMENT COMMUNITY

SINGLE SIGN-ON NEED HELP?

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.

THIS FILE CANNOT BE DOWNLOADED

Sorry, our virus scanner detected that this file isn't safe to download.

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

Form analysis 2 forms found in the DOM

GET /search/index

Name: forgotPassword — POST /member/forgotPassword

Text Content

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

Form analysis
2 forms found in the DOM