Pigment Community | Community

Recently Active
Help Others
Categories

NakulNewly Minted Pigmenteer

Closing and Opening Balance

Need help on how to pull in previous month closing balance in Opening Balance Metric. Closing Balance refers to the Opening Balance. Basically Circular Ref, and just for ref need function similar to previous of Anaplan

6 hours ago

Sharon ConroyCommunity Manager

Importing and Exporting Data

Edit Pigment Integration Connections

Depending on the integration connector you are using, you can edit your connections to an external service without needing to create new ones. By being able to edit directly, you no longer need to set up a new connection, or to update each import configuration individually. More importantly, you can do this while also protecting your sensitive data. What is non-sensitive and sensitive data? Which integration connectors can I edit? Edit an External Service API IntegrationWhat is non-sensitive and sensitive data? When you edit an integrations connection in Pigment, it displays two types of fields you can update:Non-sensitive fields. These fields include information like user name, connection name, account ID, API endpoint, and so on. These fields are pre-populated with existing values from the integration. When you click Save, Pigment updates the values in these fields even if they haven't been changed. Sensitive fields. These fields include API tokens, private keys, and so on. These f

18 hours ago

Cedric LJSeasoned Pigmenteer

Questions & Conversations

Combine Previous(month) and BY modifier

Hi,In the below metric with 2 dimensions Month and Version, I try to combine a Previous (Month) and a BY.For now I have the error formula is invalid.The trick I found (please see the second screenshot) is to create a second metric “Other cash test” so I can apply BY .Thanks for your help,

21 hours ago

AdamOccasional Observer

Questions & Conversations

Picking a dimension property dependently on scenario

Hi Pigment Experts, I have the following challenge. I have two properties in a an Employee dimension list (Department_Apr and Department_Mar). Employees may move between departments and these properties are reflecting that. Then I have a metric by Employee which I want to pivot by Department. I use the formula below and it works well. My question is is there a way to write formula so the metrics is either by Department_Apr or Department_May dependently on a Scenario i.e. dependently on input to another metric? The way it works now is that Department_Apr or Deparment_Mar are hardcoded but how to make these values a variable? if('Is Forecast (Headcount)', '361. Total Headcount Cost - A+F') [remove: '01. Payroll Waterfall', '01. Headcount Cost Account'][select: '01. FinType'."P&L"][select: '01. Version' = 'Version Push'] //."Mar Month End"][filter: '01. Employee ID'.OperRepairs = '01. Operations/Repairs'."N" and '01. Employee ID'.RetailTR = '01. Retail Branch / TR'."N"][by: '01. Emp

21 hours ago

Jessica TNewly Minted Pigmenteer

Questions & Conversations

Connector: Gsheet with Pigment

Bonjour, Je voudrais savoir si ce serait possible lors d’un extract de Pigment à Google sheet via le connector de ne pas avoir des lignes vides? Ex: Lors d’un extract avec le connector, j’ai 30.000 lignes et sur ses 30.000 lignes j’ai 10.000 lignes utilent et qui contiennent des valeurs. Cela alourdi énormément les fichiers de travail.Dans les tables (extracts) dans Pigment, il y a une possibilité de filtrer et de mettre (Hide empty rows and columns). Ceci empêche d’avoir des milliers de lignes vides pas utiles.Dans l’attente d’un retour, veuillez passer une belle journée :).Cordialement.TEGUA Jessica.

21 hours ago

MKSMPBBudding Pigmenteer

Questions & Conversations

How to align a property in one dimension with another dimension

Hi, I am looking to combine a transaction list (actuals) with a forecast metric using a cost centre dimension.I have the cost centre dimension in my transaction actuals but in the forecast it is a property in another dimension (property type is dimension and selected as the same one in the actuals). What function should i be using in my formula in order to bring both in combined at the cost centre level?

1 day ago

HarshilNewly Minted Pigmenteer

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!

2 days ago

PierreCommunity Manager

Functions

SEASONAL_LINEAR_REGRESSION function

