Latest Activity

Dashboard Interactions

Dear community, Is there a way to filter multiple elements one after the other by clicking on them in the presentation mode of a dashboard? Here is an example:…

Pyramid Explore Internal Server Error 500

Hello, I hope I'm not asking a repeat question but I have been having this issue for the last few days when trying to complete the walkthroughs on Pyramid Explore.…

Custom Filter

Hi Team, I’m trying to build a date filter in Pyramid that includes the following options: Current Week Last Week Last Month Last Year Custom Range (with the ability to select a specific date range)…

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

Calculate the number of days from a date to the current date

Hello, How do you calculate the number of days from a given date in the model to the current date. We tried the following but cannot get it to work. We consistently get an empty set. Thanks, Rob Clark

Target Interaction - Background Filters

I'm trying to use a target to filter a table of transaction data based on the selection in a visual on a different page of the presentation. This doesn't seem to work when the visual has background…

How to call or execute(take as data-source) an SQL stored procedure in pyramid analytics

hi all, I was trying to call an SQL stored procedure from custom query into pyramid analytics in below way. exec dbo.[Get_SalesdetailsPyramid] The statement is valid,…

• Answered

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

Tooltip-Designer

Hello everyone, I would like to create a tooltip in a dashboard. The font size is set to 120. If I reduce this to the desired font size (e.g. 12), this is done with one click.…

Finding Numbers for Yesterday

Hi Everyone, Our daily numbers (sales, manufacturing etc.) works behind by a day. When we say daily, we mean what we did yesterday. How can I achieve that in a formula?…

• Answered

Indicator to ONLY the total/subtotal

I am aware of the option to remove/include the indicator from Totals.... Is there a way to include it ONLY for totals/subtotals?

• Answered

Last month of Quarter - Date Lists & Formulates

I need to create a rollforward which is a Quarterly rollforward (see SNIP below of rough draft). This will past 5 quarters of data. I will be creating formulas for each of the listed items (Beginning…

Connecting buttons to a slicer to display lists

I have constructed a global parameter with 3 buttons: "All Customers", "Customer group A" and "Customer Group B". I have made 3 corresponding lists (All based on the same dimension,…

• Answered

Comparing dates in a formula

What would be the best practice for comparing two date dimension fields in a formula? Here's an example formula we are trying to create: if(created_date<=evaluation_date, 1,…

• Answered

Add User Search Box within the Role Management Panel

Hello PA Team, I'd like to suggest a simple but very important usability enhancement for the role management interface in the Admin Console. Currently, when I open a role to manage its members,…

• Answered

Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula

I have a report example that shows values accumulating over a two-year time frame. If, at any point, the value for a specific Part/Type falls below a defined threshold,…

• 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