Skip to main content

Questions & Conversations

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

  • 682 Topics
  • 1,839 Replies
682 Topics
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?

5061
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"]

3872
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?  

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

6631
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

2341
Katrina
Employee
3 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! 

2671
Katrina
Employee
3 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!  

2521
Rebe
Community Manager
3 years ago

Badge winners

  • Read and Interpret Formulas Certified
    Wafaehas earned the badge Read and Interpret Formulas Certified
  • Pigment Modeling Fundamentals Certified
    luciemaheyhas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Wafaehas earned the badge Pigment Like a Pro
  • Innovator
    Ehabhas earned the badge Innovator
  • Read and Interpret Formulas Certified
    Ximenahas earned the badge Read and Interpret Formulas Certified
Show all badges
Terms & ConditionsCookie settings