Questions & Conversations

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

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?

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

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?  

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! 

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

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! 

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