Got a question about your models? Want to start a discussion? It's here!
Recently active
The documentation for the SEASONAL_LINEAR_REGRESSION function states that the “seasonality” argument can have the following dimensions:No Dimension or Dimensions of Text 1I have two questions about this…When I try to use a metric with no dimensions as this argument, I get the error “Function SEASONAL_LINEAR_REGRESSION requires argument 2 to be a positive integer”. What am I doing wrong? The metric where I’m using SEASONAL_LINEAR_REGRESSION has three dimensions (month and two non-time dimensions). What does “Dimensions of Text 1” mean?
Hello community, I am creating a PnL report for our company. At the moment it displays revenue (metric), cost (another metric), gross profit ( metric from formula) and so on. The metrics are derived from a transaction table that I imported.Now I would like to show the total USD and in the coloumn next to it I want to display avg per person. I have calculated the Avg per person and managed to create the same table as above from the avg metrics of the above metrics. BUT because these are metrics, I cannot have them side by side in the table. If I add the avg per person to my total table it will just add all the rows below. I can move upp the “metric” in pivot to columns but then that messes up the revenue, costs, gross profit placement etc.I created a dimension called version and was able to attach that as a property to the total metrics and the avg metrics, but haven’t found a way to union the two metrics with the variant dimensions. So my question is, how can I create a dimension from
Often, we get the request to load enterprise volume data from MySQL RDBMS into Pigment. While Pigment doesn’t have a dedicated MySQL connector or ODBC capability, this can easily be achieved via Pigment’s import API. Below is example code that connects to MySQL, executes a SQL statement, and imports the data into Pigment. 1. Generate Pigment Import API keyhttps://community.pigment.com/security-permissions-82/manage-api-keys-226 2. For Imports into Pigment (to understand the process)https://community.pigment.com/importing-and-exporting-data-95/how-to-trigger-an-import-with-apis-230 3. Load Data from MySQL RDBMS into Pigment via Pigment’s Import API using Python:import mysql.connectorimport getpassimport requestsfrom io import StringIOimport sysimport logging# Configure logginglogging.basicConfig(level=logging.INFO, format='%(asctime)s - %(levelname)s - %(message)s')# MySQL Connection & SQL queryusername = 'MYSQL_USERNAME'server = 'MYSQL_SERVER'database = 'MYSQL_DATABASE'password = g
I have a metric : which has 20, 20, 20 and 15, 11 numbers I need to show Top 2 of the products: It only shows the 2 products with 20 valueIt should show all those products with 20,20, 20 and 15 value20 is a tie number.
Microsoft Excel imports/exports can be achieved through using the Pigment Import/Export API and Excel’s VBScript. It will need the following information: 1. Generate Pigment Import/Export API keyhttps://community.pigment.com/security-permissions-82/manage-api-keys-226 2. For Imports into Pigment (to understand the process)https://community.pigment.com/importing-and-exporting-data-95/how-to-trigger-an-import-with-apis-230 3. For Exports from Pigment (to understand the process)https://community.pigment.com/importing-and-exporting-data-95/how-to-export-data-from-pigment-with-apis-229 4. The Excel work First enable Developer Tab in Excel Open Excel. Go to File > Options. In the Excel Options dialog box, click Customize Ribbon. Check the Developer checkbox and click OK. Create a VBA Macros Go to the Developer tab and click Visual Basic. In the VBA editor, insert a new module: Right-click on any existing module or the workbook name in the Project Explorer.
Often, we get the request to load enterprise volume data from Microsoft SQLServer RDBMS into Pigment, whilst Pigment doesn't have a dedicated SQLServer connector or ODBC capability, this can easily be achieved via Pigment's import API. Below is example code that connects to SQLServer, opens a cursor, executes a SQL statement and imports the data into Pigment. 1. Generate Pigment Import API keyhttps://community.pigment.com/security-permissions-82/manage-api-keys-226 2. For Imports into Pigment (to understand the process)https://community.pigment.com/importing-and-exporting-data-95/how-to-trigger-an-import-with-apis-230 3. To load data from Microsoft SQLServer RDBMS directly into Pigment via Pigment's Import API using Pythonimport pyodbcimport getpassimport requestsfrom io import StringIOimport sysimport logging# Configure logginglogging.basicConfig(level=logging.INFO, format='%(asctime)s - %(levelname)s - %(message)s')# SQL Server Connection & SQL queryusername = 'SQLSERVER_USERNAME
Often, we get the request to load enterprise volume data from an Oracle RDBMS into Pigment, whilst Pigment doesn't have a dedicated Oracle RDBMS connector or ODBC capability, this can easily be achieved via Pigment's import API. Below is example code that connects to Oracle, opens a cursor, executes a SQL statement and imports the data into Pigment. 1. Generate Pigment Import API keyhttps://community.pigment.com/security-permissions-82/manage-api-keys-226 2. For Imports into Pigment (to understand the process)https://community.pigment.com/importing-and-exporting-data-95/how-to-trigger-an-import-with-apis-230 3. To load data from an Oracle RDBMS directly into Pigment via Pigment's Import APIimport oracledbimport getpassimport requestsfrom io import StringIOimport sysimport logging# Configure logginglogging.basicConfig(level=logging.INFO, format='%(asctime)s - %(levelname)s - %(message)s')# Oracle Connection & SQL queryusername = 'ORACLE_USERNAME'connect_string = 'ORACLE_CONNECT_STRI
Exclude CountriesI’m trying to show the Revenue by Country and where countries have nil/zero revenue, how would you Exclude them so even the name doesn’t pop up? I’m wondering is it because my main data set has all countries with the longitude/latitude.
Hello Everyone, I want create a revenue metric. I Create all the dimensions and transaction list. When I add a formula there is no problem of dimension, but the value are only in January month. But in my transaction list the Dimension Month is present. I dont understand why all the values are imported in only one month. Here is my formula ( 'Sales History Unit'.unit [By Sum : 'Sales History Unit'.month, 'Sales History Unit'.Customer, 'Sales History Unit'.'Product Group'] ) Thanks a lot
Examples of how you can import data to, or export data from Pigment using the Pigment API and Python. 1. Generate Pigment Import/Export API keyhttps://community.pigment.com/security-permissions-82/manage-api-keys-226 2. For Imports into Pigment (to understand the process)https://community.pigment.com/importing-and-exporting-data-95/how-to-trigger-an-import-with-apis-230 3. For Exports from Pigment (to understand the process)https://community.pigment.com/importing-and-exporting-data-95/how-to-export-data-from-pigment-with-apis-229 4. To import data using Python:import requestsimport csv# Replace with your actual Pigment API key and import IDAPI_KEY = 'YOUR_PIGMENT_IMPORT_API_KEY'IMPORT_ID = 'YOUR_IMPORT_ID'API_URL = f'https://pigment.app/api/import/push/csv?configurationID={IMPORT_ID}'# Path to your CSV fileCSV_FILE_PATH = 'yourfile.csv'# Read the CSV filewith open(CSV_FILE_PATH, 'r') as file: csv_data = file.read()# Set up the request headers and payloadheaders = { 'Authorization
Automated Google Sheets imports/exports can be achieved through using the Pigment Import/Export API and GSheets Apps Scripting capability. It will need the following information: 1. Generate Pigment Import/Export API keyhttps://community.pigment.com/security-permissions-82/manage-api-keys-226 2. For Imports into Pigment (to understand the process)https://community.pigment.com/importing-and-exporting-data-95/how-to-trigger-an-import-with-apis-230 3. For Exports from Pigment (to understand the process)https://community.pigment.com/importing-and-exporting-data-95/how-to-export-data-from-pigment-with-apis-229 4. Write/Copy the GSheets App ScriptFirst, open your GSheet, then go to 'Extensions > App Script'. The scripts below can be copy and pasted into the App Script editor, just remember to press the ‘Save’ button.Note: These scripts and scheduling steps may require Google Drive privileges to set. This is an example to pull (export) data from a defined view in Pigment into a GSheet.fu
Hi, I did have my profile on Pigment Community/Academy when working with another company and I'd like to assign this new to the previous to one to not to loose all my previous activity.How can I achieve this?Thanks!
I have a source metric ABC with dimensions: project and year of data type: numberneed to have a target metric with dimension year, current formula in target metric is :SUMOF(ABC)/COUNTOF(ABC), but i want year as a dimension too in target metric.currently, it doesnt have any dimension in the target metric.
I successfully connected Google Sheets to Pigment. After initiating the data import from Google Sheets to Pigment, I receive a message indicating that the import was successful, but the data is not imported into Pigment and I get the following error message:"Missing column in CSV Some header(s) in the mapping configuration are not found in the CSV."However, the headers in the imported file are identical to those in the Pigment list.You will find the screenshots below.
Hi Community,How can we exclude invalid values in a dimension from appearing in the Page Selector in Pigment? For example, we have some inactive project codes and cost centers that we’d like to remove from all dropdowns, but they still show up.I believe there’s an option to manually edit the Page Selector to exclude those codes, but that would require updating it on every board and repeating the process whenever new codes are marked inactive.Is there a cleaner or more efficient way to handle this? Thanks,Neo
I am working on setting up an integration between TeamOhana (headcount platform) and Pigment, which needs to be connected through an API request. Using this link, I have been able to set up the API connection and the action button to trigger the integration but I am unsure of where is the data getting pulled into? Do I need to set up a transaction list beforehand and then somehow link API request so the transaction data in Pigment gets updated? Essentially where is my data going if the API request result shows successful?FYI: It is Authentication: Bear <token> set up.
