Questions & Conversations

From Dimension B, How can I look up a property from Dimension A based on a Dimension A property which is in Dimension B? MS-Copilot told me to use Lookup (), which works in Anaplan but I cannot find Lookup in Pigment functions.  Thank you.

Hello everyone, urgent!!Do you know of any tricks (functions, modifiers, data actions) to copy data from year N to year N+1, or from forecast version 8+4 2021 to forecast version 8+4 2023, into a new metric without deleting any data from the previous year or version? This is for a presentation. I would be very grateful. Thank you. 

I would like to divide my 'Discount_EUR' metric by my 'Gross Sales EUR' metric, but I'm not getting any value. Can you help me solve this problem? Thank you in advance.Result:  

Does anyone know if I can sort the items in a filter so that my cost centers (or GL account) shows in ascending order? I created a filter for cost center currently but all the available items are listed randomly, I tried sorting the dimension list in ascending order but it doesn’t reflect properly when I use the selectors. Thank you!

Hello,I have 2 different transaction lists from 2 separate sources. I would like to combinate both Transaction lists thanks to a common textual field “Reference Number”. On SQL, I would use an “Union” operator. What about Pigment? If I guess correctly, I cannot combine Transaction lists direclty on Pigment. But I have 3 options:    1. Transform my SQL request to have an unique source and Transaction list.    2. Manually export, transform and load a third transaction list (Too time-consuming).    3. Use my “Reference Number” field as a dimension.This reference dimension should contain thousands, even millions of elements. Then, is it wise to use it as a pivot dimension? Thanks for helping me ou :)Best, Sandy

I have imported a list of 1,914 employees into a dimension called “Ramp Users.”In my Transaction List, I have two key properties: Description – this contains text fields that include employee names (e.g., “Airfare reimbursement – John Doe”). Ramp User – this is where I want to pull in the matching employee name from the Ramp Users dimension. My goal is for the Ramp User property to automatically identify and display the employee name from the Ramp Users dimension if that name is found within the Description field of the Transaction List.I tried using the following formula in the Ramp User property: IF(CONTAINS('Ramp User'.Name[BY:'PL GL Data'], 'PL GL Data'.Description), 'Ramp User'.'Ramp User Name')[REMOVE FIRSTNONBLANK:'Ramp User']But I Rec

When using Pigment Connector in gsheet the date formulas are imported as text  

Hello Pigment Community,Is there a way to set up a page filter that dynamically changes based on another page filter — similar to how dependent dropdowns work?I know we can use Dependent Page Selections (as shown below), but that only works when the first dimension is a property of the second dimension. In my case, neither of the two dimensions is part of the other. So I would like to create a metric to define their relationship and use it for the setup. 

Are there keyboard shorts while I’m creating metrics, etc. that would be able to pop menus open, etc? Did I miss that in the training?

Hi all - I was trying to do something similar to the analysis Actuals vs Forecast as it is shown in the video of this use case.In that example, Actuals and Forecast columns are version dimension, right? How is it possible to do the monthly variance and the YTD variance all in the same table? I did something simliar but in two different tables because in one I need only one month and in the YTD I need several so it’s a different filter How can I link the variance reason to the actual delta (maybe it should be something around the by→ but not sure). Does anyone have experience on doing so? I’m struggling a bit.Thanks!

Is it possible to set up a metric for selecting the Snapshots my boards in an app reference so that i don’t have to change them all manually?

I have a field in a transaction list that returns the Employee ID (data type: Text) and another column that contains the Company ID (data type: Text). I need to concatenate these two fields to create a final Employee ID (e.g., “EMPID–COMPID”). This concatenated field should then map to the Employee dimension.The issue is that I’m unable to tag this concatenated field to the Employee dimension since both source fields are in text format, and I can’t find a way to convert the resulting text into a dimension-compatible value.To address this, I created a concatenated Employee ID Initial (Text) field and added another property called Employee ID Final (data type: Dimension → Employee). I then tried the following formula: Employee ID Final = item(EE_Paylocity_Actuals.'Employee ID Initial','Employee - Final'.'Employee ID'). However, this only works if the Employee dimension is already pre-populated wit

