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

Back to summary

Submitted URL:
http://community.gopigment.com/?1.5.3-spam
Effective URL:
https://community.gopigment.com/?1.5.3-spam
Submission: On April 15 via api (April 15th 2024, 7:21:40 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__1395367235" 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="_f51UjDogFuAdmvfcO1W96aCZoWmtQ2k01j4MIk0xV4">
</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 & Conversations498
* Job Board75
* Announcements24

* Knowledge Base
*
* * Search the Knowledge Base
* Documentation
* Getting Started23
* Modeling & Formulas40
* Functions103
* Reporting & Data visualization38
* Collaborating on Pigment21
* Security & Permissions28
* 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

COLOR FORMATTING

Hi! Is there a way I can change the color setting such that Unbilled and Billed
dimensions are in different colors? Thanks in advance!!

15
Y

2 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

2 days ago
KarlWCommunity Manager
published in Announcements

LEVEL UP YOUR PIGMENT FORMULA KNOWLEDGE WITH NEW LEARNING EXPERIENCENEWS

Introducing Formula Writing: Unlocking Dimensionality and Calculations We've
heard your requests for more formula & calculation training, and we're excited
to announce our new Pigment learning path! The training is split into two parts:
Read & Interpret Formulas - Perfect for those who need to be able to create
inputs and analyze outputs! You'll need just a couple of hours, and you'll be
able to better define requirements and understand the calculations available to
you. Write & Test Formulas - Hey modelers, this one's for you! This new learning
path will offer a deep-dive into the most helpful modifiers and offer real-world
exercises to solidify your learning. These new learning paths are NOW LIVE in
the Pigment Academy! Click below to get started:

0110

2 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

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

00
C

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

4 days ago
R

RohitDivate_GustoJust Arrived
posted in Job Board

FULL TIME JOB AT GUSTO - PIGMENT PRO (MODELER/ARCHITECT)

Hiring for a pigment pro! Please see details in this post where we are hiring
for 1 corporate finance role and 1 pigment pro role.
https://www.linkedin.com/posts/activity-7183650056133074944-z_oT?utm_source=share&utm_medium=member_desktop

20
R

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

00
H

6 days ago
A
AdamOccasional Observer
asked in Questions & Conversations

NETWORKDAYS FUNCTION

Hi, I struggle to understand how NETWORKDAYS function can be used. I read the
help page for the function but in vain. I want to get number of working days in
Jan 2023 (ignoring holidays). My formulas is:
NETWORKDAYS(date(2023,1,1),date(2023,1,31),'01. Day of week'.Working = true)
where Day of week is a dimension I created (below). I am getting 150 as the
result of the formula which is obviously wrong. Help please :)

6 days ago
JulienCommunity Manager
published in Importing and Exporting Data

CONNECT PIGMENT WITH AZURE BLOB STORAGE

This article explains how to connect a Azure Blob Storage with your Pigment
Organization to load a CSV file stored in a container into a Pigment’s block.
Overview Setting up access Azure Step 1 - Create or use an existing App
registration Azure Step 2 - Retrieve authentication credentials Azure Step 3 -
Create or use an existing Storage account and Container Azure Step 4 - Set IAM
permissions on the Container Creating a connection in Pigment Use the connection
in Pigment Fixed file Most recent file Overview This process starts in Azure,
with the configuration of an App Registration and a Container which you will use
when setting up the connection in Pigment. Setting up access Azure Step 1 -
Create or use an existing App registration From your Azure Portal homepage,
first head to App registrations: From there, you can either select an existing
registration in the list of applications or create a new one with “+ New
registration”. Azure Step 2 - Retrieve authentication credentials From t

1340

6 days ago
Show more activity
J

jameslJust Arrived
asked in Questions & Conversations

BALANCE SHEET

01
L

2 days ago
K

keerthanarameshBudding Pigmenteer
asked in Questions & Conversations

BREAKDOWN BY SAME DIMENSION

02
K

4 days ago
C

Chris EJust Arrived
asked in Questions & Conversations

NETSUITE BALANCE SHEET - MONTH OVER MONTH HISTORICAL

00
C

4 days ago
DmitriiSeasoned Pigmenteer
asked in Questions & Conversations

SCENARIOS IN SECURITY METRICS?

4 days ago
H

HarshilNewly Minted Pigmenteer
asked in Questions & Conversations

SHOW SCENARIO VARIANCE AND YOY VARIANCE IN THE SAME TABLE

00
H

6 days ago
E

erikausenNewly Minted Pigmenteer
asked in Questions & Conversations

REPEAT ROW LABELS

Hi! In the layout selection I can only choose to display grid as tabular or
tree. However, both options are grouping the row labels. Is there a way to
select Pigment to repeat the row labels?

02
E

9 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

10 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

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

11 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

15 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

* 498 topics
* 1351 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

Show full leaderboard
1
CamilleMomo

3811 points

2
abhilashsawla

3761 points

3
Sofia Costa

2360 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

* AchinechCyhas earned the badge Innovator
* Olahas earned the badge Innovator
* Carolehas earned the badge Emerging Chatterbox
* LAShas earned the badge Pigment Modeling Fundamentals Certified
* Parthkhas earned the badge Pigment Modeling Fundamentals Certified

Show all badges

EMPLOYEE LEADERBOARD

* Week
* All time

Show full leaderboard
1
Benoit

5309 points

2
Pierre

2702 points

3
KarlW

2158 points

4
Ben

2115 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:ee00: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:ee00:10:8bf:5cc0:93a1 Public Scan

Form analysis
2 forms found in the DOM