Got a question about your models? Want to start a discussion? It's here!
Recently active
Hi everyone, I am trying to display images in my reports but i get this error message “The image couldn’t be displayed” The link is working when pasting it in the browser, and the source is authorized Here is the link of the Image i would like to display : https://drive.usercontent.google.com/download?id=1P7ssJsoxLzsQjkGdRf_b4EFTYvIbAQmr&authuser=0 Thank you in advance for your help
Hi, I’m trying to add a view of a monthly total headcount metric (a cumulative value, dimensioned by month) to quarterly and annual tables that will show only the final headcount from the last month of each period. For example, I know Pigment’s default behavior is to sum this cumulative headcount across every month of a year if I add the headcount metric to an annual table directly, but I need to isolate December 31 headcount only. Is there a relatively simple way to create these period-end summary numbers?Thanks!
Hey there,I’m trying to use yesterday’s revenue to forecast the rest of the month’s revenue.For that, we created a Day dimension, which is a calendar type.Strangely, when displayed in the dimension itself, it looks normal (like a date).However, when we add it to a metric pivot it always adds the time. How do we stop it from doing this?I’ve already checked the Day dimension Special Properties and Default Display Name and it just uses the Name column for this.Images below.Any help is much appreciated! Day dimensionDay dimension used in a metric pivot
Hello,I am trying to calculate the number of employees who left by hire date cohort and number of months that they stayed in the society. Here is the formula I have (but doesn’t work because it is too complicated I think):Employee [BY COUNT: Employee.'Cohort Month', Employee.'Month tenure cohort', Employee.Country, Employee.'First Job Position'.'Team Graph HR']The Cohort month corresponds to the month of arrival.The Month tenure cohort corresponds to the number of months the employee stayed in the society.I want this metric by team department (Team Graph HR) of their first job position (because some employees can evolve from one job to another in the company).Could you please help me finding the best formula here?Thanks!Elodie
Curious to know if there any 1st or 3rd party connectors to get capiq data directly in pigment automatically.It’s not too difficult to upload a CSV on a monthly cadence, but would be great if there was a live connection. The alternative is to send this to an internal DWH then to Pigment, but that might be a lot of internal work from our BI teams.
Hi, I want to use the AND function together with the IF function in one formula in a property of a transaction list. Is this possible in Pigment? I can’t seem to get the AND part to be recognised when using it as part of the logical test of an IF statement, the way you can in Excel. In Excel for example I can write an IF statement using AND:=IF(X2>7,"check",IF(AND(E2="Direct",M2="Retail O&O",X2>0),"check","OK")) But in Pigment when I type AND as part of my IF statement, the function doesn’t seem to be recognised and my formula doesn’t work. The text for ‘AND’ doesn’t show up in green the way it does for the IF function (or other functions.) I don’t have any issues using the IF function otherwise, or nesting multiple IFs in a formula, it’s just that I can't seem to use IF with AND. Please let me know if it’s possible, or if perhaps I need to write it in a different way? If not possible I suppose I can create a separate property to do the AND check. Thanks,Cat
HiI want to sum the values from my current starting point to the last value available in a metric. As you can see first value is 0.22 and last is -30,993,214 and sum of all those in middle will be 30,669,213 something.that metric called inp_when to sell asset differs for each sage entity asset. How can i go about doing this calc in simple way? I tried moving sum etc but doesnt work.
Hello,I have created the budget based on historical data (budget version based on actuals version up to a switchover date), but at each closing period and when we import the new data, the historicals can vary so it makes my whole budget move… The uploaded data for the actuals is imported into several transaction and dimension lists.It is not optimal as the budget should be closed as of now and not moving. Has anyone encountered the same issue? The idea would be to be able to use the budget version in comparison tables so it needs to be fixed in the app.Hope this makes sense!Thanks,Elodie
Hey,I am trying to reference the headcount for December and apply it to all months in the relevant financial year as part of a calculation. i.e if head count in Dec 24 in 100 and Dec 25 is 150, the formula would show 100 for all months in 2024 and 150 in all months of 2025.Has anyone done anything like this before and found a solution? Thanks!
Hi! Can someone please help with setting up the formula for below? Thanks in advance!----Dates:Given Data (yellow highlighted) Question: I am seeing for formula to get the result below yellow highlighted row, “Result”. The calculation starts from 3rd months from the start date, 10/31/2022. So it needs to calculate “January value 18,792 minus start date value 18,792. The result for 2023 Jan is zero. Then, calculation is same concept but moves forward. It’s always deducting the start date value, 18,792. For July 2023, calculation is July 2023 19,355 minus the start date value 18,792, resulting 564.The calculation should stop in Bridge end date, 12/31/2023. Thank you!
Hello, I have gone through all of the available training and videos for Pigment modules and setting up Demos. I would like to know if there are any additional Demo resources and data I can use to test my skills.
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
Which formula can I use for Net Income at my balance sheet in the begging of the year where I need to transfer all Net income to Retained earnings / losses and start accumulate again? See below an example. I read this article below but I couldn’t understand:
Hi TeamI have a calc which uses Year dimension and the year starts from 1 to 20. There is an assumption metric which defines what year the crops will be harvested. So lets say currently the assumption is year 6 in which the crops will be harvested, then from that year onward second rotation will start and then follow similar process until Year 6 where it again will be harvested and planted again.So as an example in excel, you can see from FY19 the year starts as 0 as that is where initial plantation happen. Then it counts from Year 1 to 6 and then at Year 6 which is equal to our assumption metric (Year 6) as well, it stops and then a new cycle starts from 0 to 6 all over again. How can we built something like this easy way? I have tried thinking of using MOD in which lets say in our Year dimension, we have count column as well that goes from 1 to 20 . So what i am doing is saying if Year.Count/Assumption metric =0, then mark it as harvest year. Now how can i get it to count and reset
