Skip to main content

Explore the Community

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

940 Topics
CamilleMomo
Seasoned Pigmenteer
CamilleMomoSeasoned Pigmenteer
asked in Questions & Conversations
Best Practice : Associate a metric with a dimension ?

For example if I have several metrics corresponding each to an allocation rule, and I want to define the allocation rule to be used for each entity of a company.Is there a best way than using a SWITCH statement to associate a metric with a dimension.In my example : SWITCH(Entities.Allocation Rule, “A”, ‘Allocation - A’, “B”, ‘Allocation - B’, ...)It is not totally optimal because I have to update the formulas each time an allocation rule is added.Thanks in advance !

2613
francois
Employee
M
Just Arrived
markdeprezJust Arrived
asked in Questions & Conversations
VISUAL HINTS

Is there a way to have the visual hint ON by default?

2951
Chris
C
Seasoned Pigmenteer
Chelsea
posted in Questions & Conversations
Congrats to our newest Level 1 certified Modelers!

Join me in congratulating @Alix Noyon, @Camille Moreau, @Laure Vinot, @dktodinov, @Dastan,  @Konstantin Dzhengozov, @Mohamed Iraqi, @Axelle Cazalets, @Jason, @Mat, and @VyPigmenton becoming our newest Level 1 certified Modelers today! 🥳🥳🥳

994
Rebe
Community Manager
J
Jose RamonOccasional Observer
asked in Questions & Conversations
Add "Last Date|Time Updated" to Boards

Dear community,How could we add “Last Date|Time Updated” to our Boards?“Last Date|Time Updated” = the last time the transaction list (data source of the board) was refresh/uploaded.The idea is to provide visibility to the final user of the board about how “fresh/updated” is the data in the board.Thanks.

1821
francois
Employee
V
Just Arrived
Venkata BiradarJust Arrived
asked in Questions & Conversations
Calculating YTD

Hi,  I'm trying to build YTD formula that is based on switch over data.  For example if the switchover date is November, I would like to sum January-November numbers. What is the easiest way to do that? I tried to use the YEARTODATE formula, but it's not what I am looking for, as it's adding to each month the sum of the previous months.  

5812
francois
Employee
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

1120
E
Employee
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

6552
Roy Stolero
Budding Pigmenteer
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?

5221
Nathan
Employee
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"]

3972
C
Budding Pigmenteer
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?  

2351
Katrina
Employee
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! 

7821
Katrina
Employee
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

2421
Katrina
Employee
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! 

3001
Katrina
Employee
Rebe
Community Manager
RebeCommunity Manager
posted in Welcome to the Community!
Pigment Community FAQs

1. I’m new to Pigment! Where should I start?Check out the Getting Started section, where you will find what you need to start using Pigment in no time. 2. I’m new to this community. Where should I start? Have a look at the Community Basics and then introduce yourself here. From there explore the knowledge base, join in on conversations, and if you have a question or something to discuss, click the button at the top to create your first topic!  3. How do I sign in to the Pigment Community? You sign in to the Community using your Pigment App details:If you need to sign in, you will be directed to the Pigment sign-in page and will land here in the Community ready to go! If you’re already sign into Pigment, then you don’t need to do anything other than set a username. 4. Pigment Community: why should I be here?Pigment is made to empower you, your team, and ultimately, your company. What took ages to do before can now be done in minutes with Pigment. Make the most of it by using this Commun

16020
Rebe
Community Manager
Rebe
Community Manager
RebeCommunity Manager
posted in Questions & Conversations
Our Pigment Story

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

2631
Rebe
Community Manager

Badge winners

  • Innovator
    Naomi Vriendhas earned the badge Innovator
  • Pigment Modeling Fundamentals Certified
    Aaron Ghas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Modeling Fundamentals Certified
    r.karsanhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Modeling Fundamentals Certified
    Seney SEANhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Seney SEANhas earned the badge Pigment Like a Pro
Show all badges
Terms & ConditionsCookie settings