Skip to main content

Unanswered questions

16
E
Newly Minted Pigmenteer
EdgarNewly Minted Pigmenteer
 Questions & Conversations
Cumulate by Qtés

Hello community,I'm looking for a cumulate grouped by Qty. I have a first metric which indicates my need of Qtés per week, and I need a second metric able to detect the week when I exceed the minimum to order. In my example, I have a minimum order of 6. In Line 1 I calculate my requirement per week. (that's done)In Line 2 I want to trigger an order when I've reached at least my minimum order.If I have that, it's already good In an ideal world, I'd have to reduce this quantity to the 1st week, a bit like a moving sum function but with variable parameters. If anyone has an algo idea, I'd be grateful ^^. 

121
E
Newly Minted Pigmenteer
Bas
Budding Pigmenteer
BasBudding Pigmenteer
 Questions & Conversations
Filter on item variables in page selector

Hello,I might have a really simple question, but I can't quite figure it out. Is there a way to show the available item variables in a page selector on a board? If I go into the page selector options by clicking on the edit button on a board I can see all available item variables for a specific dimension (for example under ‘available items’ or ‘default items’). But via de dropdown on the page selectors themselves it is not possible to use the variable as a filter? The specific underlying use case is that I have created a subset of profit centers and I would like the end users to be able to view that specific subset of profit centers by filtering the page selector. They shouldn't manually have to click one-by-one.I hope my question is clear :-) Thanks a lot everybody!Bas

253
Benoit
Community Manager
Omer Nahum
Omer NahumFrequent Reader
 Questions & Conversations
Permissions for the new dimension mapping capability

Hi Pigment,I shared with our team the new dimension mapping capability but they can't use it, what access rights and permissions they should have in order to do it?https://community.pigment.com/reporting-data-visualization-83/group-data-dynamically-with-mapped-dimensions-3160Thank you,Omer.

202
Omer Nahum
H
Newly Minted Pigmenteer
HALYNewly Minted Pigmenteer
 Questions & Conversations
Locating Model ID and WS ID

Hello, Seems like a silly question to ask but I am having a hard time locating the model ID within a model and can’t locate this info in any documentation. On a similar note, where do you locate the workspace ID? Thanks for your support,HA

191
F
Employee
Brian Mondello
Newly Minted Pigmenteer
Brian MondelloNewly Minted Pigmenteer
 Questions & Conversations
ISFIRSTOCCURRENCE formula for dimension creation

With the new functionnality to create dimension based on an other dimension/transaction list, I want to create a concatenation of 2 columns in my transaction list but.. Pigment say there is an error because a lot of rows don’t have unique ID. Is it existing a “ISFIRSTOCCURENCE” formula or simithing similar to filter my view and solve the point ? 

533
Yuri Pinchuk
Budding Pigmenteer
R
Newly Minted Pigmenteer
Rahul KumarNewly Minted Pigmenteer
 Questions & Conversations
Circular Dependency on Transaction List and dimension

Hi Team,We have an input transaction list for new seat requests. In this list, a manager and above can come an ask for a new seat / headcount and that is determine by Supervisory Org. So if I am a Senior Manager, I can come and request for a Manager position and so on.   We also have a dimension list called Supervisory Org 1 which determines what is the Org of an employee and what are the levels above. Now we want to pull the levels for the new seat based on the manager’s level. But this is giving us the circular reference error.​​​​​​Bottom line is we are using the dimension list to pull the levels in transaction list based of of hiring manager level and now we want to put it back in the dimension for the hiring position. Any workaround for this situation?

331
Luiza
Employee
C
ChahatKeen Learner
 Questions & Conversations
Submit Button

Is there a way in Pigment to submit a button?(i.e. similar to marking a checkbox as True)

493
C
Bas
Budding Pigmenteer
BasBudding Pigmenteer
 Questions & Conversations
P&L view in % of net sales