DescriptionComputes a linear regression by fitting a straight line to the data and taking seasonality into account. SyntaxSEASONAL_LINEAR_REGRESSION(Input Block, Seasonality [, Ranking Dimension]) ArgumentsArgument Type Dimensions Description Input Block (required) Number Any Dimensions This is the data source on which the seasonal linear regression is computed, and must be a Metric with data points as an expression of Integer or Number type. This Metric must include the same Dimension that is used in the Ranking Dimension argument. Seasonality (required) Integer No Dimension or Dimensions of Text 1 Length of the seasonality. It must be greater than 1, for example, if you observe a quarterly on a Metric defined by month, the Seasonality length is 3. If you observe a yearly seasonality on a Metric defined by month, the Seasonality length is 12. Ranking Dimension (optional) Dimension Not applicable This is a Dimension applied to the tim

650

3 days ago

BenoitCommunity Manager

Job Board

The FP&A Jobs Report #79 (Gusto, Chanel, Gong, Spotify...)

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 weekHighlights Chanel [RETAIL] Head of Corporate FP&A 📍London, UK Chanel is a private company and world leader in creating, manufacturing and distributing luxury products. KellyDeli [FOOD & BEVERAGE SERVICES] Head of FP&A 📍Remote, UK KellyDeli is a fast-growing, innovative food company committed to bringing the best of Asia to the world. Qare [HOSPITALS & HEALTH CARE] Head of FP&A 📍Levallois-Perret, FR Qare.fr is a French telemedicine platform that connects patients with healthcare professionals for remote medical consultations. Gusto [HRTECH] Corporate Finance Manager 📍New York, NY Gusto is a modern, online people platform that helps small businesses take care of their teams. Other Positions Gon

310

4 days ago

KevinSeasoned Pigmenteer

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.

4 days ago

Cedric LJSeasoned Pigmenteer

Questions & Conversations

Combine Previous(month) and BY modifier

21 hours ago

AdamOccasional Observer

Questions & Conversations

Picking a dimension property dependently on scenario

21 hours ago

Jessica TNewly Minted Pigmenteer

Questions & Conversations

Connector: Gsheet with Pigment

21 hours ago

MKSMPBBudding Pigmenteer

Questions & Conversations

How to align a property in one dimension with another dimension

1 day ago

HarshilNewly Minted Pigmenteer

Questions & Conversations

Show scenario variance and YoY variance in the same table

2 days ago

Chris EJust Arrived

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?

9 days ago

jameslJust Arrived

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)

14 days ago

keerthanarameshBudding Pigmenteer

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 metricI’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?

16 days ago

DmitriiSeasoned Pigmenteer

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?

17 days ago

Adrien LEmployee

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.

22 days ago

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

506 topics
1377 Replies

Job Board

76 topics
1 Reply

Announcements

24 topics
30 Replies

Events Calendar

Customer Leaderboard

Show full leaderboard

Badge winners

kristian.bartelhas earned the badge Innovator
Sixbert Cyizahas earned the badge Pigment Modeling Fundamentals Certified
klanehas earned the badge Pigment Modeling Fundamentals Certified
Younes YOUSSIhas earned the badge Partner Solution Consultant Certified
Championhas earned the badge Pigment Modeling Fundamentals Certified

Show all badges

Employee Leaderboard

Show full leaderboard

Welcome to the Pigment Community!

Explore the Community

Get Started with Pigment

Browse Documentation

Become a Pigment Pro

⭐ Featured Articles ⭐

Explore the Community

Closing and Opening Balance

Edit Pigment Integration Connections

Combine Previous(month) and BY modifier

Picking a dimension property dependently on scenario

Connector: Gsheet with Pigment

How to align a property in one dimension with another dimension

Show scenario variance and YoY variance in the same table

SEASONAL_LINEAR_REGRESSION function

The FP&A Jobs Report #79 (Gusto, Chanel, Gong, Spotify...)

Chart Legend Not Displaying Bottom Center

Combine Previous(month) and BY modifier

Picking a dimension property dependently on scenario

Connector: Gsheet with Pigment

How to align a property in one dimension with another dimension

Show scenario variance and YoY variance in the same table

NetSuite Balance Sheet - Month over Month Historical

Balance Sheet

Breakdown by same dimension

Scenarios in security metrics?

Key shortcut

Explore the Community

Community Welcome Guide

Questions & Conversations

Job Board

Announcements

Events Calendar

Customer Leaderboard

Badge winners

Employee Leaderboard

Need more help?

Contact support

Welcome to the Pigment Community!

⭐ Featured Articles ⭐

Explore the Community

Events Calendar

Customer Leaderboard

Badge winners

Employee Leaderboard

Need more help?

Sign up

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Scanning file for viruses.

This file cannot be downloaded