User Community
Pyramid
Help
Learn
Support
Search
How to enable Javascript
Sign Up
Login
Welcome to the community!
User Community
Search
Search for answers here or
ask a question
Q&A
Best Practices
Product
Resources
Latest Activity
Home
Create post
Q&A
Latest Activity
Q&A
Best Practices
Learning Live Archive
Pyramid Dashboard Gallery
Tech Blogs
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
SAP
Security
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
Got stuck with a report? Start a discussion or help others to move forward.
Filter
Newest
Active
Popular
Most likes
Most replies
Most views
Status
Answered
Unanswered
Tags
Search
Follow
1
Displaying two grids as 1
Hi I have two tables that I am placing side by side in a presentation, Table A with values for 6 measures for a Company (C) and Table B with 6 percentage measures for C and 2 aggregate groups,…
Satveer Kaur
Customer
Satveer_Kaur
1 yr ago
1
reply
41
1
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
2
Changing Filter Type in Analyze Further
Is there an option/ability to change the filter type (drop down, buttons, multi drop down etc) in Analyze Further when adding new dimensions to the 'Filters' Drop Zone?…
Dan Sharman
Customer
Dan_Sharman
1 yr ago
1
reply
23
2
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
Custom Groupings
Hi, Is it possible to create custom groups or show a different field name? I know we can produce sets, but this doesn't quite achieve what I would like to see as sets filter the data.…
Ben Burchell
Customer
Ben_Burchell
1 yr ago
3
replies
37
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
Change path of Discovery in Presentation
There are a lot of duplicates within our Discovery's. While cleaning this up, i stumbled across two of the same Discovery's. Both of them are used in the same presentation.…
Angeline
User Certified Level 1
angeline
1 yr ago
1
reply
33
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
Why are my totals not also colored?
I have a simple table in which a couple measures are colored by a calculated value (which compares the measure shown to a reference measure ). The distinct rows for each member of the dimension work…
Philip Augur
Customer
Philip_Augur
1 yr ago
2
replies
27
Last reply
Philip Augur
Customer
1 yr ago
Q&A
Answered
Answered
0
Discovery to show Pyramid Content Items
Since we upgraded from 2018 version of Pyramid, opening related content from a model is no longer working (we are now on version 2020.23.117) I need a report that shows all models with created date…
Sophie durrant
Top Contributor
Sophie_durrant
1 yr ago
1
reply
22
Last reply
Avi Perez
Admin
1 yr ago
Q&A
Answered
Answered
0
Context sensitivity in Model (Secondary key)
The reason for this suggestion originates in product construction sets. The way products are constructed and then prepared for export to different international markets results in a many to many…
Bart
Top Contributor
Fotona
1 yr ago
4
replies
34
Last reply
Eduardo Azanza
Pyramid Employee Level 3 Certified
1 yr ago
Q&A
Answered
Answered
0
Exporting Publication to Powerpoint
Hi, When I export a publication that contains three charts and four pieces of dynamic text into powerpoint, the dynamic text doesn't retain formats and is often different sizes etc.…
Dan Sharman
Customer
Dan_Sharman
1 yr ago
2
replies
20
Last reply
Dan Sharman
Customer
1 yr ago
Q&A
Answered
Answered
0
Web Page Illustration
I would like to add an excel document that is saved to OneDrive via a shareable URL to a presentation. Has anyone successfully done this and if so, how did you accomplish this?…
Lori Read
Customer
Lori_Read
1 yr ago
1
reply
21
Last reply
samuel alma
1 yr ago
Q&A
Answered
Answered
0
Best Practices on CSS on Pyramid
Hi everybody, we are using pyramid for it's web embedding capabilities and would love to know everybody's best practices for css on it - do you just theme pyramid visualizations and then rely on…
Tim Anderson
Customer
Lead Web Dev
Tim
1 yr ago
4
replies
30
Last reply
Tim Anderson
Customer
1 yr ago
Q&A
Answered
Answered
0
Formatting issues on Scatter Graph x-axis
Hi, I can't seem to get the y-axis line to start at the 0 position on the x-axis- this is what I get when the "axis position" is on Zero position. I think this was something that could be changed in…
Satveer Kaur
Customer
Satveer_Kaur
1 yr ago
1
reply
17
Last reply
Max Shafranski
Pyramid Employee
1 yr ago
Q&A
Answered
Answered
0
chart list for development months
hi I have a chart which is showing months 1 to 60+, i was wondering if its possible to show 1 to 24 then from there going in multiples of 3? so 27 30 33 etc...?
Nicholas Campbell
Top Contributor
Nicholas_Campbell
1 yr ago
4
replies
29
Last reply
Nicholas Campbell
Top Contributor
1 yr ago
Q&A
Answered
Answered
0
Filtering discoveries with OR instead of AND
I have been asked for a report to show invoices where the delivery OR the invoice has been sent to a particular country. I have an IMDB model using a sql source,…
Sophie durrant
Top Contributor
Sophie_durrant
1 yr ago
1
reply
38
Last reply
imbar
Community Team
1 yr ago
Q&A
Answered
Answered
0
Tooltip not showing in scatter graph
Hi all, As per the above, when I add the assured name to show in the tooltip or label, it only shows as a *. Do you know why this might be? Thanks, Dan
Dan Sharman
Customer
Dan_Sharman
1 yr ago
6
replies
33
Last reply
imbar
Community Team
1 yr ago
Q&A
Answered
Answered
1
Grid Size and Scrolling
When building grids in Discover, it seems to be divided into two distinct areas for dimensions on the left side and measures on the right. When you have more dimensions than will fit in the left…
Sophie durrant
Top Contributor
Sophie_durrant
1 yr ago
4
replies
22
1
Last reply
Sophie durrant
Top Contributor
1 yr ago
Q&A
Answered
Answered
0
Select Current Year in a Discovery
Trying to create a discovery to show only sales in the current year but I can't find a way to do it! This discovery will be used as a publication, so I always want it to just show the current year,…
Sophie durrant
Top Contributor
Sophie_durrant
1 yr ago
6
replies
35
Last reply
Sophie durrant
Top Contributor
1 yr ago
Q&A
Answered
Answered
0
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,…
Sophie durrant
Top Contributor
Sophie_durrant
1 yr ago
1
reply
14
Last reply
Avi Perez
Admin
1 yr ago
Q&A
Answered
Answered
0
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),…
Dan Sharman
Customer
Dan_Sharman
1 yr ago
5
replies
35
Last reply
Dan Sharman
Customer
1 yr ago
Q&A
Answered
Answered
0
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…
Dan Sharman
Customer
Dan_Sharman
1 yr ago
2
replies
10
Last reply
Dan Sharman
Customer
1 yr ago
Q&A
Answered
Answered
0
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?
Norbert Schütze
Customer
Norbert_Schutze
1 yr ago
1
reply
32
Last reply
Avi Perez
Admin
1 yr ago
Q&A
Answered
Answered
0
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,…
Sophie durrant
Top Contributor
Sophie_durrant
1 yr ago
8
replies
42
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
2
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,…
Maaike van den Berg
Customer
Maaike_van_den_Berg
1 yr ago
4
replies
28
2
Last reply
Maaike van den Berg
Customer
1 yr ago
Q&A
Answered
Answered
0
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,…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
1 yr ago
1
reply
22
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
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,…
Lori Read
Customer
Lori_Read
1 yr ago
2
replies
38
Last reply
Sergio Galimberti
1 yr ago
Q&A
Answered
Answered
0
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?…
Sophie durrant
Top Contributor
Sophie_durrant
1 yr ago
9
replies
36
Last reply
Shai Ben Ami
Pyramid Employee
1 yr ago
Q&A
Answered
Answered
1
3
4
5
6
7
25
Next
Ask a new question
Got stuck with a report? Start a discussion or help others to move forward.
Key Resources
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help
Recent Tweets
Follow @PyramidAnalytic
Home
Q&A
Best Practices
Learning Live Archive
Pyramid Dashboard Gallery
Tech Blogs
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
SAP
Security
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
View all topics
Key Resources
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help