-
In a Discovery, how to identify records that do not have a corresponding child record
Hello, Here is the scenario. We have insurance policies in a policy table which joins to a coverage table by a policy_id primary key which is a foreign key in the coverage table.…
- Answered
-
Is there a way to disable the drop zone pop ups in Discover?
I want to be able to turn off the drop zone pop ups. I'd like this specifically for the 'Analyze Further' use case, but I would be satisfied with disabling it entirely.…
- Answered
-
Is there a way to apply Dynamic Masking (or something similar) to Measures?
My team and I would like to create a grid discovery for external users. We would like the values from certain Measures to be encrypted to external users,…
- Answered
-
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