-
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,…
-
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…
-
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: 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…
-
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 - 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 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.…
-
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.…
-
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,…
-
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…
-
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 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,…
-
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 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…
-
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 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…
-
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 use a chart to filter other charts
How to use a chart to filter other charts In a question in the Q&A Section of the Community we got asked how to interact several charts so that they work as actual filters not just highlighting the…
-
How to build a Tree Map Chart with Measure
How to build a Tree Map Chart with Measure Tree Maps are a powerful visualization if well used and understood. Using Grouping and Measures we are able to create very insightful Tree Map Charts.…
-
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…
-
How to: Extract all data from Reports while removing report filters
How to Extract all data from reports while removing report filters Users might have Discover reports with existing filters (for example filtering the report to only display the top 10% of customers)…
-
How to create a Sankey Chart and Cascading Slicers
How to create a Sankey Chart and Cascading Slicers Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…