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

503 Topics
1,383 Replies

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

503 Topics

Recently active

Most replies Most views Newest first

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

JuliaSpNewly Minted Pigmenteer

asked in Questions & Conversations

Difference between two dates

Hello,I need to create a IF condition that shows : IF date 1 > date 2, then blablabla. Date 1 : Current date, it’s a metricDate 2 : Go Live date, it’s a date from a transaction I did this formula :But I have this error. Here is my Month Dimension : Thanks for your help :)

1 year ago

Armando BittNewly Minted Pigmenteer

asked in Questions & Conversations

How to make semi-additive measures easier to handle?

Hi everyone, I'm facing an issue for creating metrics that are on a "per basis". They're divisions between 2 sums.Those 2 sums (let's say A and B) are defined across the same 6 dimensions, and individually work fine and aggregate as sums on any visualization with them even if I pick let's say 3/6 dimensions in which they existHowever when I create a metric dividing those metrics A and B, we face issues when displaying on a table 3/6 dimensions, because there's no option to define the order of operations, and what happens is:- The table calculates A / B on each combination of 6 dimensions- Aggregate as sum of (A / B) on the table at displayWhat needs to happen is:- Calculate sum of A- Calculate sum of B- Divide sum of A by sum of BAnd we couldn't find a formula to do this, or make explicitly how we want to aggregate.Those are semi-additive measures, and maybe this example on DAX helps:https://www.sqlbi.com/articles/semi-additive-measures-in-dax/Thanks!!

1 year ago

Regina CrodaEmployee

posted in Questions & Conversations

Dresner EPM end-user survey

Dear Pigment Community,I hope your week is starting off well! I am Regina, on the Product Marketing and Analyst Relations team and I wanted to share with you something we’re working on. We are currently participating in Dresner Advisory Services Wisdom of the Crowds EPM market study, to help them create a holistic view of the EPM market. We would be hugely appreciative if you participated in their end-user survey to share your Pigment experience.If you’re up for helping us, please take five minutes to share your experience with Pigment, by Friday, March 31, 2023. You only need to complete the sections relevant to you, and you can skip areas which aren’t applicable. As a thank you for your time, Dresner will send you a complimentary copy of its research findings once the research is published this summer.Take end-user survey hereThank you!!Regina

1 year ago

nancySeasoned Pigmenteer

asked in Questions & Conversations

Webinar access not available

Hi Team,I was trying to view “Build collaborative sales planning and forecasting models” webinar on community but it seems like i donot have access to view it as i am unable to see any link which can run the webinar for me. Kindly help me with the issue

1 year ago

AlexandreSeasoned Pigmenteer

asked in Questions & Conversations

Retrieve User name

Hello,It there a way to retrieve the User name from “User” ?Thanks

1 year ago

ElodieSeasoned Pigmenteer

asked in Questions & Conversations

Turnover cohort

Hello,I am trying to create a metric that shows the month tenure by employee in a cohort, with the cohorts in rows and the month cohort dimension in columns (i.e. M+1, M+2, M+3, etc.). For example, an employee who arrived in May 22 is part of the May 22 cohort and if he leaves in September 22 it would put a 1 in the column "M+4" for the row "May 22".I have an “Employee” dimension with a property for the cohort (for example May 22) and a property for the number of months of employment (for example M+4).Could you please help me to build in the best way the described metric?I hope my request is clear enough!Thanks! 😊

1 year ago

Trever LeavenworthSeasoned Pigmenteer

asked in Questions & Conversations

Modifiers not applying as expected

Hello! I’m attempting to aggregate my metrics into a full P&L with actual and forecast views. I have data coming from a Shared_IS_Actuals dimension, several Revenue and COGS dimensions already mapped, a Shared_WF_Plan dimension, and a Shared_Opex_Plan dimension. I’ve been able thus far to successfully have Actuals for all IS accounts pull in, and have Revenue, COGS, and WF (payroll, benefits, taxes) appear in a single metric. However, when I try to add my Shared_Opex_Plan data using the formula below, my Actuals stay, my revenue and cogs disappear, my WF_Plan stays, and my Opex_Plan disappears, leaving me with only the WF_Plan. It’s like the first by modifier to map the WF_Plan to the CoA is applying to everything? What am I missing?

1 year ago

Trever LeavenworthSeasoned Pigmenteer

asked in Questions & Conversations

Best Practice: Metric to Chart of Accounts

Hi! Hoping some of you can share some best practices for mapping a metric’s results (for example, a forecast metric of revenue with dimension Month) to a chart of accounts (for example, account 4000: Revenue). I know I could use lots of IF statements on a metric that has dimensions Month and IS_Accounts, but that seems fragile? I haven’t seen another way to directly associate a metric’s result to a chart of accounts line though. Any advice? Thanks!

1 year ago

AdelgoNewly Minted Pigmenteer

asked in Questions & Conversations

Block Expand option in the board

Hello,Is it possible to block the expand option in the board access rights ?ThanksAdèle

1 year ago

abhilashsawlaPigment Academic

asked in Questions & Conversations

Timeout Issue during import

Hi,I would like to know when we get timeout issue during Data import and how to solve it.

1 year ago

abhilashsawlaPigment Academic

asked in Questions & Conversations

During Formatting selected Dimension Property getting unselected automatic

Hi Pigment Team,We are trying to format Dimension Property, but it is getting unselected automatically. Please resolve this bug as soon as possible. Recorded video link is given below for your immediate reference. OneDrive (live.com)

1 year ago

Trever LeavenworthSeasoned Pigmenteer

asked in Questions & Conversations

Multiple PREVIOUS functions

Hi everyone! I’m using a Versions Dimension to allow for Actual + Forecast monthly planning. 1+11, 2+10, 3+9, etc. For metrics with manual inputs, I’m wondering if there’s a way to have the formula statement be:If the prior month is defined, default to that value. Otherwise, default to the prior version. The idea would be that as I change versions, my inputs would carry to the next one. However, if in a later version I change the input for a month, that new input would propagate across all the future months in that version. I tried a few versions of an IF statement using ISDEFINED, etc. but no luck. Thanks!

1 year ago

abhilashsawlaPigment Academic

asked in Questions & Conversations

How to turn off Share Toggle in Scenarios

Hi, Please let us know how to turn of Shared Scenarios.

1 year ago

Trever LeavenworthSeasoned Pigmenteer

asked in Questions & Conversations

Change Total Aggregator Label

Hi everyone, I’m wondering if there’s a way to update the Aggregator label. For example, if I add an aggregator AVERAGE, the additional row added still says “Total”. It would be helpful if it would show “Total Average” or just “Average” depending on what aggregator option I’ve selected.

1 year ago

Trever LeavenworthSeasoned Pigmenteer

asked in Questions & Conversations

Chaining dimension properties across dimensions

Hey everyone, I have a transaction list of revenue by month by User ID. My User ID dimension has the property “Employer”. My Employer dimension has the property “Parent Company”. I want to create a metric with dimensions Months and Parent Company to sum the revenue from my transaction list. How do I chain the dimension properties in the by sum statement? I need to go from User ID > Employer > Parent Company across multiple dimension lists. Thanks!

1 year ago

aufdenkampSeasoned Pigmenteer

asked in Questions & Conversations

Scenarios no longer available as Page option in Metric after removing from Pages

We had removed Scenarios from the Pages in some blocks (because we weren’t utilizing them yet) and now we can’t find an option to add Scenarios back to Page in the Pivot. We can add them as columns/rows, but the Pivot interface doesn’t allow us to move Scenarios to Pages only. How can we get Scenarios back in our blocks as only a Page selector?

1 year ago

CBGongBudding Pigmenteer

asked in Questions & Conversations

Auto refresh Google Sheets connection export

Is there any way to auto refresh the data connection from Pigment to Google Sheets on a daily basis?

1 year ago

ElodieSeasoned Pigmenteer

asked in Questions & Conversations

Best practices for budget/forecast

Hi everyone!I have to remodel our Budget application because a lot of our processes have changed since we built it with the Pigment team 😊Can you please share with me your best practices for building such applications?I am especially wondering about the use of scenarios, versions, switchover date, etc.We usually do a budget once a year and then review it with a forecast at least once every quarter. Should I create 2 separate applications for this purpose? Can I condense all the information in one application?Thanks for your help!

1 year ago

KhadijaFrequent Reader

asked in Questions & Conversations

Add a dimension in transaction list

I am trying to say that if this property on this dimension list is blank, then just insert me an item from another dimension list.But I get this and I tried to change the property type but it still gives me the same error message: “Expressions are incompatible and cannot all be converted to Text”

1 year ago

AlexandreSeasoned Pigmenteer

asked in Questions & Conversations

Variation from Last Year Month

Hello,I want to compare Jan 23 vs Jan 22, Feb 23 vs Feb 22, etc until Dec 23 vs Dec 22 with Calculated Item but from what I see, I have to do it manually (12 times for each Month) to do it.Is there an automatic method to do it on every months ?Here is a picture of what I want : Thank you for your help :)Alexandre

1 year ago

Page 13 / 21

Badge winners

BrunoRodriguezhas earned the badge Chatterbox
Mathas earned the badge Emerging Chatterbox
Vincent CHEVALIERhas earned the badge Pigment Modeling Fundamentals Certified
rschimmhas earned the badge Emerging Author
rschimmhas earned the badge Innovator

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.