-
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.…
-
Find Difference between two dates
Hi All, We need to find difference between two date dimensions present in our model. Is it possible to do it using formulate?
- Answered
-
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: 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,…
-
NEW: Explore Pyramid - monthly Data Challenge Environment
Trickle your Brain and keep Learning Right before the Weekend, we are happy to give you the exclusive chance to start playing with the brand new Explore Pyramid Environment and begin your first…
-
Learning Live: Formulate - 5 common business calculations
About this Video: This video we cover how to use the Formulate Module to complete five simple common business calculations. Each Example is completed with a live demo Content:…
-
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 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,…
-
Why are my formulas not showing up
I have a handful of formulas that execute successfully in a Public Content folder. However, in Discover, only 2 of them show up Even if it is a blank discover panel.…
- Answered
-
Learning Live: The Hub and Personalized Dashboards
About this Video: In this video we give you overview about a new feature in the platform: 'The Hub'. These Hub provides a method to display individual content when users log into the platform -…
-
Creating a dynamic parameter for a date range
Hi Everyone, I am trying to figure out a solution for the following issue. We have a contract with a start date and and a end date dimension. We want to select the active contracts within a year.…
- Answered
-
Learning Live: PQL Masterclass Vol 1
About this Video: This video is the first of two sessions that cover the Pyramid Query Language (short PQL) in detail. With PQL you have additional possibilities to influence the results of your…
-
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…
-
Learning Live: Creating Custom Visuals
About this Video: Pyramid offers a broad variety of visualizations out of the Box in Discover. In some cases there are specific visualizations that are better to explain the data set in question.…
-
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,…
-
Learning Live: Custom Columns
About this Video: In this video we give you overview about our new feature in Discover: Custom Columns. From the inital problem that is solved with them,…
-
HR Cube - Absenteism hours - Formulate
PYRAMID Hello could someone help me on this one ? I have a HR table, in which I have 3 columns : Absenteeism days Contract hours Calculation of absenteeism hours=absenteeism days*contract hours…
- Answered
-
Ordering the Months
Currently when I am displaying the MonthName field it defaults to showing me the names in alphabetical order. How do I fix this to show me the regular order (January, February, March, April, May,…
- Answered
-
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.…
-
Percentage points change
Hi We are looking at a solution to create point percentage change column. In the given example we would like to create a measure that can be calculated on percentages,…
- Answered
-
Weighted Product Distribution %
Good morning, I hope that someone can assist us with calculating a product's weighted distribution in Pyramid. Weighted Distribution % = The Total Value of the Customers that buy a Product (where…
- Answered
-
Learning Live: Time Series Capabilities
About this Video: In this video we give you an overview on how to use the time series capabilities in Pyramid Analytics. You will learn how to build comparisons against previous periods.…
-
How to add conditional formats (coloring) to elements for particular columns
Question: How to apply conditional Formatting to certain Columns In a recent Question in the Q&A Section by @Aaron Yohannan we got the question how to apply conditional formatting to certain columns.…
-
How to find the "1st Month of the Year of the Previous Month" in a list
How to find the "1st Month of the Year of the Previous Month" in a list In this question the user was asking how to find the first month of the year, but the basis for this search would not be the…
-
Learning Live: PQL Masterclass Vol 2
About this Video: This video is the second of two sessions that cover the Pyramid Query Language (short PQL) in detail. With PQL you have additional possibilities to influence the results of your…