- - Search the Knowledge Base
Academy
Product Roadmap
Events
Groups

Community
Explore the Community
Questions & Conversations

Questions & Conversations

Got a question about your models? Want to start a discussion? It's here!

501 Topics
1,367 Replies

When you subscribe we will email you when there is a new topic in this category

501 Topics

Recently active

Most replies Most views Newest first

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?

11 months 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

11 months ago

Kamil SobczakOccasional Observer

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?

11 months 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.

11 months 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.

11 months 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

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?

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

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

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

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.

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?

1 year ago

HamzaNewly Minted Pigmenteer

asked in Questions & Conversations

Converting date column to month dimension

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.

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

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?

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

1 year ago

Jan VeermanBudding Pigmenteer

asked in Questions & Conversations

Set up a new SFTP connection

Setting up SFTP question → submitted a request for it

1 year ago

abhilashsawlaPigment Academic

asked in Questions & Conversations

Regarding List Property

Hi Community Members,I would like to know for knowwledge that there is any limitation to create no list properties and no of rows in Dimension and transaction List of pigment.Means:How many no of properties and rows can we create in Dimension and Transaction List?

1 year ago

abhilashsawlaPigment Academic

asked in Questions & Conversations

NPV & XNPV Functions

Hi Pigment Team,Could you please share examples of NPV and XNPV Function in details?

1 year ago

Omer NahumOccasional Observer

asked in Questions & Conversations

Top 10 in Chart

Hi Pigment, Do we have the ability to create a pie chart with only the top 10 of specific dimension values?I wish to have this Chart live with the most updated Top 10 values. Thank you,Omer.

1 year ago

SaiNewly Minted Pigmenteer

asked in Questions & Conversations

Deleting scenarios but preserving data from a child scenario

I’m looking to delete scenarios from my application; however, I’d like to retain the data from a child scenario instead of the parent scenario. Is this possible to do?

1 year ago

AlexandreSeasoned Pigmenteer

asked in Questions & Conversations

Matching 2 Transaction Lists without unicity

Hello,I have 2 Transaction Lists :List 1 : with Doc # (string), Parent Item (Dimension), Product Lvl 2 (Dimension) List 2 : with Doc # (string)None of the Doc # is unique on both Lists.In List 2 I want to retrieve Parent Item following the rule : IF List1.Doc # = List2.Doc # AND Product Lvl 2 = “VPS” Then Parent Item (Dimension)I tried this but doesn’t work and I don’t understand why. In my screenshot, P&L.Transaction = Doc # from List 2 and Transaction List.Document Numer = Doc # from List 1Thanks for your help ! Alexandre

1 year ago

OyvindBNewly Minted Pigmenteer

asked in Questions & Conversations

Tracking Outstanding Invoices over Time

Hi!I’d like to create a metric to keep track of the number of outstanding customer invoices over time.I have an import from the ERP system with the status of every issued invoice, and the following columns:Customer Number Invoice Date Payment DateThe metric should be of dimension Day, and should return the # of outstanding invoices at any given time.Excel equivalent:1. Generated a sequence of days ( → Day metric in Pigment)2. Use sumproduct formula for the aggregation=SUMPRODUCT((Invoice_Date>=Day)*((Payment_Date>Day))+(Payment_Date=0))What would be the equivalent formula in Pigment for this?

1 year ago

ElodieSeasoned Pigmenteer

asked in Questions & Conversations

YTD % in a table

Hello !I have created a table to display our monthly key figures with actuals vs budget. I have added the following columns with the calculated item function: YTD values (with the cumulate option in the calculated item), and variation in € + variation in % for the monthly and YTD values.When my initial data is in number it’s ok, but I don’t know if it’s possible to use the calculated item option for calculating YTD values in % and calculating their variation (for example gross margin % and EBITDA %). Could you please help me to find the best way to calculate these values in my table?Hope my request is clear enough!Thanks,Elodie

1 year ago

Page 12 / 21

Badge winners

Wojtek Migdalskihas earned the badge Innovator
Wojtek Migdalskihas earned the badge Pigment Modeling Fundamentals Certified
Kaberahas earned the badge Pigment Modeling Fundamentals Certified
andrpetersenhas earned the badge Pigment Modeling Fundamentals Certified
benjamin.bergerhas earned the badge Emerging Author

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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

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.