Hi everybody,I'm running into some difficulty when trying to present a P&L in % of net sales at subtotal levels.I have a ragged P&L hierarchy (account dimensions L1 to L8, where my net sales is defined at L3). I want to show all values, including the subtotals, as a % of the specific item “net sales” at the L3 dimension.When I try to use ‘show values as’ as a % of another metric where all my lowest level accounts contain the total net sales amount, it works for the lowest level (L1) accounts but the subtotals are aggregated (that is: the total net sales amounts that are allocated at the lowest account level (L1) are incorrectly aggregated together, which throws off the %-calculation). For example: I have 10 L1 accounts, each of which contains 100m as net sales. At the subtotal L3 (net sales) level, I then get 100m / 10x100m = 10%, where I would expect to see 100%. I also tried to use ‘show values as’ as % of a specific item of the L1 dimension, where I used an item variable tha

272
Stef
Employee
G
Just Arrived
ghitaJust Arrived
 Questions & Conversations
dropdown dependency

 I have created a dropdown dependency, but the issue I am facing is that I want to apply it to 3 or 4 columns from the same source (same dimensions list ). However, I cannot link these 4 columns to the same logical object.

251
CDALMAY
A
Newly Minted Pigmenteer
andyzillaNewly Minted Pigmenteer
 Questions & Conversations
Dimension property types - converting to other types and changing dimension lists

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!

192
M
Employee
W
Newly Minted Pigmenteer
williamwestmorelandNewly Minted Pigmenteer
 Questions & Conversations
How to count items in a metric without removing dimensionality?

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?

957
Benoit
Community Manager
K
Seasoned Pigmenteer
KevinSeasoned Pigmenteer
 Questions & Conversations
Is it possible to use Previous() simultaneously across multiple dimensions?

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

9109
Y
Newly Minted Pigmenteer
alexkonrad
Budding Pigmenteer
alexkonradBudding Pigmenteer
 Questions & Conversations
Automatically adding aggregations after collapsing

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

162
alexkonrad
Budding Pigmenteer
C
ChahatKeen Learner
 Questions & Conversations
How to import the data from another app without allowing the users to drill down

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?

201
alexkonrad
Budding Pigmenteer
A
Newly Minted Pigmenteer
AravindNewly Minted Pigmenteer
 Questions & Conversations
Alternative to long nested if

Hello!I seem to face a problem when constructing a trial balance for which i use nested ifs. So the formula goes like this IF('GL Accounts'='GL Accounts'."Revenue" ,'Revenue Staging',IF('GL Accounts'='GL Accounts'."Other income" ,'Other Income staging'))So the condition is different for each list item in GL Account dimension (Which has 40 items)When we try to use the nested ifs, it doesn’t allow us beyond 17 loops. Cannot use the switch statement as we have a different criteria for each list item. Have you guys gone through such a situation and found an alternative to long nested loops?Thanks in advance for your help!

233
A
Newly Minted Pigmenteer
K
Newly Minted Pigmenteer
Karin TauberNewly Minted Pigmenteer
 Questions & Conversations
Professional Training Metric Employee Manager

Hi,In the Pro Training (2.0), in the workforce planning module, there is on page 7 of the pdf, building the metrices. I don’t understand why the structure of the Manager is the same as for the Employee. Shouldn’t the Data type dimension be Employee Manager? Thanks in advance 

355
A
Newly Minted Pigmenteer

Badge winners

  • Read and Interpret Formulas Certified
    maxwell.vaughanhas earned the badge Read and Interpret Formulas Certified
  • Pigment Modeling Fundamentals Certified
    Akshara Phas earned the badge Pigment Modeling Fundamentals Certified
  • Pigment Like a Pro
    Akshara Phas earned the badge Pigment Like a Pro
  • Magic Connoisseur
    Benoithas earned the badge Magic Connoisseur
  • Star
    tlegrandhas earned the badge Star
Show all badges
Terms & ConditionsCookie settings