-
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)…
-
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
-
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.…
-
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
-
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
-
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
-
How do I limit the available months per year
I’m trying to maintain two columns (2024 and 2025) on my Discover Matrix Grid. However, I only want the 2024 column to reflect data from July 1 to December 31,…
- Answered
-
Subscriptions via SMS
Is it possible to subscribe via SMS rather than email? I can't find anything in the support documentation... Thanks!
- Answered
-
Monthly percentage of annual value
Hello, I have created a line chart showing the monthly distribution of reported sales. I tried to add a tip tool that shows the percentage of the month's value relative to the annual value.…
- 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…
-
How to rename the forecast label
Hello, When I use the forecast tool I get Forcast1, forecast 2, forecast 3... I also do see an option to change the word forecast , but what I don't know is how I change it to be the next 6 months.…
- Answered
-
Add "Select All" Option to Multi Select Tree
Hello PA-Team! It would be highly beneficial to add a "Select All" option to the Multi Select Tree slicer, similar to the functionality already available in the Multi Select Drop Down slicer.…
-
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
-
Configuring FTP Source with Host, User, and .ppk File
Hi, Can I configure an FTP source using a Host, User, and a .ppk file? Thanks, Raveena
- 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
-
Need help with Dynamic Place Holder - Adddays (business days) to date
Hi I need to create a placeholder text which will show me my base period and comparative period dates. Both of these text placeholders are driven by load date.…
- Answered
-
Show Data for the most recent full week
I thought this was going to be easy (and maybe it is). I am working on creating a Pyramid usage dashboard. Part of that is looking at user logins. I have a Discover that shows the total number of…
- 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.…
-
Need help with a new list
I am working with a pre-existing model that I cannot change. In the model there are 2 dimensions, in this case we'll call them Number and Letter. what I want to do is make a new list where letters B…
- Answered
-
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
-
In a Data Model, I want to use one column as the description for another
I have a direct SQL data model. There is a URL(dashboardpageurl) column and a description (dashboardpage) of that URL in another column as shown: I want to use the description column in place of the…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.