-
How to: Create a dynamic set of dates
Question: How to create a dynamic set of dates During a recent discussion we got asked how to create a dynamic set of dates. There are two approaches to the tasks,…
-
Tip of the Day - Dynamic dimensions and measures
How to create dynamic dimensions and measures that can be exchanged This tip & trick has been provided by @Michael Daun who created this solution while working on a project What to we want to achieve…
-
How to build Dynamic Today, current month, Previous Month etc. in Pyramid Formulate
How to build Dynamic Today, current month, Previous Month etc. in Formulate Get Dynamic Dates Using Formulate Wizard. To make the access on the latest information,…
-
How to: Creating a Custom Column to create a new attribute
How to: Creating a Custom Column to create a new attribute In this usage of Custom Column, a new feature for Pyramid 2023, we will create a new column that represents the Domain of an email address…
-
How to: Display Daily Data in a Calendar View
How to: Display Daily Data in a Calendar View When you are working with Daily Data it will sometimes make sense to display the information in a Calendar view.…
-
How to combine Values from different Measures in one chart
How to combine Values from different Measures In this question we got from a customer, the user tried to combine two values who are in different measures into one single chart.…
-
How to Update Python and/or R Packages
Sneak: Working with multiple Python and/or R Environments. Recover in Model Definition Files Tips & Tricks created by the Pyramid Customer Success Team This How To has been create based on the The…
-
Tip of the Day - use formulate to calculate percentages of some elements
Our video of the day looks at a way to calculate percentages of elements A question came up from a client on how to calculate the percentage of two elements in a dimension from the total of this…
-
How to share Pyramid Reports and Dashboards in Microsoft Teams
The easier Users can get access to information, the better. One way to bring Data to End Users it to integrate it into internal communication platforms like Teams.…
-
Tip of the Day - How to Replace Nulls with Zeros
How to Replace Nulls with Zeros This tip will walk you through how to manipulate a column within Model, to replace NULLS with Zeros, using the convert and replace nodes within a data flow.…
-
How to add subtotals for % Values to sum up to 100% in the category
Question: How to add subtotals for % to sum up to 100% for the category In a recent internal discussion we came across this question and wanted to share the solution to a broader audience.…
-
Tip of the Day - How to format a measure that is in seconds as hours minutes and seconds
How to format a measure that is in seconds as hours minutes and seconds Imagine you have a table column in a model that represents the duration of a period in seconds,…
-
Tip of the Day - Multiselect Slicer Elements
Our video of the day looks at the new multi-select capabilities for slicers. Multi-select drop down slicers let you select multiple slicer elements simultaneously and filter the query by those…
-
How to create a parameter driven list and search across multiple attributes
How to creating a parameter driven list and search across multiple attributes Imagine we have a long list of Values in a table. Now we want to filter out all lines that contain certain values but…
-
How to print a Publication from a Dashboard
How to Print a Publication from a Dashboard In this Tip & Trick we will cover how you can embed a print button that allows you to print an existing Publication directly from your Dashboard.…
-
How to build Aggregate blocks for a Dimension
How to build Aggregate blocks for a Dimension When you are working with larger lists it is often necessary to define groups of elements into a single aggregated element that contains the totals for a…
-
How to use Measure Lists and Parameters
How to use Measure Lists and Parameters Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid. Use the Tips & Tricks series to give you a quick way…
-
How to add a Custom Visual
How to add a Custom Visual Pyramid offers a broad spectrum of standard visualizations that are available to users in the Discover App. In order to include additional visualizations,…
-
Pyramid #DataTipoftheDay on Youtube
Video of the Day - Chatbot AI-Designer Our video of the day is about one of the new features in our latest release Pyramid 2023.11 Watch a 2 minute Demo of our Chatbot AI-Designer for Present and…
-
How Pyramid Determines the Maximum Number of Rows in Reports and Queries
In Pyramid Analytics, managing data queries efficiently is critical for system performance and memory usage. Understanding Query Limit Settings The below settings are located in the Admin Console…
-
How to add and work with Bookmarks
How to add and work with Bookmarks For frequent users of reports with many slicers, choosing pre-saved filter combinations for your area of interest can be a significant time saver.…
-
How to use Parent Child Hierarchies. From Tips & Tricks June 2022
Sneak: How to use Parent Child Hierarchies The Tips&Tricks Series is produced by the Customer Success Team. It highlights several easy to follow instructions and range from simple tasks to more…
-
How to build a Waterfall Charts with Context Calculations
How to build a Waterfall Charts with Context Calculations Waterfall Charts are a great way to see contributions to a resulting value in an easy way. With Context Calculations the Waterfall represents…
-
Tip of the Day - Visual Tool Tips
Create custom graphic tool tips that display a given data discovery or presentation when hovering over a specified measure in a selected visualization. The report displayed in the tool tip is…
-
Tip & Trick Pre-Query Slicers
Pre-query Slicers allow users to set the slicer selections for specified slicers and parameters upon opening the Discovery report, before the query is loaded.…
Welcome to the Pyramid User Community
Pyramid User Community