Skip to main content

Questions & Conversations

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

  • 609 Topics
  • 1,645 Replies
609 Topics
E
Employee
EléonoreEmployee
posted in Questions & Conversations
Welcome to the Pigment Community!

Hi Pigment People!I’m so delighted you’re here reading this. Ever since Romain (co-CEO and CTO) and I started our journey to create Pigment, we wanted to ensure what we built was powerful, flexible and easy to use. We’re still on that journey but you’ve all been crucial to where we are today.We’re going to stick around in this Community with you all (hopefully you’ll pop in often) to ensure that we stay true to our values and vision. It means a lot to be able to work with folks like yourselves who have a similar vision to us and understand how Pigment can help you and your own organisations. By coming here, I hope to get plenty of signals and feedback on how we’re doing there. If there are more articles or ideas that you would like to see, just start a discussion!It would be really cool if you introduce yourself in Rebe’s thread here. I’m looking forward to learning and sharing with you all — Romain and I, along with the whole Pigment team intend to be frequent contributors (you’ll see

0
E
Employee
2 years ago
Roy Stolero
Budding Pigmenteer
Roy StoleroBudding Pigmenteer
asked in Questions & Conversations
CAGR Function

Hello,Is there a formula that outputs cumulative average growth rates of a certain set of numbers? For example, an output of the last three months' revenues average growth rate could help model the rolling forecast (getting the trend is sometimes better than getting just the average).Does that make sense?Roy,Melio

2
Roy Stolero
Budding Pigmenteer
2 years ago
C
Budding Pigmenteer
Carolina LeeBudding Pigmenteer
asked in Questions & Conversations
YTD with Table

I create a table to join some information and create a Full P&L per month. I want to use the formula YearToDate, it it possible? How can I do that?

1
Nathan
Employee
2 years ago
C
Budding Pigmenteer
Carolina LeeBudding Pigmenteer
asked in Questions & Conversations
Filter 2 items

I want to filter 2 itens of a dimension (SG&A and R&D), how can I do that?The formulua I created is this below, but I don’t know how to add another item with SG&A.[filter: 'P&L type'= 'P&L type'."SG&A"]

2
C
Budding Pigmenteer
2 years ago
N
Just Arrived
Nicolas GenotJust Arrived
asked in Questions & Conversations
Unable to filter data

Hi,I've been using filter to filter data in my view but when I do a calculation with the filtered dimension in a table, the value calculated seems to be taking into account the value of the filtered elements as well? Can I fix this or do I have to create a new dimension with different structure in order to get correct numbers?  

1
Katrina
Employee
2 years ago
N
Just Arrived
Nicolas GenotJust Arrived
asked in Questions & Conversations
How can I bring my data into Pigment?

Hi, I somehow missed how we can connect data in Pigment. I want to connect an excel file I've been working on. Is there a way to connect it? Thank you! 

1
Katrina
Employee
2 years ago
V
Just Arrived
Venkata BiradarJust Arrived
asked in Questions & Conversations
Looker data import failing

Hi, I’m trying to push data from Looker to Pigment but the export is failing due to "CSV Format & Mapping". When I try to do it with a csv it works with the same import pipeline.Here’s a screenshot of the error I’m getting:Could you please advise?  Thanks

1
Katrina
Employee
2 years ago
A
Just Arrived
Alex BeattieJust Arrived
asked in Questions & Conversations
Can Pigment connect to Google Sheets?

Hi, we’ve started using Pigment recently and worked with flat file exports only until now. I was wondering if it would be possible to get our data directly from google sheets for example? Thanks! 

1
Katrina
Employee
2 years ago
Rebe
Community Manager
RebeCommunity Manager
posted in Questions & Conversations
Our Pigment Story

Share how Pigment is helping you and your teams make better decisions!  

1
Rebe
Community Manager
2 years ago

Badge winners

  • Read and Interpret Formulas Certified
    Sathya Chas earned the badge Read and Interpret Formulas Certified
  • Read and Interpret Formulas Certified
    Hui Lanhas earned the badge Read and Interpret Formulas Certified
  • Pigment Modeling Fundamentals Certified
    Hui Lanhas earned the badge Pigment Modeling Fundamentals Certified
  • Helper
    Andreahas earned the badge Helper
  • Innovator
    tonymjefferyhas earned the badge Innovator
Show all badges
Terms & ConditionsCookie settings