-
Default grid styles
Unsure if this has been fixed already (I'm on version 2020.18.055)- I have set the default grid type in my user defaults to be a flat mode grid. When I create a new discovery,…
- Answered
-
differences in standard deviation
Hi, I am working on a scatter plot and want to show the standard deviation. I have used three different methods, one from formulate which gives one standard deviation line (green line),…
- Answered
-
Parameter Format
Hi, As per the above, is it possible to change the default formatting of a parameter. I would like the values within the parameter to display as a %. The graph that the parameter interacts with has…
- Answered
-
Export to Excel - keep format of conditional formatted grid data
Hi, I'm trying to export the format of conditional formatted grid data to Excel. Columns and rows are formatted but not the data itself. Is there a way to do it?
- Answered
-
Group By option for grids
I have this report that shows allocation details for sales invoices, and I'm having a problem with transactions that cancel each other out; when we reverse a transaction in our system,…
- Answered
-
Selection set under Data Point not possible
Hi, I was trying to make a formula in which I wanted to use a data point in order to select both a measure and a dimension. For the dimension I wanted to use a set made on that dimension,…
- Answered
-
blank row in between different values
Is it possible to add blank rows in the tables? i.e. show 3 value measures, have a blank row then another 3 value measures?? So I have a table which shows increased, reduced, unchanged,…
- Answered
-
Export to Excel
When using version 2020.20.586, I am no longer able to export a discovery to excel that contains totals. The output status shows as failed. Has anyone else experiences this issue and if so,…
- Answered
-
Date slicers- show months in chronological order
I am wondering if there is something we need to do differently with the 2020 version of Pyramid compared to 2018, to make date slicers list months in the proper order?…
- Answered
-
Display "all" in dynamic text when user selects all options in multiselect dropdown
We have a multiselect dropdown slicer that has a lot of values and when a user clicks the All button in the dropdown it is populating the dynamic text with all the options.…
- Answered
-
Export/Publish to google spreadsheets
Dear all, we're introducing google workplace in our company and are wondering whether it is possible to export/publish to google docs/spreadsheets directly. Best regards, Olaf
- Answered
-
Scheduled Model Refresh not showing under Schedule Listing
Hi, As per the above mentioned, does anyone know why a model which has an active schedule on it wont display under the usual schedule listing in pyramid (via the settings cog > Schedules > Models).…
- Answered
-
How do you convert unix epoch time to time?
I have a time stamp, in UNIX epoch format, from a json feed "1637491969" How do I convert it to time in Pyramid?
- Answered
-
Truncating decimal numbers in dimensions
I have a custom model that has currency exchange rates; the rates are decimal numbers with 4 places, in the sql query I have them truncated to only show 4 places In some of my discoveries,…
- Answered
-
Dynamic Text - Getting max used columns data
Hi all, As per the attached pic and above mentioned. Is it possible in the dynamic text editor to get the column number of the highlighted section, baring in mind that when changing filters the…
- Answered
-
Additions to conditional formatting
Hi I reckon this should be a simple one. Essentially it's a combination of the logical band with "positive negative" and the continuous linear function. Say I have a range going from -50 to +200.…
- Answered
-
Advanced slicer settings
We have just upgraded to a new version of Pyramid and I can see that there are now advanced settings in slicers I am selecting "remember user's last selection" but it won't stay selected!…
- Answered
-
Calculations using dynamic text
I am trying to find a way to create a dynamic text based on other dynamic text in the presentation slide So I have a DT [Outstanding amount] and another [Disputed amount] I want to add a third to…
- Answered
-
Calculating a CLV measure
Has anyone calculated CLV on a 24 month contract period where there are customers who have been there longer than 24 months? Payments are monthly I am trying to get the average CLV per customer.…
- Answered
-
Using Variables with strings in Master flow
In a master flow I'm trying to call a REST API with part of a result of another REST API which is stored in a variable and the body would look something like {"key":…
- Answered
-
Date Calendar Slicer Load Time Settings
I'm trying to find a way to set the load time settings for the Date Calendar slicer. There isn't an option (v2020) to set the load time settings. When the presentation loads,…
- Answered
-
Could we desactive the option "analyse further"?
Hi everyone, i made some discoveries and i need to desactivate the option "analyse further" for viewer user. I've tried profil, execution parameter in discovery or presentation.…
- Answered
-
How Do I Use A Small Font Size In Questions And Answers?
Is there any way to use a small font size in questions or answers? That is, for the purpose of minor and possibly irrelevant information? I've checked the Markdown syntax but couldn't find anything.…
- Answered
-
Combine members of different dimensions as a new dimension
Hello I am trying to create a new dimension by combining members from two other dimensions. Is this possible? For example: Combining a member from the Product dimension with a member from the…
- Answered
-
Presentation has no charts due to measures calculated
Hi I am needing some guidance on how to make calculated measures on variables in the discover available to a reportviewer. The reportviewer sees empty charts due to three measures create.…
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
2024 Gartner MQ for BI and Analytics
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