-
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
-
REPLACE- EMPTY VALUES
In reports when working with values using formulate we are able to replace the null values . In the given scenario we need to replace the empty values .…
- Answered
-
Font color not working on light blue color background .Ex Font color :#FFFFFF, Background Color:#85CCDB
For example see the attachment: I need all the headings in white Font.
- Answered
-
How to create a parameter driven list and search across multiple attributes
How to creating a parameter driven list and search across multiple attributes Imagine we have a long list of Values in a table. Now we want to filter out all lines that contain certain values but…
-
Tip of the Day - How to build a slicer that reflects hierarchies
How to build a slicer that reflects hierarchies In today's tip, we are looking at a special use case around slicers. How to adapt them to reflect a hierachy that is used in the report.…
-
Tip of the Day - GenBI directly on SAP HANA and SAP BW
GenBI from Pyramid works with all sorts of Data Sources, in this video we look at the direct access to SAP HANA and SAP BW from the same dashboard. Pyramid does NOT use the ODP API to access and…
-
Tip of the Day - Dynamic dimensions and measures
How to create dynamic dimensions and measures that can be exchanged This tip & trick has been provided by @Michael Daun who created this solution while working on a project What to we want to achieve…
-
KPI with dynamic texts
Hello, I am trying to add a dynamic text to the KPI which shows a Year-over-Year change in between the quarters in my presentation. However, the text only returns a result if all years,…
- Answered
-
How can I control the Size and Position on a more granular level
Currently, when adding an element to Present, the Size and Position options are set to increments of 10. This does not allow for design flexibility for developers.…
- Answered
-
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 - Multi-lingual GenBI (spanish and german)
These Generative BI examples show how Pyramid can operate with multiple languages – both for the user and the database! Watch how users can talk in their native language (for example German and…