-
Question on - How to print a Publication from a Dashboard
Thanks for this video, it works great but not for calendar slicer for me when I pick date range, any suggestions?…
- Answered
-
Pyramid Analytical
Hello All, We have embedded the Pyramid Analytical site within one of our SPAs with SSO enabled. The token must be retained for a seamless user experience.…
- Answered
-
Ability to hide the "start new conversation" option when using custom workflows
Does anyone know where the setting is that allows us to determine if both custom workflows and conversations can be used on a particular dashboard? We were able to control this in the past but I…
- 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
-
Improve Search Functionality of Data Elements
When using the search function (via the magnifying glass icon) for data elements, such as searching for elements when creating a Formula, the output for the search only contains items that begin with…
- 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
-
Common Y-Axis Scaling for Trellis Column Charts
Trellis column charts are nice, but hard to use effectively when each chart has its own y-axis scale. How can I set them to a common scale, or, in the case where I have both vertical and horizontal…
- Answered
-
Displaying a 0 instead of a blank cell where there's no data for a given date
Hi. This is related to the How To article that Moshe Yossef kindly provided a while back - https://community.pyramidanalytics.com/t/p8hv3sr/how-to-create-a-dynamic-set-of-dates.…
- Answered
-
How to skip first N rows when reading an excel file using pyramid when the header is not necessarily the first row.
i have a simple xls but the header row is not always the first row of the file.Using a simple filter i could get rows as per clause in the filter below,…
- Answered
-
Dynamic SQL - Field Name Changes
Hi I have a table that has values in different languages, I wondered if there is a way to pass the field name for the 'current' language as part of a custom sql statement,…
- Answered
-
Needs the tooltip feature in other dimension rather than only in Measure values.
Hello, Can we have the feature request about the tooltip in other dimension rather than only in measure values? Currently it does appear only in Measure values and did find any scope to have it in…
- Answered
-
Importing Smartsheet data into Pyramid
Hi Folks, I'm leading a project, and the team wants to import Smartsheet data into Pyramid. We tried using the token, the sheet ID and the URL to do this, however,…
- Answered
-
Connecting to Tidal software to get the job data and display batch status in Pyramid.
I am creating a Dashboard in Pyramid. Would like to connect to Tidal software and get the job data and display batch status in Pyramid.
- Answered
-
Content Master Page | Copyright Year
We need to show a copyright year on every slide of our presentations. Currently when we create a new presentation, we add in a dynamic text that shows the year onto the Content Page:…
- Answered
-
Weighted Product Distribution %
Good morning, I hope that someone can assist us with calculating a product's weighted distribution in Pyramid. Weighted Distribution % = The Total Value of the Customers that buy a Product (where…
- Answered
-
Scheduling during work hours
We're trying to set up a schedule that refreshes a model during business hours only, between say 8 am and 8pm, M-F. Most importantly, we need to make sure it doesn't interfere with our nightly db…
- Answered
-
How To Install Python Packages
Hi. Out of the box, our Pyramid installation (running 2023.0.048) does not come with Python packages such as Pandas Matplotlib. How do we install these into Pyramid?
- Answered
-
Default panel settings
Hi, Is it possible to amend the default panel settings for a discover in present? Under themes in admin content there are a lot of configurable formatting options,…
- Answered
-
Sharing Bookmarks and Defaulting Bookmarks to Users
Is there an ability to share a bookmark to other users? Also once a group of bookmarks have been created can these be shared to another user?
- Answered
-
Bad design has left me with database fields that can be populated with comma separated list
Assume my database has the following columns ID DESCRIPTION USERS LOCATIONS I know that ID and DESCRIPTION are always relevant. USERS and LOCATIONS can contain 0, 1,…
- Answered
-
How to find weighted average using formulate to be able to use it in reports
Hi Team, I am aware of several measure like sum, average being available.Can you share how i can calculate weighted average? I have a usecase which has several such calculations and to migrate the…
- Answered
-
Dynamic calculation measure for Prev Qtr End using selected date of report
Hi I am wondering how to get the following functionality in a report Run the report for one Date (user select this date through a prompt when running report) The report should bring data for Date…
- Answered
-
Is there a way to filter out rows that are only showing inf and -nan(ind)?
Is there a way to filter out rows that are only showing inf and -nan(ind)? For example: Appreciate any input! Thanks
- Answered
-
Customizing y-axis settings on Discover with 3 different chart types
my charts render left to right as: stacked bar chart - where I want y-axis start at 0 and auto-max stacked 100 bar chart - where I want y-axis start at 0 max 1 ( or 100%) lollipop chart (would love…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.