-
Slicer to switch between months and weeks with same amount of bars in a barchart
Hello, we are currently building a dashboard that uses a global parameter as slicer to switch between months and weeks. The goal is to have some equal amount of bars in a barchart.…
-
How to wrap text in a Cell in Discover. From Tips & Tricks Vol 5/21
Sneak: How to wrap text in a cell 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…
-
Is there a way to create a parameter for a user to choose the time display (eg month, quarter, year)?
Our users would like to be able to choose, on a presentation, to display all the discoveries by either week, month, quarter or year. Is there a way to have a drop down that would change each…
- Answered
-
Dot and Ref. Line Plot
I am trying to reproduce a dot and reference line plot in Pyramid. I know what I'd like to do and am having trouble implementing it in Pyramid. I've attached the image of the chart which was…
- Answered
-
Seeking to Apply Security to End Users on 'Analyze Further' option for discovery
I am working on a discovery for a client-facing presentation that I want users to use the 'Analyze Further' feature to explore. Within the matrix grid discovery,…
-
Table in Present automatically changing to different style on resize.
Morning all, Quick question, if I create a table in a discover then place within a Present, the table will automatically change type when the size is reduced to a certain level.…
- Answered
-
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.…
-
Tip of the Day - How to lock colors of a member in a Report
How to lock the color of a member in a Report When you build a visualization, Pyramid automatically and dynamically assigns the colors in the Graph to the Members.…
-
Tip of the Day - How to use Calendar Slicers
How to use Calendar Slicers in a Discover Pyramid offers a variety of slicers for you to work with your data. Our Calendar filter is a very powerful tool that offers a lot more than just picking a…
-
How to build a cascading filter in Discover
How to use the cascade option in a Discover In this how to article, we will show you how to do to build a slicer that changes based on another slicer selection.…
-
Tip of the Day - Customize your Search with a Multi Item Slice Search
How to build a custom search with a Multi Item Slice Search Pyramid offers you ten different types of filtering in the Filter menu drop zone, ranging from simple filter slicers to more options like…
-
Tip of the Day - How to create a switch list in a report
How to switch between two sets measures list in a report If you want to display different sets of measures in a Report, you can do so by creating a variable list in Discover.…
-
Access Multiselect Parameters values in Formulate
Hi, I’m trying to access multiselect parameters in Pyramid Analytics. Specifically, when using multiselect parameters in a dynamic caption, only the first selected value is shown,…
- Answered
-
How to use KPIs and Gauges in a Dynamic Way
How to use KPIs and Gauges in a Dynamic Way The Use Case Working with a customer, I recently ran into an interesting use case that required dynamic band values in a KPI and a gauge view.…
-
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 - 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 - Time Calculation Wizard
How to use the Time Calculation Wizard Time calculation wizard in Discover is designed to help users quickly and easily generate a variety of date time calculations to be used in your analysis,…
-
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 can I get the count of days for every month using Formulate (Custom column)?
I need to get the count of days in each month using the custom column option in a formula or any other ways in Discover. Does anyone have a solution for this?
- Answered
-
How to Limit Color Logic to a Single Column
In the screenshot, there is a color-coded "Med Surg Supply Cost / Equiv. Patient Day" measure, where the red-green split is based off the average of those values. How do I 1.…
- Answered
-
Display Text Value Instead of Numeric Value
I have three columns one language column, gender column and count column (numeric). Inside my language column I have different languages as text , inside my gender column I have more than three…
- Answered
-
AVG OF WEEKDAY AND WEEKENDS
I have two columns weekday column and count column I want to find the average for each day and weekends based on month or year …How can we achieve this ?
- Answered
-
Charts Customization
I have male female COUNTS in gender column .The requirement is that the SVG should be filled only for the count based on gender. For example if male count is 40 and female count is 60 ,…
- Answered
-
Creating a Line Graph With Year as X-Axis and a String as Y-Axis
I want to create a line graph in discover that shows all of the years as the x-axis and the company name as the y-axis. So like a line graph that shows that a company existed from 2009-2024 and…
- Answered
-
How to use a Report or Page Trigger to generate a Publication when criteria are met
How to use a Report or Page Trigger to generate a Publication when criteria are met When you offer to trigger a report or page from your Publication, it only makes sense to start the process if the…
Welcome to the Pyramid User Community
Pyramid User Community