-
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…
-
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
-
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…
-
including google charts in Formulate ( custom visual )
how can i use google charts in formulate-custom visuals , I have a code for for a chart - (have attached the code below) , how can I integrate it in FORMULATE_ CUSTOM VSUAL ,…
- Answered
-
Wrapping legend values in a line chart
Hello Pyramid Community! I have a very simple query on legend text. I am creating a line chart and the dimension I am using has long text values. Is there a way we can wrap legend text(each value…
- Answered
-
Static value list for a dimension
Hello Community, I am building a report for a client. I need to create a matrix grid with monthly return values(Jan to Dec) for each year starting 2017.…
- Answered
-
Making Custom Bins With Measures For Discover
So I have a measure that I want to use to make bins. Discover is able to have me create bins by rank, value, category, size, parameter, etc. Still, is there a way for me to create bins by custom…
- Answered
-
Calculation based on Date Filter Range
I am looking for a calculation of a value divided by month; however, the number of months is dynamic depending on the overall date range that the user has set.…
- Answered
-
How to use AI driven forecasting captions
How to use AI driven forecasting captions Pyramid allows you to add an AI driven forecast to your data based on a variety of algorithms. In the video below we show you how you can change the Captions…
-
How to define a common scale for primary and secondary Y-axis?
I have a (stacked) bar chart with two measures - one measure on the primary Y-axis, the other on the secondary y-axis. As these two measures should be comparable (imagine e.g. incoming vs.…
- Answered
Search for answers here or ask a question