Discover

I want to prepare a present that has a list of all the other presents available to the user. How can I acehive this

Filter a second dimension based on the value of a first dimension in Discover

Contents Hi Community, Please bare with me whilst I try to explain what I am trying to achieve. This is a very slimmed down example, but suffice to say,…

• Answered

Help Getting Stacked Bar Plot to Use a Consistent Set of Colors

I am building a discovery that is a paired stacked bar plot with the following characteristics: The X-axis is year. The Y-axis is a percentage of total annual insurance cost of workplace injuries.…

• Answered

Let's talk about Dimensions and Measures

Dimensions and measures are the two central building blocks in multidimensional reporting. In Pyramid Analytics, they are mainly dealt with in the “Model” and “Discover” modules.…

How to get a Discovery Bar Graph to Sort by One Specific Group ?

I am attempting to build a bar graph displaying data segmented by two bars and I want to sort the bars by magnitude, but I want the bars to only sort by one specific category.…

• Answered

How to undo total column color formatting

I created a few discoveries and color formatted the total and Subtotal columns. I added color formatting to the rest of the table but was then told that this needed to be done in the Total columns as…

• Answered

Selecting Multiple Dimensions at Once

Hey all, This is a simple question about whether a certain functionality exists in Pyramid. Is a user able to select multiple dimensions and add them simultaneously?…

• Answered

Filtering on 2 dimensions and counts

Hi community, I am struggling to do something that I think should be possible so asking for help here I have a star schema modelled in snowflake and a Direct Query model in Pyramid consisting of a…

• 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

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

• Answered

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