- - Search the Knowledge Base
Academy
Product Roadmap
Events
Groups

Community
Explore the Community

Explore the Community

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

780 Topics

Recently active

Most replies Most views Newest first

Elliot TrabacJust Arrived

asked in Questions & Conversations

Loading data from Pigment into BigQuery

Hey team, Can we load data from Pigment into BigQuery? Thanks

941

1 year ago

KhadijaFrequent Reader

asked in Questions & Conversations

Accidentally deleted property content

I accidently changed a property from text to dimension and I lost all the date that was on the property of this dimension, this dimension list is extremely crucial and is the building block of other boards. Is there anyway I can have it back please?

1761

1 year ago

AhmedBBudding Pigmenteer

asked in Questions & Conversations

Cumulate Last Twelves Months

Hi Pigment community,I want to realise a LTM (Last Twelves Months) analysis for a metric.For the moment, I’m able to cumulate only by the beginning of the period with the function:CUMULATE(Revenues,Month)[Filter: Month.Year = Year."FY 22" OR Month.Year = Year."FY 23" OR Month.Year = Year."FY 21"]I can make it “restart” each year with using CUMULATE(Revenues,Month,Month.Year) but I want to cumulate the last 12 Months onlyLTM Revenue Feb 22 should be starting from Feb 21 and not Jan 21.How can I do that?Many thanks

3402

1 year ago

Kamil SobczakBudding Pigmenteer

asked in Questions & Conversations

How to change the Y-axis scale for Bar Chart?

Hi everyone, How can I change the scale on y axis for bar chart? Pigment has set up the scale automatically which is not perfect as I would prefer to see it starting from 0. Is there a way to update this?

821

1 year ago

abhilashsawlaPigment Academic

asked in Questions & Conversations

Vertical Waterfall Chart

Hi friendsI am unable to build vertical waterfall chart so, I would like to know how we can build vertical waterfall chart, if it is possible.

1772

1 year ago

Nicolas BauvoisJust Arrived

asked in Questions & Conversations

TIMEOUT API EXPORT ExportTableData

Hello,I need to export a Table with API, when I test in Postman my get URL, I have an error 500 after 15 seconds.When I filter my table in Pigment, it works so can we adjust the API timeout ?Thank’s for your help.Nicolas.

1391

1 year ago

BenjiEmployee

published in Job Board

FP&A Jobs #28 - Apr 21st (Webflow, Adevinta, ActiveCampaign, CloudBees...)

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 Thursday Want this in your inbox every week? Sign up here! Executive positions1️⃣ [SOFTWARE] VP Finance @Armis Security, the leader in asset visibility and security addressing the new threat landscape created by connected assets.This position reports directly to the CFO. You will be responsible for implementing financial processes and systems as Armis continues to grow, heading towards IPO and beyond. Experience leading a company through an IPO process and operating as a public company post IPO; this leadership role actively partners with other leaders across Armis in addition to leading the finance organization.📍 New York, US 2️⃣ [CHEMICAL] Director, Financial Planning @LGC, an international life sciences measurement and tools company.The Director Financial Planning role involves developing and managing financial analysis procedures,

610

1 year ago

BenjiEmployee

published in Announcements

Welcoming the Community Lounge!

Welcoming the Pigment Community Lounge, our new corner of Community dedicated for casual discussion 💬 Weekly questions, FP&A industry talk, favourite movie – what have you! Come share in the Lounge :) The purpose of the community is to promote connection among Pigment users, which is why we want to get to know you even better. Go check it out here, see you in the Lounge!

3040

1 year ago

MKohliSeasoned Pigmenteer

asked in Questions & Conversations

Looker Import Issues when Pushing All Results

Hi Community,Having a weird issue where when scheduling a webhook push from looker I’m unable to import all the data when setting the delivery to be All Results vs Results in Table. When doing Results in Table i’m able to import everything instantly but when configuring and sending a test for all results it doesn’t seem like any import is kicked off. Wondering what is occurring on the backend and if this a looker or Pigment issue. Setting I need to apply When having it for Results in table the import worked

2483

1 year ago

Dominick GonzalezOccasional Observer

