Questions & Answers Category

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

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.…

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

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,…

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

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 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

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

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

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

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

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

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

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

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 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

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 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

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 to I show data point that do not have a value

Hi, I have a report, where we don't have sales data for the time period, but I want to show the empty cells on the report . Like in this example 123456 didn't show up. Who could help me to solve this.…

• Answered

Setting dimension elements to a secondary axis

Hi, I don't know if the following is even possible using an OLAP cube model. I'm looking to create a graph to view the YoY data with the percentage change overlaid on the secondary axis as a line…

• Answered

Default theme not pre-selected

Hi, I have created a new theme (circled below) and made it the default within my pyramid environment under the admin settings, however when creating a new present / discovery the old default theme…

• Answered