-
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…
-
Formulate: Comine Standard List with a Measure
Hi guys, I'm not sure if I'm just "standing on the tube" or if my idea can't be realized, so I hope for your support: In formulate, I want to combine the function of a "standard list" with a measure:…
- Answered
-
Learning Live: Getting Started with Formulate
About this Video: In this video we give you an overview about the Formulate Module. Content: Lets dive in to Formulate, this video will cover the following topics.…
-
Is there any way to count filtered rows in formulate?
Hi together, Is there any way to count filtered rows in formulate? SID Status 1 True 2 False 3 True 4 True I need to count all rows and then just rows which are true,…
- Answered
-
How to build Aggregates with Context Calculations
How to build Aggregates with Context Calculations Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
How can I convert date hierarchy into specific format?
Hi together, I need a graph with a dynamic changing x-axis (last 12 months) with dates in the format “MM-YYYY”. I am using a date hierarchy to get the dynamic part working.…
- Answered
-
How to build logical categorizations (Bins)
How to build logical categorizations (Bins) 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…
-
Tips & Tricks: How to identify duplicated elements
How to identify duplicated elements? A recent Question on the Community asked what would be a good way to identify duplicates. E.g. where an Element has been assigned a Status twice where it only…
-
How to use the List Builder to create a Word Cloud
How to use the List Builder to create a Word Cloud Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
Change Value on horizontal axis based on variable value selected
I am trying to change dimension in horizontal axis of my graph based on the filter selected. For example, In graph I would like to change value in horizontal axis to created date year, quarter,…
- Answered
-
Live Connection SAP BW - Extrapolation of Budget values to a monthly split (linear)
Hi there, I would like to extrapolate the following budget values to a monthly view from a given year view only. For example, from SAP BW we only get the annual accumulated budget figure.…
- Answered
-
Learning Live: Introduction to Parameters
About this Video: This video we give you an introduction to Parameters and their use in the Pyramid Platform. How to build Discovers and add Parameters via Formulate to improve the report usability…
-
How to cluster outliers and add regression lines
How to cluster outliers and add regression lines Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
Text parameter which retrieves date ranges
Hello everyone, Is it possible to map text captions in a parameter to individual list objects. The business context is to enable the formation of date ranges which are either calendar or fiscal in…
- Answered
-
How to create a Switch List. From Tips & Tricks August 22
Sneak: How to create a Switch List 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 advanced use…
-
Adding an empty measure column to a Discovery
Adding columns is basically done by creating and selecting Calculated members/measures into the Columns selection area. In this case, the requirement is to add an empty column to discovery,…
-
Rank function
Hi Everyone, I am trying to use the rank function in Pyramid (similar to rank function in excel) to rank customers with highest revenue to lowest. The environment used is MS OLAP.…
- Answered
-
Pyramid Data Tip of the Day - Metadata Tooltips and Clickthrough
Video of the Day – Metadata Tooltips and Clickthrough Our video of the day looks at metadata tooltips and click through in the Formulate app. When working in the Formulate script editor,…
-
How to create a Quick KPI - Period on Period. From Tips & Tricks October 22
Sneak: How to create a Quick KPI - Period on Period The Tips&Tricks Series is produced by the Customer Success Team. It highlights several easy to follow instructions and range from simple tasks to…
-
How to create a custom sorted list for use in filtering. From Tips&Tricks 4/21
Sneak: Scrollable panel layout + Select/Deselect in Sub-Totals + Custom Sorted Lists + Member Color Lock The Tips&Tricks Series is produced by the Customer Success Team.…
-
How to create a Rank Calculation. From Tips & Tricks - Vol 2/21
Sneak: How to create a Rank Calculation 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…
-
Is it possible to toggle between 3 different date fields on a Present
I have a present with discovers that all are based on time. They show information about loans that have been created over the past X amount of time. This is grouped by a total for each past…
- Answered
-
Custom Visualizations
The formulate module should have a option for "Custom Visualizations". I dont see it, neither in our pyramid analytics platform nor the explore one of the community?
- Answered
-
Learning Live: Iterative Logic to Solve Complex Questions
About this Video: In this video we give you an overview about how you can work with iterative logical concepts in Formulate. Content: Lets check out this session,…
-
How to add a Custom Visual from the Marketplace. From Tips & Tricks Vol 3/21
Sneak: How to add a Custom Visual from Marketplace The Tips&Tricks Series is produced by the Customer Success Team. It highlights several easy to follow instructions and range from simple tasks to…