asked in Questions & Conversations

Link address to email

Hello Team, I am reaching out to see if the functionality within the dashboard “add an action button” allows end users to open an external link directly to an email address. Thus far, I’ve tried entering mailto: genericemail@company.com and I’m met with an error prompt.Is this functionality available in Pigment yet?

641

1 year ago

HamzaNewly Minted Pigmenteer

asked in Questions & Conversations

The difference in income between two months

I need to add a column to calculate the income [ m- (m-1)] in order to get the difference in income between two months do you know how to do it Thanks

782

1 year ago

ElodieSeasoned Pigmenteer

asked in Questions & Conversations

Access rights in tables

Hello!I have created AR rules to give a person access to one country only. I have verified the access on all blocks through the impersonate feature and everything seems to be working. However, the person doesn’t have access to some tables (though he has access to the correct data in the metrics composing the table)… This message appears:Could you please help me to understand what is happening here?Thanks!Elodie

622

1 year ago

abhilashsawlaPigment Academic

asked in Questions & Conversations

Best practic for Actual, Budgeting and forecasting Analysis

I would like to know what is the best practice for Actual , Budgeting and forecasting.Option 1: Create a separate Version DimensionOption 2: Create Scenario for Actual, Budgeting and forecasting

1752

1 year ago

BenjiEmployee

published in Announcements

Come say hi! Pigment User Group Meetups April and May: Paris, NYC, Boston & San Francisco

Pigment User Group meetups are here again! 😍Join us to meet the Pigment team and fellow Pigment users for an afternoon of program and mingling 🎉 The goal of the Pigment User Groups is to connect, elevate, and inspire a community of customers within their local area to meet each other in person (and receive some Pigment swag ofc). When & Where?San Francisco: April 26th Paris: April 27th New York City: May 10th Boston: May 11th How do I sign up?Get in touch with your CSM for further details and to secure a spot! :) Agenda:1:45pm - 2:00pm Arrivals2:00pm - 5:00pm Program5:00pm - 7:00pm Happy Hour See you there! 👋

3910

1 year ago

BenjiEmployee

published in Job Board

FP&A Jobs #27 - Apr 14th (Deliveroo, Carlsberg, Calendly...)

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 weekExecutive positions1️⃣ [SOFTWARE] Vice President, Financial Planning & Analysis @ Acumatica, a cloud ERP company that provides cloud business management software for small and mid-size businesses.Acumatica is hiring a VP of FP&A to lead their worldwide financial planning and analysis team. The position is critical to Acumatica’s continued growth and development. The responsibilities of the role include building and leading a best-in-class worldwide FP&A function, developing and maintaining high-quality business partnering activities, and collaborating with executives to provide financial expertise and guidance on strategic initiatives.📍 Kirkland, US 2️⃣ [SOFTWARE] Senior Director, Technology & Services FP&A @ Deltek, the leading provider of small business and enterprise software for project-based businesses.The

660

1 year ago

Jessica TNewly Minted Pigmenteer

asked in Questions & Conversations

Conditional formatting

Hello,Can you please tell me how I can make a conditional formatting based on another column? Ex: I have column A & B and I want column A figures to change colors depending of it they are greater or lower than column B figures.Also, how can I center figures in a table on Pigment, if that is possible. Thanks.

3553

1 year ago

BenjiEmployee

published in Job Board

FP&A Jobs #26 - Apr 11th (WeTransfer, Deliveroo, Faire, Peloton...)

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📣 Research opportunity with Pigment 📣Our research team at Pigment is looking to learn more about individuals in Finance teams at growing companies. We are looking to speak to individuals working in Finance teams at businesses with over 2,000 employees. The team will give you a gift voucher for your time. If this sounds interesting, drop an email to ellen.humphreys@gopigment.com.Thank you!Executive positions1️⃣ [SOFTWARE] Vice President, Financial Planning & Analysis @ Billtrust, the leading innovator in AR automation and B2B payments.As the Vice President of Financial Planning and Analysis you will be responsible for providing management with an analysis and insight of Billtrust’s financial results in coordination with the broader Finance team. You will oversee all aspects of the annual budget, quarterly forecasts, data analyt

