Welcome to the Pigment Community!

How to lookup text in list to pull list property? (Non-unique list)

I have 2 lists, lets call them ‘list1’ and ‘list2’. ‘list2’ has two properties with all values populated: ‘name’ and ‘product’. ‘name’ is a text property with duplicative values and ‘product’ is a dimension ‘product L0’. ‘list1’ has the same properti

tjain02Author

Restore application to a previous version

Hi,Does anyone know if there is a way to rollback an application to previous version before a certain change was made?

2023

Let’s Build What’s Next, TogetherNewsletter

Catalina IbarraCommunity Manager

Company News

Rested, relaxed and ready to roll into the new year! We've started it by releasing 5 new product features for you to get a head start with improved business planning. Check out what's new and coming up in the Pigment realm. 📊 Sharper insights: impro

80

alexkonradMaster Author

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 Cyc

tgilbertAuthor

Issue with Restoring an Application

I’m having an issue restoring an application. I’ve gone through the restoration process but when I open the app I no longer have access to certain key lists:Does it take a while for these to populate or is there another issue with our restoration?

tgilbertAuthor

What is the best way to compare two formulas?

What is the best way to compare two formulas to find differences between them?When updating logic in other systems I typically create a copy of the existing metric. Metric A contains the original logic and Metric B contains the new logic. In order to

977

tjain02Author

Previous() Override

Hi,I have a metric that pulls data from previous version and has metric override on. In current version, is there a way to delete data that came over from previous version without that cell reverting back to formula based result even if I don’t input

Ben EssalamaApprentice Author

Combination of different metrics leading to 1 SKU

Hello, I aggregated all the data received from the sales team and it gives me the quantity of bikes to produce for each combination of “Model”, “Colour”, “Fit option” and “Destination”. The combination of those different metrics also lead to 1 unique

jpardyApprentice Author

Multiple Currency Conversions to Multiple Reporting Currencies

I have a P&L that is reported at a local currency. The department for each line is what controls the currency, and there are over 20 currencies being used. Reporting needs to be available in Local and four other reporting currencies. I have a

512

J

3 days ago

Sandy BApprentice Author

Count numbers of occurences over a period (month AND year)

Hello, I want to create a table with some KPIs. One of them calculates the number of different suppliers over a period. Transaction list: Invoice (properties: Nb of Invoice (text), Supplier (dim), Month (dim), Cost center (dim) and Value)Dimensions:

1243

4 days ago

G

gttApprentice Author

How to lookup text in list to pull list property? (Non-unique list)

I have 2 lists, lets call them ‘list1’ and ‘list2’. ‘list2’ has two properties with all values populated: ‘name’ and ‘product’. ‘name’ is a text property with duplicative values and ‘product’ is a dimension ‘product L0’. ‘list1’ has the same properti

20

G

17 hours ago

alexkonradMaster Author

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 Cyc

tgilbertAuthor

Issue with Restoring an Application

I’m having an issue restoring an application. I’ve gone through the restoration process but when I open the app I no longer have access to certain key lists:Does it take a while for these to populate or is there another issue with our restoration?

tgilbertAuthor

What is the best way to compare two formulas?

What is the best way to compare two formulas to find differences between them?When updating logic in other systems I typically create a copy of the existing metric. Metric A contains the original logic and Metric B contains the new logic. In order to

977

tjain02Author

Previous() Override

Hi,I have a metric that pulls data from previous version and has metric override on. In current version, is there a way to delete data that came over from previous version without that cell reverting back to formula based result even if I don’t input

Ben EssalamaApprentice Author

Combination of different metrics leading to 1 SKU

Hello, I aggregated all the data received from the sales team and it gives me the quantity of bikes to produce for each combination of “Model”, “Colour”, “Fit option” and “Destination”. The combination of those different metrics also lead to 1 unique

jpardyApprentice Author

Multiple Currency Conversions to Multiple Reporting Currencies

I have a P&L that is reported at a local currency. The department for each line is what controls the currency, and there are over 20 currencies being used. Reporting needs to be available in Local and four other reporting currencies. I have a

512

J

3 days ago

BasMaster Author

Compounded growth rates in as a calculated item or SVA in a table

Hello,I was wondering if it is possible to create a CAGR % in a table (via calculated items or SVA). At the moment I have a separate metric that calculates a CAGR on a granular P&L level, but once I pull that metric in my table it simply sums or

270

5 days ago

M

Moosa MalickWallflower

Locking Version

Hi,I am trying to build a forecast in Pigment which can have multiple versions. Is there a way, we can lock formulas in versions? I know there is a scenarios feature, in which we can have formulas for different scenarios. Are scenarios the preferred

7108

17 days ago

tjain02Author

Connect Pigment to PowerBI

I am trying to export pigment data to PowerBI following the guided steps available on community, but I get an error “404 id not found”. Does anyone know what I could be missing in the setup? I used payload functionality to generate ID for metrics.

4254