-
Splitting dataset Train Error
I am trying to spilt dataset into a train and test using Python Node and Learn&Predict. I get an error below related to pyramid_eval_out.write. How can it be fixed? Error PyramidException:…
- Answered
-
Renaming direct query table does not change underlying name that is used. Correct functionality or a bug?
When renaming a direct query table, the original table name is often used in other areas (security scripts, join statements as shown in attached image).…
- Answered
-
Custom user dimension linked to a specific e-mail account
Dear all Irrespective of my attempts, I still need to succeed in creating a dimension of specific users/clients with a particular e-mail account suffix.…
- Answered
-
Identifying Duplicated Elements
Hi all, I have a discover object containing products and their status. I want to identify products where the attribute status is duplicated. i.e. Products where the status has been assigned more than…
- Answered
-
Multi-measure pie charts
I have to measures in percentage that add up to 100% and I want to show in one pie chart both of them. I'm using version 2020.27.113 but it doesn't work for me. Could you please explain how to do it?
- Answered
-
real time data refresh
For the use case of direct database query is it possible to set an automatic refresh let’s say every 10 seconds without clicking run query or interacting with the chart?
- Answered
-
Get data from 2 months ago
Hi, I need to get for a new business logic (AKA formulate section) data dynamically from 2 months ago in order to divide it by data from 1 month ago. I don't have the "2 months ago" filter built-in…
- Answered
-
comment out parts of formulate in business logic
Hi, I'm writing a business logic using a formulate and calculating it based on a calculation of (a+b+c) / (z+x+c+v). I want to check each part on its own to make sure it gives the right output.…
- Answered
-
LineBreak in a measure
Hi, I'm trying to create a measure to be used as tooltip and it could contain text that is long. Is there a way to add a line break or new line in the measure via a PQL formula ?…
- Answered
-
Analyse Further Multiple Measures on 1 Line Chart
If you are using analyse further, is there a way to get 2 measures on the same line chart?
- Answered
-
Certification for L1 : Publish (2020.17) not being generated
Hi , it shows 'in-progress' status despite completing the training and the assessment(93%)
- Answered
-
Sequential sorting of a single dimension by multiple measures
Hello everyone, I am trying to ascertain whether I can sort a table on a single dimension column but apply sequential sorts using more than one measure.…
- Answered
-
Adjusting the Visuals in the Publication Page
How do adjust the Grid Visual within the page size in Publication? My visual has 10 columns. While dragged into the page in Publication, it is not adjusted on the page.…
- Answered
-
Export date member column to excel as date and not Text
Is there a way to export a report to excel with date column formatted as date and not text?
- Answered
-
Preview the Publication
Hi, Is there any preview option in publication before print & export in the different formats (See the below image)? It is good to preview before the export instead of each and every time ran the…
- Answered
-
Gantt chart?
Can Pyramid be used to create a Gantt chart? https://help.tableau.com/current/pro/desktop/en-us/buildexamples_gantt.htm https://www.atlassian.com/agile/project-management/gantt-chart#:~:…
- Answered
-
can pyramid model maintain timestamps with microsecond precision?
i want to down sample a vertica source table via pyramid model "query" to a vertica target table but my microsecond precision timestamps are getting chopped to precision in seconds.…
- Answered
-
From and To Parameters not working in dashboard.
Hello, I've implemented 'from' and 'to' parameters for GAAP accounting periods in a discovery tool. When I adjust these parameters, the tool correctly updates a range aggregate and provides accurate…
- Answered
-
Use a formulate to set the default parameter value
Hi, I have a parameter value which allows the user to select the GAAP Accounting Period, at the moment to make it easier i have a list which goes from 199901 to Prior month close (202304),…
- Answered
-
How to save the Analysis measures.
Hi, I have calculated some measures by using Analysis like Forecast, Regression, Statistics so on. I couldn't able to share(right click -Mark shareable option) the measures.…
- Answered
-
Send Multiple discovery in single Excel sheet
Hi, I'm working on a publication, in which I have multiple discovery reports. When I try to export to excel, the generated excel creates multiple sheets for each discovery.…
- Answered
-
Not Displaying formulas in Discovery
Is there any particular reason that all formulas which we have done by using Aggregation Blocks in Formulate-Formula are not displaying in the Discovery? Aggregation Blocks Contain: Aggregation, Sum,…
- Answered
-
Connecting with Anaplan
Hello! My finance team is interested in connecting Anaplan to Pyramid. Have you done that successfully and if so, what did you find that worked the best?
- Answered
-
Sort a hierarchy using multiple measures
Hello everyone, I feel this should be straightforward but struggling to implement. I would like to sort a hierarchy by multiple measures, so that there is a primary measure used for sorting,…
- Answered
-
Linear regression P value
Dear all Are there any plans to include the p-value in linear regression statistical explanations, or is there a way to determine the p-value? Thank you Dolf Jordaan
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
2024 Gartner MQ for BI and Analytics
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help