New to Pigment? Find everything you need to get started
Connect with other users, discuss how you're using Pigment, and get inspired
Learn about Pigment features
All the best practices and the guides from the Pigment team
Without Round Up we were getting the value as 6.40 in june 23 in Black (Dimension list item) after round up we are getting 8 in june 23 but the value should come as 7. This is one example we are showing here but there are multiple errors. we are attaching the screenshot for the same
Does pigment.app have an api documentation, regarding the usage of api key .i am looking for full api doc that will help me to understand the endpoints and using those with cURL requests
We have a few spaces left for the next Customer Connect - Servicing Executive Stakeholders in Pigment!Next Monday we’re talking about servicing stakeholders in Pigment. Whether it’s investors, the C-Suite, or an executive sponsor, we want to discuss how you’re approaching this in Pigment. One of our Solution Architects will prepare some questions to help guide the conversation, but it’s an opportunity for you to share your own insights, and get some to help you better serve your own stakeholders.Are you a customer who wants to share and learn from your peers on this topic? Sign up now!
Hi Pigment Folks, I have the following FX conversion rate challenge,ContextI build my Balance Sheet from staging transaction amounts in local currency from Transactions list and structuring the amounts over a hierarchy were account number is the lower level.My problem comes when trying to convert the amounts to our reporting currency. - I have a metric where I input the conversion rates on a monthly basis. - The balance sheet has the following behaviour: Every month, the cumulative amounts should be converting to the latest rates. And every year should be converting to the last month of the year rates.ChallengeI’m looking to create an FX metric that I can apply to the staged amounts that it’s flexible.I mean that whenever I’m showing data by years, quarters and months select the right rates.For years would multiply the staged cumulative amounts by last month of the year rateFor month would multiply the staged cumulative amounts by each month ratesFor quarters would multiply the staged
Hello !I would like to duplicate a board for our German team (I have currently created a sales reporting for our French and Belgian team). However, if I duplicate this board and apply “Germany” in my Country dimension page, it also applies this country to my other board (for France and Belgium)… Do you know how I can unlink the 2 boards so that when I select a country, it doesn’t change the country in the other board?Thanks!!Elodie
I have a metric containing data that I would like to associate to a dimension list property, the LASTNONBLANK formulae is not working.
I would like to write a formula where the intent is for the metric to calculate the average of the prior 3 months of the metric itself.I envisioned the syntax being something like the following, though it says MOVINGAVERAGE doesn’t support recursive mode.MOVINGAVERAGE(PREVIOUS(month),3)I understand that I could use MOVINGAVERAGE without PREVIOUS if the object being averaged was a separate metric, but the use case I have requires the formula to reference metric itself. Is there any solution or workaround for this?
Dashboards in Pigment provide your users with views into your data so they need to be precise and easy to understand for the best data insights. Users coming from different countries, entities, businesses or regions, prefer to see the Dashboards in their most familiar language.Most of our modelers tend to create bespoke dashboards, e.g. one dashboard per language, with a different set of filters, text-instructions, colors and available items in the page selectors.To centralize localization and propagate your changes to everywhere in Pigment where a display name is seen, use custom labels in grids, tables and KPIs for each language that you plan to add. Adding translations to items in the dimension First, let’s add a translation for each item in our dimension. After opening the dimension, add a new text-based property.In my example, I’ve used Name FR in my Country dimension to translate my English names to French names. Japan becomes Japon, United Kindom becomes Royaume-Uni.Populate thi
Hello, I want to show a YTD view for a KPI where it sums each month automatically. For example, in January I would be able to see budget vs actual and in February it would be Jan + Feb and so on. Is there any work around for this? This is the current KPI view that I have but I have manually filtered on the month. The view doesn’t work if i choose another month.
Hello community :) I have a dimension with all my employee and their packages (with historization). For example: one personn who received a salary increase have 2 rows:first row with start end date of previous package second row with start date as end date of the previous packageWould it be possible to create a formula which allows to have a filter in page which ables to select only the last value in the dimension for each employee (ie the last up to date package)? Thanks a lot!
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.
Is there a way to filter from the view all metrics in 1 filter to exclude zero values from a table? If there is a table with a lot of data & we want to connect it to a gsheet, having many rows with zero values slow down things.
During implementation, our SAs and CSMs are often asked for best practices around launching Pigment to the wider org, and the change management that comes with it. We’re working on some resources to help, but we’d love your input! Here are some of the ideas we’ve received so far:User profile templates to use when designing your models User testing checklists Communication timelines and templates Learning paths for different types of users Visual assets (like posters and banners) Launch celebration goodiesWhat would you add to this list? If you already have your business partners using Pigment for their inputs and insights, what would have helped you most? If you’re looking to do that, what would be the most helpful thing we could provide? Let me know in the comments!
I have a boolean metric with three dimensions: Position, Version and Month. Position Version Q1 Q2 Q3 Q4 001 Forecast ☑️ ☑️ ☑️ ☑️ 001 Plan ☑️ ☑️ ☑️ 002 Forecast ☑️ ☑️ ☑️ ☑️ Positions can be a part of different teams over time. I have another metric, *Position Mapping* which is of type Team with the same dimensions as the boolean. Position Version Q1 Q2 Q3 Q4 001 Forecast Team A Team A Team A Team A 001 Plan Team A Team B Team B 002 Forecast Team X Team X Team Y Team Y Now I want to add the Team dimension into the first metric. I have tried doing it like this:‘My boolean’ [by: → ‘Position Mapping’]Team Position Version Q1 Q2 Q3 Q4 Team A 001 Forecast ☑️ ☑️ ☑️ ☑️ Team A 001 Plan ☑️ Team B 001 Plan ☑️ ☑️ Team X 002 Forecast ☑️ ☑️ Team Y 002 Forecast ☑️ ☑️ This achieves the goal except for one thing. Wh
Contact our support team and we'll be happy to help you get up and running!
Already have an account? Login
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.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.