Howdy y’all - Our team is working on doing a simple customer count, but is struggling to do so without removing all dimensionality from our metric.We want to count unique instances of a customer where there is spend - but have dimensionalities flagging different types of spend attributes (ex: a flag for customers who have spend in the US vs those who have spend outside of the US). So - if a customer has spend in both the US and outside of the US - they will have a customer count of over 1, when we want each customer to only be counted once while retaining dimensionality. None of the count/countunique formulas are adequately solving this issue.The page aggregators are correctly counting the number of customers - but we are unable to use the page aggregators in tables to do calculations. Does anyone know of a way to use the “count” from the aggregator for table calculations - or of any other ways to get customer count without double counting across different dimensions?
I have a table with 2 metrics: M1 and M2. Both metrics M1 and M2 are having the Customer dimensionality.Created a data action to export the table,Action on click: Trigger ExportSelected the table/block name and then 2 metrics in the dialog box in ‘Action Widget Settings’, header names is kept as “Display Name”.Noticed, while getting the export i.e. CSV file in the downloads folder, it contains only those rows which are having values either in M1 or in M2, but I want to see all the customers in the export view even if M1 and M2 both are Blank.
I am building an attrition model based on month dimension and a dimension called ‘30 Day Cohort’. I am almost certain that I will run into a circular reference if I do not use the Previous function. However, because I am working with 2 dimensions I am unclear on how to reference the previous month and previous ‘30 Day Cohort’ dimension simultaneously. Is this possible? Can I combine multiple Previous functions? Is it possible to nest two Previous functions? To start my model, I have “initialized” the metric with both the starting values in the first month and the forecasted new subscribers in the first ‘30 Day Cohort’ (0 in my case): What I would like to do is calculate a formula on the value in the previous month and previous cohort and then do so recursively (this is why I think I need to use the Previous function). So for Oct 23 and cohort 1, I would want to do my calculation based on the Sep 23 and cohort 0 value (1,895); for Oct 23 and cohort 2, I would want to do my calcula
Hi Pigment Community,I have a couple of questions about managing properties of type dimension.I’m using a direct connector to Lever to create a Lever_Requisitions transaction list. I need to use one of the properties of this list (Requisition ID) both as a dimension and as text - I’m using it as text as part of a concatenation for an Unique ID property that defines how my loads work and now need to use it as dimension to cross some data with an offer transaction list. Is it possible to have the same data in two different columns with two different types? How can this be achieved? Additionally, I need to change the dimension list associated with my Requisition IDs, as it was automatically generated from my offers report and is incomplete. How can I do so without losing all items in my existing Lever_Requisitions.’Requisition ID’ property? I have historical loads there that I wouldn’t like to lose. Thank you!
Hi all, I have a strange behavior in some reports: if I collapse a dimension it adds an aggregation.For example I have a report which shows the following list of dimension and only the Months is aggregated inthe columns.In my example the Planning Cycle dimension is not aggregated (which wouldn’t make sense).But if I click on [- FY] to collapse the last columns it automatically activates the Planning Cycle dimension aggregation.The filter is activated automatically: I would like to deactivate this behavior.Best,Alex
Use Case:There is App1 and App 2 within the same workspace. Need to bring the metric’s Xyz values with Employee dimension from App 1 to App2 on a real-time basis, i.e. in App 2, the user shouldn’t be able to drill-down on the underlying logic written in Xyz metric.Created the scheduler import (metric to metric import) in App 2 to fetch the value from App1 and fetched it in a PQR metric in App2 , and then created another Final PQR metric: which is just referencing ‘PQR’ metric and published Final PQR on the board, but need to bring the data real-time , how to do in Pigment- Can anyone please guide me with this?
Is there a way in Pigment to submit a button?(i.e. similar to marking a checkbox as True)
Hi! Can you please help setting up the formula to populate the current forecast week?I already have a Week dimension and the metric should populate 2025-06-08 as of today because 2025-06-01 is marked as “Last Actual Week”. Thanks!
The purpose of this article is to explain how you can calculate ratios in Pigment across all summary levelsContextConsider the following example, we have Cost and No. of Units by Country and Month. We want to calculate Cost per Unit. To calculate this ratio, you would normally do:Costs / No. of Units = Cost per Unit When we enter this formula in Pigment, we can see the Cost per Unit at a country level, but, the total for the region calculates incorrectly. Pigment shows 230, but the correct answer is 165,000 / 1500 = .110 Pigment is calculating the ratio correctly at the lowest level of granularity, which is the level that the metric is dimensioned by. The summary levels are calculated using the summary method of the block (default total is to sum the calculated ratios, 100 + 130)So how can we calculate Cost per Unit correctly at the summary levels?Option 1 - One metric per level of granularity 🍦Create one metric to calculate the ratio at a Country Level. Create one metric to calculat
Objective:Automatically map list of transactions to a vendor based on whether the name of the Transaction contains a keyword from the Vendor dimension (specified in a mapping table), and return the matched Vendor. I have a dimension block which contains a list of transactions (incl. a text property with the transaction name & a property formatted by the vendor dimension where I map them to a vendor). I also have another dimension block called Vendor which contains a list of vendors & a text formatted property where i want to input a key word for each vendor that is typically in the transaction name. I want to leverage this mapping in the Vendor dimension and do a lookup on my transaction list to check each transaction name. search if it contains a keyword and populate the correct vendor. Is this possible?
I have a metric where I have two dimensionsParent Company Sector CategoryFor each company, we assigned one sector via Boolean. For example in the image, beflex electronic GmbH is “Mechanical Engineering”I want to create another metric with the data type “Sector Category” and the only dimension is Parent Company, so that I can use this to map all my per Parent Company revenue, to their corresponding Sector Category, or a column in the parent company dimension to that Sector Category.How can I do this? I essentially want to move a dimension from being a dimension within the metric, to it being the return type of the metric (when the boolean is true).Thanks!
Calculate the current date in Pigment Excel function: Today() For some use cases it can be a requirement to calculate something based on the current date. With the recently released Pigment Metric to Metric import functionality we can now build a metric in a Pigment application that will hold today's date and will update automatically each night. In this article we will explain how to set this up. You can use the final metric for multiple calculations or as a variable to automatically update the page selectors of your boards. A few examples of use cases are listed below: Update page selector with a dynamic variable connected to the Today metric From the Today metric you can calculate a current month metric and connect that to your application variables. This will enable you to automatically update board page selectors or calculated items which will always show the current month. Calculate with time In some use cases you want to see a reference to today. For example you would like to
Hello, our Workday to Pigment failed to load as the previous member was deactivated on 5/30. Please advise on how best to proceed. Thank you in advance for your help!ent integration appears to
Is there a quick way to bulk format a dimensioned text widget across multiple dimensions? I have a metric that has 2 dimensions and I’m finding that for every intersection I have to reformat the card (ie. change the background colour).
Your May newsletter is here, featuring the latest product updates, an important upcoming change to our learning hubs and upcoming events not to miss: ‼️ Pigment's Documentation & Academy hubs are moving! 📈 Make smart, ML-powered forecasts with Predictions ↪️ Navigate workflows with Action buttons 📣 Pigment Customer Advocacy Program: Get rewarded for your support 👥 Munich User Group - June 17th 🌐 Product Webinar & Virtual User Group - July 24th 📝 We need your help to feature in Dresner's report Pigment's Documentation & Academy hubs are moving! We're buffing our Metrics and aligning our Dimensions ready to launch new homes for the Pigment documentation and learning courses. We know these are incredibly valuable sources of information for you all, so we're making these experiences more powerful with fresh content, enhanced navigation and collaborative learning. The documentation is moving in a few weeks, then the Academy follows mid-July. Make smart, ML-powered forec
Bonjour à tous, Lille community members! This thread is your go-to spot for all things Pigment-related happening in and around Lille this year. Whether you’re looking to connect with local users, share insights, or stay updated on events, this is the place to be.Here’s what you can do here:Introduce Yourself: New to the group? Let us know who you are, what you do, and how you use Pigment! Plan Meetups: Interested in meeting fellow Pigment users in Lille? Use this thread to coordinate informal gatherings or events. Stay in the Loop: Keep an eye out for announcements about Lille-specific workshops, meetups, and webinars.Let’s make 2025 an incredible year for the Lille Pigment community! 🎊Ready to jump in? Start by introducing yourself or sharing your goals for this year. 😊
🔔 Chers membres du user group Pigment de Lille,J'ai le plaisir de vous convier à un Afterwork Finance que nous organisons à Lille le 26 juin, en partenariat avec Pigment et Snowflake.L’objectif : partager un moment convivial autour des dernières innovations Data & IA appliquées aux fonctions finance, avec des retours d’expérience concrets, une démo de chatbot IA , et surtout, de beaux échanges entre pairs.📍 New Lawn Tennis Club – Lambersart📅 Jeudi 26 juin – dès 18h🥂 Cocktail dînatoire dans un cadre verdoyantCe sera l’occasion idéale pour faire vivre notre communauté d’utilisateurs Pigment dans un cadre informel et inspirant.👉 Inscription et d'avantage d'informations iciAu plaisir de vous y retrouver !Cédric FICHEUX (SBI)
Hi everybody,I have two dimension lists: one for my P&L accounts and one for my balance sheet accounts. Both of them are updated with new accounts once they appear in the P&L transaction list or the balance sheet transaction list. For reporting purposes, I want to create a single chart of accounts dimension list that contains all the items from the P&L and balance sheet dimensions lists. Is there are way to combine both dimension lists into one and to do that in such a way that it automatically updates once a new P&L or balance sheet account appears in either of the two transaction lists? By the way; both dimension lists currently do not share the same properties. So I would simply be looking to combine the unique values/dimensions from each list and append them together as a new total chart of account list.Thanks for helping me out :)Best, Bas
Hello,I’m just a beginner, and currently, my company uses the Sage 100 software, with data stored in an on-premise SQL Server. We also use the Sage BI Reporting tool to query the data in Excel.My question is: how can we directly connect to the Sage accounting data?Thanks a lot!
Hi,as part of the fifth section of the Pro Training, I need to Allocate all values of Workforce Cost Plan → to PnL_Account 6001. What is missing in my formula?Workforce_Cost_Plan_Output[ADD CONSTANT: PnL_Account."6001"] keep getting an error:“Error: Syntax error: cannot validate formula” Thanks in advance
I have source files to build dimension lists like Territory and Product with hierarchical relationships which have hierarchy level column. I want to build Territory and product dimension lists by importing the respective files and filter by lowest hierarchy level (a number that show the level) during import definition. Is it possible?For example I have a product file with below columns, I want to load Products that are equal to Hier Level ‘3’.
When you’re working with large datasets or complex models, it's critical to simplify and optimize access rights wherever possible. Dimension replacement enhances manageability and user experience of your security model while also improving performance. Why apply Dimension replacement in access rights? How does it work? Example 1: Region to Country Example 2: Business Unit to Employee and Month Performance Impact Use Cases for Dimension mapping in access rights rules Why apply Dimension replacement in access rights? The benefits include:Reduces the number of access rights Metrics you need to create and maintain. Speeds up access rights recalculation and improves model loading time. Simplifies security model structure. Increases flexibility when working with complex data.Performance gains are especially significant when replacing a Dimension with few items (like Region) with one that has many items (like Country or Employee).Dimension replacement supports both hierarchical and custom r
COMING SOON Decisions are only as good as the forecasts behind them. That’s why Pigment provides built-in accuracy measures, enabling you to: Understand how well the model fits your historical data Build trust in the forecasted values Compare multiple models or configurations objectively Choose between simple and advanced forecasting approaches This article explains the accuracy measures Pigment calculates and their interpretations. Before you begin How accuracy is calculated Implications of calculating accuracy measures Which accuracy measures does Predictions calculate? Mean Absolute Error (MAE) Root Mean Squared Error (RMSE) Mean Absolute Scaled Error (MASE) Learn more Before you begin How accuracy is calculated To evaluate accuracy, Pigment uses a backtesting approach: we hide a portion of historical data (the backtest period) and ask the model to forecast it. We then compare the forecasted values to the actuals using the measures described below.By default, Pigment uses
Hi everyone,I’m trying to determine whether each active customer received their invoice for each month.I have two tables, both having the dimensions month and customer ID: An "Activity" table, which has one row per customer per month, indicating whether the customer was active. If the client was not active on a specific month, he will just not appear in the table for this month An "Invoices" table, which lists all the invoices sent. Thanks in advance for your help!
Hello Everyone ! I have created a metric which will calculate a simple EBITDA/Net Sales ratio, which is as followed:I want to be able to switch to a yearly view easily. The issue is that when I pivot the table to show yearly data, it aggregates all the months instead of displaying the ratio between yearly EBITDA and yearly Net Sales. I need it to show the correct yearly ratio, not just a sum of monthly values. Is there a way to prevent aggregation and ensure that the metric correctly calculates the yearly ratio ? I want to ensure it’s possible to switch views while keeping the same metric. Ultimately, the goal is to use this metric in a board and apply a page selector to display the desired month as a KPI..Thank you by advance for your help 🙂Yacine
Already have an account? Login
Single Sign-On Need help?
Enter your 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.