Interested to see if anyone has done this, and curious about their experience so far

Hello everbody,Does anyone know if it is possible to create a dynamic, user-based action button? In my application I have set up a number of different homepages for the different board members in our company. Each one has a different set of dashboards. On each of the dashboards I’ve added a simple ‘home’ button to quickly navigate back to their homepage. However, they do share some of the same dashboards. Is it possible to dynamically redirect to a particular homepage based on the user who clicks the button?Thanks!

I have a Board for a user that has a number of summary tables and a transaction list. I want the summary tables to include all departments but i want to omit a department from the transaction list. currently it out in the view but recently realised that the user can remove that filter.how can i resolve this issue?

Hi, I'd like to merge my Forecast and Actual data into a single table.To do this, I created these metrics:'IsActual Metric':'Switchover date Metric':'Growth Rate Hypothesis''PREVIOUS_(Month)''FCST - Product': which should be my result. But the problem is that I get one result per Version, even though I need to have the 5-month Actual and 7-month Forecast data in the same table. Thank

Is there any way to hide the boards in all blocks section even for Admins ?

 I have a metric which is by Year Dimension, and I have another metric which is by Month in the same table, i would like to have a year selection on the Page that will filter both metrics at the same time, does anyone have a solution or workaround? 

Hi,I’m working on an AI Agent Mission and I want to use variables to make maintenance-free.The mission runs fine in preview mode, however I can’t save it because “2 Blocks or Variables mentioned cannot be found” I narrowed down the issue to the two variables in the instructions. These are dynamic variables. Do you have any idea why I’m not able to save the mission?

Product List Sales Amount Product M-100 100 Product M-200 200 Product S-100 100 Product S-200 200 Product S-300 300 Product M Series 300

Hello community, I have a dimension City, with Department/Region/Country parents. I would like to use a Conditional Formatting on a metric, probably based on another source metric, to display raw data dynamically on a specific color according to the level of granularity. But I don’t know how to create a metric which calculate the level of granularity of my dimensions.  Let’s see my exemple: Dimension 1 : City Dimension 2 : Department > CityDimension 3 : Region > DepartmentDimension 4 : Country > RegionMetric : Budget per city Do you have any clue? Screenshot with fixed colors* 

Hello,I need your help with a topic regarding data aggregation with their Parent-Child Hierarchy.In my Transactional list, I don't have any lines corresponding to the Parent value "Finance," and for "INC" type accounts, only Gross Sales returns values. However, I would like to display all accounts as shown in the attached chart of accounts:Problem: When I create my metric, the rows (Finance, Operating Income, Gross Profit, Net Income, Gross Income) are empty and do not aggregate with their children, and therefore do not allow for ratio and P&L calculations.Could you help me find a workaround?Thanks a lot

Hi everyone,I’m looking for some advice on a data analysis challenge I’m facing. I have a metric that gives me my actuals each month, and I want to set both my forecast and budget for the upcoming period to match the amount from my most recent actual month.I’ve already tried using functions like PREVIOUS, IF DEFINED, or ‘IF O then 0, ELSE METRIC’ but the size reachs the limit.However, I’ve run into an issue: when the current month’s actual is not defined or is zero, my formula keeps searching backward until it finds the last defined value, and uses that for the forecast.What I want instead is: if the current month’s actual is zero or not defined, the forecast should also be zero or not defined for that month-it shouldn’t go back to the last available value.Has anyone solved this kind of problem? What’s the best way to make sure the forecast only uses the actual value from the immediate previous month, and does

Hi,I want to set a schedule for the Agent Missions I’ve configured, but unlike in the academy demo, I don’t seem to have that option in the App.Any suggestions?Thank you in advance :)  screenshots:Academy   App