710

1 year ago

MuzNewly Minted Pigmenteer

asked in Questions & Conversations

How to see Budget vs Actual totals separately?

I have created a monthly P&L with Budget vs Actual columns. When I want to see YTD numbers, the total column at the end adds up both Budget & Actual numbers. Is there a way to see the totals for Budget and Actual separately?

34412

1 year ago

ChrisEmployee

published in Announcements

Changes to Autosave in Sheet View and Blocks

Hello friends, On Friday April 14th, we will be making some changes to the Autosave functionality and the default Autosave behavior when inputting data in Sheet View. What is the “Autosave off” feature that will be released on April 14th? Now Members with Configure Blocks permission will have a block-level setting controlling Autosave. This setting is now available on all block types and determines if inputs within the block are automatically saved or not. While already existing, the Autosave functionality was changed to expand its functionality to Boards for all types of display modes and not only Sheet view, making it more accessible to Members inputting data on Boards. This change also enables the autosave setting to be consistent across users and views. How does this impact Sheet view? On April 14th, Sheet view’s default behavior will change from Autosave being off to Autosave being turned on. This means Members will no longer have to save inputs before they sync with the rest of

4530

1 year ago

HamzaNewly Minted Pigmenteer

asked in Questions & Conversations

Converting date column to month dimension

5203

1 year ago

abhilashsawlaPigment Academic

asked in Questions & Conversations

Reagarding maximum Size of Excel which can be import manually easily

Asking just for knowledge,What maximum size of excel can we import manually in transaction List?If our excel size is more than required size than what solution is available in Pigment.

1753

1 year ago

AlexandreSeasoned Pigmenteer

asked in Questions & Conversations

Dimension and addition of 2 metrics

Hello,I have 2 metrics :Actual with Dimensions : Client, Region, Sales Area, Period Type (Actual) Budget with Dimensions : Region, Sales Area, Period Type (Budget)I want to add these 2 metrics and keep the Client dimension. If I select Budget as Period Type, I just want BLANK for the Client dimension, if I select Actual as Period Type, I want the figures for the client dimension.Is it possible to do it ?Thank you

1523

1 year ago

NicoleGilmourJust Arrived

asked in Questions & Conversations

Best way to calculate yield?

Hi Everyone, I’m trying to find a more efficient solution to modeling our yields. We have several dimensions by which we measure yields (region, segment, ramp status, etc...) and currently have separate blocks for each measure which can lead to confusion. I would like to consolidate yield calculations into a few blocks and pivot from there on the necessary dimensions. Any ideas on how to best set up yields?

2021

1 year ago

AlexandreSeasoned Pigmenteer

asked in Questions & Conversations

Import API

Hello,Is there a way to receive an email if an automatic import with an API fail ?Thanks,Alexandre

3826

1 year ago

BenjiEmployee

published in Job Board

FP&A Jobs #25 - Mar 31st (Faire, Calendly, Carlsberg...)

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 FridayExecutive positions1️⃣ [ADVERTISING] Associate Director, Financial Planning and Analysis @ Publicis Group, the third largest communications group in the world.Partner with Department leads to understand business needs and translate into a departmental expense forecasts. Take a business interest in managing forecasting accuracy of amounts, monthly phasing and categorization. Proactively question processes and procedures and implement change to gain efficiencies and streamline workflows.📍 Chicago, US 2️⃣ [FOOD&BEVERAGE] Director Group FP&A @ Carlsberg Group, one of the leading brewery groups in the world.Augment data with business insights to identify opportunities that can help drive the top-line growth and/or cost reduction. Hold functions and regions accountable for performance, advising the senior finance and business l

910

1 year ago

Page 22 / 32

Badge winners

Damien Khas earned the badge Pigment Modeling Fundamentals Certified
PBochenekhas earned the badge Read and Interpret Formulas Certified
Tyler.Tranhas earned the badge Innovator
DavidEd1056has earned the badge Read and Interpret Formulas Certified
Bernadinehas earned the badge Read and Interpret Formulas Certified

Show all badges

Terms & Conditions Cookie settings

Sign up

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

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.