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

Back to summary

Submitted URL:
http://community.pigment.com/
Effective URL:
https://community.pigment.com/
Submission: On December 09 via api (December 9th 2024, 12:48:54 pm 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" 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__345771846" 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="HjsDV6e7Y89a8ySVOAtGEb6O2hgV825THxg0mIvZt6Q">
</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 & Conversations668
* Job Board82
* Announcements36

* Knowledge Base
*
* * Search the Knowledge Base
* Documentation
* Getting Started22
* Modeling & Formulas41
* Functions108
* Reporting & Data visualization46
* Pigment AI5
* Collaborating on Pigment20
* Security & Permissions37
* Importing and Exporting Data60
* 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

AravindJust Arrived
asked in Questions & Conversations
Changing data type of metrics

Hi All, I’m not able to change the data type of ‘User Roles’ metric from
Role(local) to Role(Data hub). But when i try to change the data type, I’m
getting the following error. Pls advise on this. “Unable to change the structure
of a metric used in the security settings. Remove it from the security settings
before performing this action.” How do i overcome this error?

0
121

3 hours ago
W

William Murray BrownNewly Minted Pigmenteer
asked in Questions & Conversations
Dimensions of "seasonality" argument for SEASONAL_LINEAR_REGRESSION

The documentation for the SEASONAL_LINEAR_REGRESSION function states that the
“seasonality” argument can have the following dimensions: No Dimension or
Dimensions of Text 1 I have two questions about this… When I try to use a metric
with no dimensions as this argument, I get the error “Function
SEASONAL_LINEAR_REGRESSION requires argument 2 to be a positive integer”. What
am I doing wrong? The metric where I’m using SEASONAL_LINEAR_REGRESSION has
three dimensions (month and two non-time dimensions). What does “Dimensions of
Text 1” mean?

0
254
W

2 days ago
E

EvlimeNewly Minted Pigmenteer
asked in Questions & Conversations
I want to set up a dimension from a calculation

Hello community, I am creating a PnL report for our company. At the moment it
displays revenue (metric), cost (another metric), gross profit ( metric from
formula) and so on. The metrics are derived from a transaction table that I
imported. Now I would like to show the total USD and in the coloumn next to it I
want to display avg per person. I have calculated the Avg per person and managed
to create the same table as above from the avg metrics of the above metrics. BUT
because these are metrics, I cannot have them side by side in the table. If I
add the avg per person to my total table it will just add all the rows below. I
can move upp the “metric” in pivot to columns but then that messes up the
revenue, costs, gross profit placement etc. I created a dimension called version
and was able to attach that as a property to the total metrics and the avg
metrics, but haven’t found a way to union the two metrics with the variant
dimensions. So my question is, how can I create a dimension fro

0
383
E

3 days ago
caoimhe.gaskinCommunity Manager
published in Reporting & Data visualization
Application Snapshot Limits

Snapshot limit alerts are available from the week of Dec. 9. Your Workspace has
a Snapshot limit based on your subscription plan. It’s best practice to take a
Snapshot of your data at the end of each planning phase. However, retaining
unnecessary Snapshots can lead to significant storage consumption and
organizational inefficiencies for Administrators. How do Snapshot limits work?
Members must have a Builder account type or higher, along with the Display
Application permission for the Application, to create Snapshots. Only
Application owners can delete Snapshots. Contact a Workspace Admin for support
if you’ve reached your Snapshot limit. You’ll receive an alert in your Workspace
once you reach your Snapshot limit. You must review and delete unnecessary
Snapshots after this alert or risk being temporarily blocked from Snapshot
creation. If you’re blocked from taking Snapshots, you must delete unnecessary
Snapshots to restore access to Snapshot creation. Contact a Workspace Admin to
rev

0
380

4 days ago
D

DamianAtPigmentCommunity Manager
posted in Questions & Conversations
MySQL RDBMS import into Pigment

Often, we get the request to load enterprise volume data from MySQL RDBMS into
Pigment. While Pigment doesn’t have a dedicated MySQL connector or ODBC
capability, this can easily be achieved via Pigment’s import API. Below is
example code that connects to MySQL, executes a SQL statement, and imports the
data into Pigment. 1. Generate Pigment Import API key
https://community.pigment.com/security-permissions-82/manage-api-keys-226 2. For
Imports into Pigment (to understand the process)
https://community.pigment.com/importing-and-exporting-data-95/how-to-trigger-an-import-with-apis-230
3. Load Data from MySQL RDBMS into Pigment via Pigment’s Import API using
Python: import mysql.connectorimport getpassimport requestsfrom io import
StringIOimport sysimport logging # Configure
logginglogging.basicConfig(level=logging.INFO, format='%(asctime)s -
%(levelname)s - %(message)s') # MySQL Connection & SQL queryusername =
'MYSQL_USERNAME'server = 'MYSQL_SERVER'database = 'MYSQL_DATABASE'password =

1
80
D

4 days ago
P

pigment_enthusiastSeasoned Pigmenteer
asked in Questions & Conversations
RANK function - How to handle ties

I have a metric : which has 20, 20, 20 and 15, 11 numbers I need to show Top 2
of the products: It only shows the 2 products with 20 valueIt should show all
those products with 20,20, 20 and 15 value20 is a tie number.

0
8913
P

5 days ago
D

DamianAtPigmentCommunity Manager
posted in Questions & Conversations
Pigment API and Microsoft Excel (Pull & Push) examples

Microsoft Excel imports/exports can be achieved through using the Pigment
Import/Export API and Excel’s VBScript. It will need the following information:
1. Generate Pigment Import/Export API key
https://community.pigment.com/security-permissions-82/manage-api-keys-226 2. For
Imports into Pigment (to understand the process)
https://community.pigment.com/importing-and-exporting-data-95/how-to-trigger-an-import-with-apis-230
3. For Exports from Pigment (to understand the process)
https://community.pigment.com/importing-and-exporting-data-95/how-to-export-data-from-pigment-with-apis-229
4. The Excel work First enable Developer Tab in Excel Open Excel. Go to File >
Options. In the Excel Options dialog box, click Customize Ribbon. Check the
Developer checkbox and click OK. Create a VBA Macros Go to the Developer tab and
click Visual Basic. In the VBA editor, insert a new module: Right-click on any
existing module or the workbook name in the Project Explorer. Select Insert >
Module. Copy and

2
180
D

6 days ago
D

DamianAtPigmentCommunity Manager
posted in Questions & Conversations
Microsoft SQLServer RDBMS import into Pigment

Often, we get the request to load enterprise volume data from Microsoft
SQLServer RDBMS into Pigment, whilst Pigment doesn't have a dedicated SQLServer
connector or ODBC capability, this can easily be achieved via Pigment's import
API. Below is example code that connects to SQLServer, opens a cursor, executes
a SQL statement and imports the data into Pigment. 1. Generate Pigment Import
API key
https://community.pigment.com/security-permissions-82/manage-api-keys-226 2. For
Imports into Pigment (to understand the process)
https://community.pigment.com/importing-and-exporting-data-95/how-to-trigger-an-import-with-apis-230
3. To load data from Microsoft SQLServer RDBMS directly into Pigment via
Pigment's Import API using Python import pyodbcimport getpassimport requestsfrom
io import StringIOimport sysimport logging # Configure
logginglogging.basicConfig(level=logging.INFO, format='%(asctime)s -
%(levelname)s - %(message)s') # SQL Server Connection & SQL queryusername =
'SQLSERVER_USERNAM

0
290
D

6 days ago
D

DamianAtPigmentCommunity Manager
posted in Questions & Conversations
Oracle RDBMS import into Pigment

Often, we get the request to load enterprise volume data from an Oracle RDBMS
into Pigment, whilst Pigment doesn't have a dedicated Oracle RDBMS connector or
ODBC capability, this can easily be achieved via Pigment's import API. Below is
example code that connects to Oracle, opens a cursor, executes a SQL statement
and imports the data into Pigment. 1. Generate Pigment Import API key
https://community.pigment.com/security-permissions-82/manage-api-keys-226 2. For
Imports into Pigment (to understand the process)
https://community.pigment.com/importing-and-exporting-data-95/how-to-trigger-an-import-with-apis-230
3. To load data from an Oracle RDBMS directly into Pigment via Pigment's Import
API import oracledbimport getpassimport requestsfrom io import StringIOimport
sysimport logging # Configure logginglogging.basicConfig(level=logging.INFO,
format='%(asctime)s - %(levelname)s - %(message)s') # Oracle Connection & SQL
queryusername = 'ORACLE_USERNAME'connect_string = 'ORACLE_CONNECT_STR

0
270
D

7 days ago
T

Ta-WingNewly Minted Pigmenteer
asked in Questions & Conversations
How to set up a Map chart - Exclude countries

Exclude Countries I’m trying to show the Revenue by Country and where countries
have nil/zero revenue, how would you Exclude them so even the name doesn’t pop
up? I’m wondering is it because my main data set has all countries with the
longitude/latitude.

0
392
T

9 days ago
Show more activity
A

AravindJust Arrived
asked in Questions & Conversations
Changing data type of metrics

0
121

3 hours ago
W

William Murray BrownNewly Minted Pigmenteer
asked in Questions & Conversations
Dimensions of "seasonality" argument for SEASONAL_LINEAR_REGRESSION

0
254
W

2 days ago
E

EvlimeNewly Minted Pigmenteer
asked in Questions & Conversations
I want to set up a dimension from a calculation

0
383
E

3 days ago
P

pigment_enthusiastSeasoned Pigmenteer
asked in Questions & Conversations
RANK function - How to handle ties

0
8913
P

5 days ago
S

Sokhna Diarra NdiayeNewly Minted Pigmenteer
asked in Questions & Conversations
Revenue Metric

Hello Everyone, I want create a revenue metric. I Create all the dimensions and
transaction list. When I add a formula there is no problem of dimension, but the
value are only in January month. But in my transaction list the Dimension Month
is present. I dont understand why all the values are imported in only one month.
Here is my formula ( 'Sales History Unit'.unit [By Sum : 'Sales History
Unit'.month, 'Sales History Unit'.Customer, 'Sales History Unit'.'Product
Group'] ) Thanks a lot

0
577
S

11 days ago
A
Anonymous
asked in Questions & Conversations
companies change, profile stay?

Hi, I did have my profile on Pigment Community/Academy when working with another
company and I'd like to assign this new to the previous to one to not to loose
all my previous activity. How can I achieve this? Thanks!

0
141

11 days ago
N

NahNewly Minted Pigmenteer
asked in Questions & Conversations
Push data from Google Sheets Into Pigment

I successfully connected Google Sheets to Pigment. After initiating the data
import from Google Sheets to Pigment, I receive a message indicating that the
import was successful, but the data is not imported into Pigment and I get the
following error message: "Missing column in CSV Some header(s) in the mapping
configuration are not found in the CSV." However, the headers in the imported
file are identical to those in the Pigment list. You will find the screenshots
below.

0
514

13 days ago
P

P_AgrawalJust Arrived
asked in Questions & Conversations
API Import Set up

I am working on setting up an integration between TeamOhana (headcount platform)
and Pigment, which needs to be connected through an API request. Using this
link, I have been able to set up the API connection and the action button to
trigger the integration but I am unsure of where is the data getting pulled
into? Do I need to set up a transaction list beforehand and then somehow link
API request so the transaction data in Pigment gets updated? Essentially where
is my data going if the API request result shows successful? FYI: It is
Authentication: Bear <token> set up.

0
792
D

17 days ago
L

Laurence TemamJust Arrived
asked in Questions & Conversations
Pennylane

Hello, we have an affiliate using Pennylane. Have you already implemented the
API to import the general ledger into Pigment ? Thanks

0
281
R

19 days ago
C

Cedric LJSeasoned Pigmenteer
asked in Questions & Conversations
Remove duplicate leads

Hello,I Have the below list of leads and I want to count 1 in the column Count
only for the lastest lead of the company.The goal is to remove duplicate leads
of my lead analysis. Thanks

0
371

24 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

QUESTIONS & CONVERSATIONS

* 668 topics

JOB BOARD

* 82 topics

ANNOUNCEMENTS

* 36 topics

Welcome to the Pigment Community! 🎉

1 year ago

CUSTOMER LEADERBOARD

* Week
* All time

1
A

Aravind

20 points

2
Sam Gale

20 points

3
E

Evlime

10 points

4
oliverlee

6 points

5
JDLove

2 points

6
BenjiBegley

1 point

Show full leaderboard
1
CamilleMomo

5720 points

2
abhilashsawla

3943 points

3
CDALMAY

3328 points

4
Sofia Costa

2480 points

5
A

Alexandre

2473 points

6
R

rschimm

2323 points

7
MKohli

1903 points

8
agnar

1568 points

Show full leaderboard

BADGE WINNERS

* nickyunhas earned the badge Pigment Like a Pro
* Tatianahas earned the badge Pigment Like a Pro
* Gabriel Amaro da Luzhas earned the badge Pigment Like a Pro
* Axelgerardhas earned the badge Pigment Modeling Fundamentals Certified
* Eliohas earned the badge Read and Interpret Formulas Certified

Show all badges

EMPLOYEE LEADERBOARD

* Week
* All time

Show full leaderboard
1
Benoit

6535 points

2
Pierre

3304 points

3
Ben

2486 points

4
KarlW

2433 points

5
Keiran

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

Already have an account? Login

SINGLE SIGN-ON NEED HELP?

LOG INTO THE PIGMENT COMMUNITY

SINGLE SIGN-ON NEED HELP?

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.

THIS FILE CANNOT BE DOWNLOADED

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

community.pigment.com Open in urlscan Pro 2600:9000:214f:6400: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.pigment.com Open in urlscan Pro
2600:9000:214f:6400:10:8bf:5cc0:93a1 Public Scan

Form analysis
2 forms found in the DOM