-
How to create group headers for certain columns in Discover
What are the steps to create grouped/merged column headers in discover for Name and Address in Row 1? the discvover has 20 columns so adding just a text box in Present doesn't work well with the side…
- Answered
-
Experience on Ipad's
Hi Community, for us it is currently quite challenging to get a good Pyramid experience with an Ipad. We would like to use the pyramid app as it is easier to deploy on multiple Ipad's centrally.…
- 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
-
Time intelligence intervals
my content tends to have times between 9:30am - 4pm displaying charts in hour:minute date part categories would then yield 390 bars. How might i offer users option to see in 1, 2, 5, 15,…
- Answered
-
Difference actual week- week prev year
Hello, we would like to calculate the difference of an KPI actual year vs Previous year on weekly base (KW this year - KW prev Year). We have time attributes for Date, KW (i.e.…
- 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
-
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
-
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
-
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
-
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
-
How can a user check the logs for a scheduled model run where the schedule is created and run by admin user.
Scenario is that the target data source has write access only for admin or other specific users. That means the model can be scheduled/owned (i.e. run as) by the those specific users with write…
- 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
-
How can we have formulae appear in the text and a graph of the same data set appear in same discover.
How can we have formulae appear in the text and a graph of the same data set appear in same discover.
- 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
-
Obtaining accurate summations in a Many-to-One Relationship
I am having trouble grouping lines correctly so that I can get accurate totals. The basic premise is as follows: We are trying to transition away from buying item A and instead encouraging buying…
- Answered
-
User Login Stats
This is sort of a how to make the sausage type question. I do weekly, monthly and yearly reports of total logins to Pyramid and unique user logins. I do this by exporting the Entries log for the time…
- 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
-
Question on How to use Measure Lists and Parameters
I just watched this video: https://community.pyramidanalytics.com/t/x2yy1c4/how-to-use-measure-lists-and-parameters Thanks for the video, really nice to see all these videos coming out with Pyramid…
- Answered
-
Publication - Use Parameters to determine a selected date range
Good Morning, We have a publication that needs to be repeated by State and Category - this is working well. We also need the client to be able to select a Start Date and End Date to determine what…
- Answered
-
Feature Request: Popups not hiding Sidebar left
One of the main drivers for users beginning using pyramid seems to be fact, that the sidebar with navigation to jump to models, discovers or other is hidden when a popup opens (see screenshot).…
- Answered
-
OpenAI Integration - How to view the query of the "AI driven value"?
When creating AI Driven Values with ChatGPT, is there a way to view the current query of a column? We didn't find a solution for that and by extending the discover with ai driven values,…
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help