community.gopigment.com
Open in
urlscan Pro
2600:9000:214f:d200:10:8bf:5cc0:93a1
Public Scan
Submitted URL: http://community.gopigment.com/?wp-verify-link
Effective URL: https://community.gopigment.com/?wp-verify-link
Submission: On February 12 via api from DE — Scanned from DE
Effective URL: https://community.gopigment.com/?wp-verify-link
Submission: On February 12 via api from DE — Scanned from DE
Form analysis
2 forms found in the DOMGET /search/index
<form method="get" action="/search/index">
<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"><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" 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__445265833" 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="Q5i-2o5Ltqv8KZCaVKCyEhIfWIQKkNmJZng7t03x9wY">
</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 & Conversations454 * Job Board67 * Announcements22 * Knowledge Base * * * Search the Knowledge Base * Documentation * Getting Started23 * Modeling & Formulas40 * Functions100 * Reporting & Data visualization36 * Collaborating on Pigment18 * Security & Permissions27 * Importing and Exporting Data53 * Legal information1 * Become a Pigment Pro * Modeling Principles7 * Modeling Guides41 * 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 ⭐ * How to set up an Org Chart * Metric to Metric Importing * The Pigment Community is levelling up – introducing our new badge and rank system! 🏅 * 7 questions to ask before bringing new data into Pigment * Pigment in Action: How to calculate streak cumulations * How Pigment implements new use cases in our internal Workspace * How to make your formulas easier to understand * The FP&A Jobs Report #66 (Spring Health, Lego, Microsoft, Qonto...) EXPLORE THE COMMUNITY * Recently Active * Help Others * Categories R RohitDivate_GustoJust Arrived asked in Questions & Conversations HAS ANYONE TRIED INTEGRATING CAPIQ WITH PIGMENT FOR PUBLIC COMPANY BENCHMARKING? Curious to know if there any 1st or 3rd party connectors to get capiq data directly in pigment automatically. It’s not too difficult to upload a CSV on a monthly cadence, but would be great if there was a live connection. The alternative is to send this to an internal DWH then to Pigment, but that might be a lot of internal work from our BI teams. 00 R 2 days ago Y YaejisNewly Minted Pigmenteer asked in Questions & Conversations SAVING CALCULATION Hi! Can someone please help with setting up the formula for below? Thanks in advance! ---- Dates: Given Data (yellow highlighted) Question: I am seeing for formula to get the result below yellow highlighted row, “Result”. The calculation starts from 3rd months from the start date, 10/31/2022. So it needs to calculate “January value 18,792 minus start date value 18,792. The result for 2023 Jan is zero. Then, calculation is same concept but moves forward. It’s always deducting the start date value, 18,792. For July 2023, calculation is July 2023 19,355 minus the start date value 18,792, resulting 564. The calculation should stop in Bridge end date, 12/31/2023. Thank you! 13 Y 2 days ago P PaylwardNewly Minted Pigmenteer asked in Questions & Conversations DEMO IDEAS Hello, I have gone through all of the available training and videos for Pigment modules and setting up Demos. I would like to know if there are any additional Demo resources and data I can use to test my skills. 22 3 days ago BenjiCommunity Manager published in Job Board THE FP&A JOBS REPORT #70 (CIRCLE, TIDE, OPENAI...) For all the new joiners, a quick reminder of what you get with this newsletter:👉🏾 Around 10 fresh job offers👉🏻 From top companies worldwide👉 Every week Executive Roles [FINANCIAL SERVICES] Head of Strategic Finance 📍LA/NY, US Circle helps businesses and developers harness the power of stablecoins for payments and internet commerce worldwide. [FINANCIAL SERVICES] FP&A Director 📍London, UK Tide is a financial technology company that provides business banking services tailored for small and medium-sized enterprises (SMEs). Head of FP&A 📍Uusimaa, FI Finatal is a UK-based recruitment consultancy firm specialising in finance and accounting roles within the private equity and venture capital sectors. [MANUFACTURING] Head of FP&A 📍Augsburg, DE KUKA is one of the world’s leading suppliers of intelligent automation solutions, offering customers everything they need from a single source. Hiring? Submit a job! Other Roles [FINANCE SERVICES] Strategic Finance Manager 📍London, UK Zilch i s 1160 3 days ago K KevinSeasoned Pigmenteer asked in Questions & Conversations IS IT POSSIBLE TO USE PREVIOUS() SIMULTANEOUSLY ACROSS MULTIPLE DIMENSIONS? I am building an attrition model based on month dimension and a dimension called ‘30 Day Cohort’. I am almost certain that I will run into a circular reference if I do not use the Previous function. However, because I am working with 2 dimensions I am unclear on how to reference the previous month and previous ‘30 Day Cohort’ dimension simultaneously. Is this possible? Can I combine multiple Previous functions? Is it possible to nest two Previous functions? To start my model, I have “initialized” the metric with both the starting values in the first month and the forecasted new subscribers in the first ‘30 Day Cohort’ (0 in my case): What I would like to do is calculate a formula on the value in the previous month and previous cohort and then do so recursively (this is why I think I need to use the Previous function). So for Oct 23 and cohort 1, I would want to do my calculation based on the Sep 23 and cohort 0 value (1,895); for Oct 23 and cohort 2, I would want to do my calculation b 18 B 3 days ago C Carolina LeeBudding Pigmenteer asked in Questions & Conversations BALANCE SHEET: NET INCOME Which formula can I use for Net Income at my balance sheet in the begging of the year where I need to transfer all Net income to Retained earnings / losses and start accumulate again? See below an example. I read this article below but I couldn’t understand: 14 P 3 days ago M mmusabSeasoned Pigmenteer asked in Questions & Conversations REPEATING SET OF VALUES UNTIL THE A CERTAIN CONDITION Hi Team I have a calc which uses Year dimension and the year starts from 1 to 20. There is an assumption metric which defines what year the crops will be harvested. So lets say currently the assumption is year 6 in which the crops will be harvested, then from that year onward second rotation will start and then follow similar process until Year 6 where it again will be harvested and planted again. So as an example in excel, you can see from FY19 the year starts as 0 as that is where initial plantation happen. Then it counts from Year 1 to 6 and then at Year 6 which is equal to our assumption metric (Year 6) as well, it stops and then a new cycle starts from 0 to 6 all over again. How can we built something like this easy way? I have tried thinking of using MOD in which lets say in our Year dimension, we have count column as well that goes from 1 to 20 . So what i am doing is saying if Year.Count/Assumption metric =0, then mark it as harvest year. Now how can i get it to count and reset 01 4 days ago P ParapebuneNewly Minted Pigmenteer asked in Questions & Conversations HOW TO CREATE A WEIGHTED DISTRIBUTION Hi! I have a sales volumes metric with dimensions Category, Channel, Product and Month. Data was imported from a transaction list. I want to adjust this with some volumes that are manually input by user per channel, but I want to spread this values on every product using the same weighted distribution per category and month as the initial data. For example, if on month Jun, on a product, the volume was 15% of the total, I want to add on that product for Jun 15% of the manually added volume. How do I achieve that? Thanks in advance! 01 S 4 days ago SyuenCommunity Manager published in Functions IFDEFINED FUNCTION Description Fills the defined values of an expression with a given value. Syntax IFDEFINED(Expression containing values, Value if defined, Value if blank ) Arguments Argument Type Description Expression containing values (required) Any Expression containing Values. Value if defined (required) Any Expression containing value you want to fill if the argument Expression containing values contains values. This needs to be the same type as the argument Value if blank. Value if blank (optional) Any Expression containing the value you want to fill if the argument Expression containing values contains no values (BLANK). This needs to be the same type as the argument Value if defined. This is an optional argument, so if no value is provided for this argument, it returns BLANK. Returns Type Output Structure (Dimensions) Same type as Value if defined / Value if blank All Dimensions in the arguments Expression containing values, Value if defined, Value if blank. Examples Formula Result Description 1490 4 days ago M Moosa MalickNewly Minted Pigmenteer asked in Questions & Conversations REMOVING BLANKS IN TRANSACTIONS LIST Hi, Is there a way to remove blank cells in the grid of a transactions list. I am applying a filter to the transactions list which gives me blank rows which I want to get rid of. Thanks 04 M 4 days ago Show more activity R RohitDivate_GustoJust Arrived asked in Questions & Conversations HAS ANYONE TRIED INTEGRATING CAPIQ WITH PIGMENT FOR PUBLIC COMPANY BENCHMARKING? Curious to know if there any 1st or 3rd party connectors to get capiq data directly in pigment automatically. It’s not too difficult to upload a CSV on a monthly cadence, but would be great if there was a live connection. The alternative is to send this to an internal DWH then to Pigment, but that might be a lot of internal work from our BI teams. 00 R 2 days ago K KevinSeasoned Pigmenteer asked in Questions & Conversations IS IT POSSIBLE TO USE PREVIOUS() SIMULTANEOUSLY ACROSS MULTIPLE DIMENSIONS? I am building an attrition model based on month dimension and a dimension called ‘30 Day Cohort’. I am almost certain that I will run into a circular reference if I do not use the Previous function. However, because I am working with 2 dimensions I am unclear on how to reference the previous month and previous ‘30 Day Cohort’ dimension simultaneously. Is this possible? Can I combine multiple Previous functions? Is it possible to nest two Previous functions? To start my model, I have “initialized” the metric with both the starting values in the first month and the forecasted new subscribers in the first ‘30 Day Cohort’ (0 in my case): What I would like to do is calculate a formula on the value in the previous month and previous cohort and then do so recursively (this is why I think I need to use the Previous function). So for Oct 23 and cohort 1, I would want to do my calculation based on the Sep 23 and cohort 0 value (1,895); for Oct 23 and cohort 2, I would want to do my calculation b 18 B 3 days ago M mmusabSeasoned Pigmenteer asked in Questions & Conversations REPEATING SET OF VALUES UNTIL THE A CERTAIN CONDITION Hi Team I have a calc which uses Year dimension and the year starts from 1 to 20. There is an assumption metric which defines what year the crops will be harvested. So lets say currently the assumption is year 6 in which the crops will be harvested, then from that year onward second rotation will start and then follow similar process until Year 6 where it again will be harvested and planted again. So as an example in excel, you can see from FY19 the year starts as 0 as that is where initial plantation happen. Then it counts from Year 1 to 6 and then at Year 6 which is equal to our assumption metric (Year 6) as well, it stops and then a new cycle starts from 0 to 6 all over again. How can we built something like this easy way? I have tried thinking of using MOD in which lets say in our Year dimension, we have count column as well that goes from 1 to 20 . So what i am doing is saying if Year.Count/Assumption metric =0, then mark it as harvest year. Now how can i get it to count and reset 01 4 days ago P ParapebuneNewly Minted Pigmenteer asked in Questions & Conversations HOW TO CREATE A WEIGHTED DISTRIBUTION Hi! I have a sales volumes metric with dimensions Category, Channel, Product and Month. Data was imported from a transaction list. I want to adjust this with some volumes that are manually input by user per channel, but I want to spread this values on every product using the same weighted distribution per category and month as the initial data. For example, if on month Jun, on a product, the volume was 15% of the total, I want to add on that product for Jun 15% of the manually added volume. How do I achieve that? Thanks in advance! 01 S 4 days ago OlaNewly Minted Pigmenteer 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? 00 10 days ago P ParapebuneNewly Minted Pigmenteer asked in Questions & Conversations MANUAL INPUT BOARD Hi! I have a numeric metric of volumes of selling items with dimensions: item, channel, category, month For this metric I have some volumes imported from a transaction list. Apart of these volumes I want to use an input board which allows me to manually input extra volumes per item/channel/category/month which will finally add to the imported volumes. In the board, the input widget should show all the items that were manually input and should have the option to input a new volume based on the dimension selection. How do I do that? Thanks in advance! 05 10 days ago J JoseBudding Pigmenteer asked in Questions & Conversations GETTING THE SEASONALITY FOR FORECAST_ETS FUNCTION Dears, I have the historic sales per month, and we have strong seasonality, but also and upward trend. I would like to use the FORECAST_ETS function, however, I don’t understand how to get the value of seasonality. For example I know every July and August we have a drop and then it gets higher on September. In this case the seasonality would be 12? If I want something more exact can I use Python and then get the equation and plug in pigment? For calculating a better seasonality number, alpha, beta and gamma, is there a way to get those numbers in Pigment, or I need to have another application, such as Python or R? Thanks in advance! Jose 02 12 days ago M Mart.Just Arrived asked in Questions & Conversations CREATING A DIMENSION LIST AND TRANSACTION LIST How do I create a dimension list (step by step process), How do we know what fields would be a dimension, for example, would a product type classified as text or dimension? or customer classification (New/Existing) be a text or dimension.Also, how does this feed to the transaction list, when importing a csv file.When the transaction list is then created, how do I create metrics, chart and tables from this transaction list. 01 19 days ago B Brian LeseJust Arrived asked in Questions & Conversations LOOKER WEBHOOK IMPORT ISSUE I am attempting to import data from Looker via webhook but am receiving a CSV Format & Mapping error each time. I have the saved import configuration ID correct in the webhook address, but when importing, it seems like Pigment does not recognize the column headers. I was careful to import the same exact CSV when setting up the configuration, it should have the same headers. Would anyone be able to advise on this? 01 1 month ago A anjanaNewly Minted Pigmenteer asked in Questions & Conversations UPDATE A FORMULA I have a formula on my data load table, which automatically attributes a ‘clean’ code to an uploaded busline code. For eg. If a country NG uses XXXNOTALLOC , the clean code attributed to it is XXXNOTALOCNG The formula is the following : if(('Actuals P&L Data Load'.'Busline Code - Warehouse' = Busline."LOCCENTRALTN" or 'Actuals P&L Data Load'.'Busline Code - Warehouse' = Busline."LOCCENTRAL")and 'Actuals P&L Data Load'.id_company='Legal Entity'."JT_TN",Busline."LOCCENTRALTNSSC", if('Actuals P&L Data Load'.'Busline Code - Warehouse' = Busline."LOCCENTRAL" or 'Actuals P&L Data Load'.'Busline Code - Warehouse'.'is not alloc',ifblank(item('Actuals P&L Data Load'.'Busline Code - Warehouse'.'Original - Busline'& 'Actuals P&L Data Load'.'Company Country - Warehouse'.Code,Busline),'Actuals P&L Data Load'.'Busline Code - Warehouse'), 'Actuals P&L Data Load'.'Busline Code - Warehouse')) I dont want this to happen, I want to code to stay at XXNOTALLOC. I am not sure if this will have repurcussions 08 A 1 month 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 * 454 topics * 1233 Replies JOB BOARD * 67 topics * 1 Reply ANNOUNCEMENTS * 22 topics * 30 Replies Welcome to the Pigment Community! 🎉 10 months ago EVENTS CALENDAR CUSTOMER LEADERBOARD * Week * All time Show full leaderboard 1 abhilashsawla 3721 points 3721 points 2 CamilleMomo 3243 points 3243 points 3 Sofia Costa 2320 points 2320 points 4 A Alexandre 2062 points 2062 points 5 MKohli 1772 points 1772 points 6 R rschimm 1713 points 1713 points 7 C Chelsea 1474 points 1474 points 8 agnar 1318 points 1318 points Show full leaderboard BADGE WINNERS * Jan Kolarhas earned the badge Pigment Modeling Fundamentals Certified * Patriciahas earned the badge Pigment Modeling Fundamentals Certified * bmilikhas earned the badge Pigment Modeling Fundamentals Certified * Nikita Pohas earned the badge Pigment Modeling Fundamentals Certified * Leshas earned the badge Pigment Modeling Fundamentals Certified Show all badges EMPLOYEE LEADERBOARD * Week * All time Show full leaderboard 1 Chris 11015 points 11015 points 2 Benoit 5065 points 5065 points 3 Benji 3651 points 3651 points 4 Pierre 2631 points 2631 points 5 Ben 2039 points 2039 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! 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 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. OK THIS FILE CANNOT BE DOWNLOADED Sorry, our virus scanner detected that this file isn't safe to download. OK