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
Selected Materials from Learning Live
Learning Live Topic Suggestions
Pyramid Innovators
Tips & Tricks
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowleg Base
General
Performance
Databases
Security
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
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
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
28
Last reply
Shai Ben Ami
Pyramid Employee
1 yr ago
Q&A
Answered
Answered
1
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.…
Robert Clark
Top Contributor
Robert_Clark
1 yr ago
1
reply
14
1
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
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
Olaf
Olaf
1 yr ago
1
reply
29
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
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).…
Dan Sharman
Top Contributor
Dan_Sharman
1 yr ago
4
replies
27
Last reply
David Wiltcher
1 yr ago
Q&A
Answered
Answered
0
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?
Ilan Perez
Admin
Ilan_Perez
updated
1 yr ago
1
reply
16
Last reply
imbar
Community Team
1 yr ago
Q&A
Answered
Answered
0
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,…
Sophie durrant
Top Contributor
Sophie_durrant
1 yr ago
1
reply
17
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
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…
Dan Sharman
Top Contributor
Dan_Sharman
1 yr ago
9
replies
33
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
1
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.…
Ove Sandau
Top Contributor
Ove_Sandau
1 yr ago
3
replies
52
1
Last reply
Ove Sandau
Top Contributor
1 yr ago
Q&A
Answered
Answered
0
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!…
Sophie durrant
Top Contributor
Sophie_durrant
1 yr ago
3
replies
21
Last reply
Laura Kehoe
1 yr ago
Q&A
Answered
Answered
0
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…
Sophie durrant
Top Contributor
Sophie_durrant
1 yr ago
3
replies
17
Last reply
Sophie durrant
Top Contributor
1 yr ago
Q&A
Answered
Answered
0
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.…
Kate Strydom
Kate_Strydom
updated
1 yr ago
3
replies
17
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
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":…
Niko Z
Certification In Progress
Niko_Z
1 yr ago
2
replies
23
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
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,…
Kimaal Baker
Kimaal_Baker
1 yr ago
1
reply
12
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
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.…
sonia clement
User Certified Level 1
sonia_clement
updated
1 yr ago
2
replies
22
Last reply
Patrick Ebert
Pyramid Employee
1 yr ago
Q&A
Answered
Answered
0
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.…
elizabeth liam
elizabeth_liam
1 yr ago
2
replies
10
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
1
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…
Dolf Jordaan
Dolf_Jordaan
1 yr ago
1
reply
28
1
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
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.…
Kate Strydom
Kate_Strydom
1 yr ago
3
replies
12
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
Europe Design Theme
Hi, Where can I get the Europe Design Theme .i.e. download it. I seem to have written over it by accident. All part of learning. Regards Kate
Kate Strydom
Kate_Strydom
1 yr ago
2
replies
10
Last reply
Kate Strydom
1 yr ago
Q&A
Answered
Answered
0
Tooltip Name include
When hovering over data in a Discover, the specified tooltip data is shown in the window but it can be difficult to link the data to the title of the tooltip if similar data is shown in the tooltip.…
Paul Robinson
Paul_Robinson
1 yr ago
4
replies
10
Last reply
Paul Robinson
1 yr ago
Q&A
Answered
Answered
1
Stacked and non stacked chart together
Hi I have four measures, one being premium, and then an set of data of claims split by type, I want to see the premium as one colour in its own bar, and then the 3 claim types stacked together…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
1 yr ago
1
reply
28
1
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
Measures/Dimensions caption translation
Hi all, I have this issue: I work for an italian company and all our database objects captions are in italian. I would like to translate the labels in english since we now have an USA company branch.…
Sergio Galimberti
Sergio_Galimberti
1 yr ago
8
replies
28
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
1
Display weather on map with data points
Hello, We are trying to identify if there is a way to map customers address on a weather map to identify who would be affected by a storm. Do you have some ideas on how this might be accomplished.…
Robert Clark
Top Contributor
Robert_Clark
1 yr ago
1
reply
24
1
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
Text to Dynamic Caption
Hi Hopefully an easy one, im looking to add the word "and Prior" to the following dynamic caption text ToString(DateFormat(AddYears(Date(),-2), "YYYY") ) I did think it would be…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
1 yr ago
2
replies
19
Last reply
Nicholas Campbell
Top Contributor
1 yr ago
Q&A
Answered
Answered
2
Listing all the dimensions of a hierarchy in a Discovery
I receive multiple requests from users to display multiple levels of a hierarchy in a Discovery. For example rather than just a profit centre name displayed,…
Anthony Fine
Anthony_Fine
1 yr ago
4
replies
25
2
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
0
Values appearing as -0 for one user, when they should be %
I'm stumped by this display issue one of our users has, and I hope someone can point me in the right direction for how it can be solved. In every discover (or in present where a discovery is being…
Jessica Weaver
Jessica_Weaver
1 yr ago
2
replies
19
Last reply
Ian Macdonald
Admin
1 yr ago
Q&A
Answered
Answered
1
2
3
4
5
23
Next
Ask a new question
Got stuck with a report? Start a discussion or help others to move forward.
Key Resources
Pyramid Community User Survey
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
Selected Materials from Learning Live
Learning Live Topic Suggestions
Pyramid Innovators
Tips & Tricks
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowleg Base
General
Performance
Databases
Security
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
View all topics
Key Resources
Pyramid Community User Survey
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help