Mark Oldfield's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Can not find Sales Models in Training Models 2023
Hi @Yang Yaxuan We apologise for the issue you encountered while finding the 'Sales' model in the Training Models (2023) database on Explore. I have found the issue,…
- Global Architect
- Mark_Oldfield.1
- 11 days ago
- 2
- Questions & Answers
- Reported - view
Re: I want to prepare a present that has a list of all the other presents available to the user. How can I acehive this
hi @Nandita Gupta If you have the name of the presents and the id's within a data model you can make a column in the form of a Direct Load (URL) . You can then define that column categorised as an…
- Global Architect
- Mark_Oldfield.1
- 12 days ago
- Questions & Answers
- Reported - view
Re: Pyramid Explore Internal Server Error 500
Hi Following our investigation, the team has implemented a fix for the resource issues in the Explore environment. This action has resolved the cause of the recent 500 errors.
- Global Architect
- Mark_Oldfield.1
- 12 days ago
- 1
- Questions & Answers
- Reported - view
Re: Calculate the number of days from a date to the current date
Hi Rob, In addition to Obee's approach, you can implement this as a Custom Column within Formulate and perform this on a row-by-row basis. This uses Now() function to return the current date,…
- Global Architect
- Mark_Oldfield.1
- 13 days ago
- Questions & Answers
- Reported - view
Re: Pyramid Explore Internal Server Error 500
Hi @Connor Twomey we are currently investigating this issue. Thankyou for raising this
- Global Architect
- Mark_Oldfield.1
- 13 days ago
- Questions & Answers
- Reported - view
Re: Congratulations - Level 3 Certified: Shauna Duffy - Hopton Analytics
Congratulations @Shauna Duffy
- Global Architect
- Mark_Oldfield.1
- 3 wk ago
- 1
- Member Lounge
- Reported - view
Re: Subscriptions via SMS
Hi @Joanna McGurk Yes, you can enable SMS subscriptions by configuring our Twilio integration. Twilio is a cloud communications platform that allows you to send and receive text messages…
- Global Architect
- Mark_Oldfield.1
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Welcome to the Community - Introduce Yourself!
Hi @Wendy Cole Sorry to hear your issues with performing your training on Explore, I've looked into this, it seems like you may have been performing the training on a database that has been removed.…
- Global Architect
- Mark_Oldfield.1
- 4 wk ago
- 2
- Member Lounge
- Reported - view
Re: Embed - Full Functionality
Hi @Aaron Yohannan The embed print functionality is covered in full here (for 2025) To print individual report items from a Present, right-click the item directly on the dashboard.…
- Global Architect
- Mark_Oldfield.1
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Embed - Full Functionality
Hi @Aaron Yohannan The functionality supported by embedding Pyramid (via the Embed APIs) can be found in our help here With embedded content, you can download the discovery within a report using the…
- Global Architect
- Mark_Oldfield.1
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Parameter: 13 months on a rolling basis or the whole year.
Hi @Jona Löneke The approach you want to take is to employ the Switch function to switch between two lists, a parameter can then drive this Switch The example I will take you through can be found on…
- Global Architect
- Mark_Oldfield.1
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: How to use the 'Publication Print' click action to apply slicers from a presentation
Hi Alexander, As long as the slicers are mapped correctly from the click action from the present to the publication, the publication should be filtered correctly.…
- Global Architect
- Mark_Oldfield.1
- 2 mths ago
- Questions & Answers
- Reported - view
Re: How to manage security with migrations between environments?
Hi @Jeanre Van Wyk The API suite in Pyramid within Pyramid will definitely assist in managing migration activities. On the area of security, and the exporting and importing of content,…
- Global Architect
- Mark_Oldfield.1
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Welcome to the Community - Introduce Yourself!
Hi Pyramid Community, Just wanted to pop in and introduce myself! My name is Mark Oldfield, and I'm the Global Architect on the Customer Success team here at Pyramid Analytics.…
- Global Architect
- Mark_Oldfield.1
- 4 mths ago
- 7
- Member Lounge
- Reported - view
Re: Customizing specific background colors in a discovery - Version 2020.16.031
@Yolanda Heldsinger looking at the case ... you need to check for between 2 values for the cases for yellow, green , etc therefore the Yellow statement should look like [Measure] >=60 && [Measure ] <…
- Global Architect
- Mark_Oldfield.1
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Customizing specific background colors in a discovery - Version 2020.16.031
Hi@Yolanda Heldsinger , The syntax for Case may be different for 2020 I believe if you use the following syntax laid out in this link it should work CASE (PQL) Also could you share the errors you are…
- Global Architect
- Mark_Oldfield.1
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Customizing specific background colors in a discovery - Version 2020.16.031
Hi Yolanda Your scenario sounds like this would be best addressed by applying value driven colors using a formula to provide the logic. This approach is described here I have created an example of…
- Global Architect
- Mark_Oldfield.1
- 4 mths ago
- Questions & Answers
- Reported - view
Re: model development
@Tabitha DeCaprio To ensure the Total Amount and Financial Aid Amount appear on the same row, they must share a dimensional relationship. In your example, you're using Tuition Titles and Term_ID,…
- Global Architect
- Mark_Oldfield.1
- 4 mths ago
- Questions & Answers
- Reported - view
Re: model development
@Tabitha DeCaprio The absence of a 'Campus' attribute in the Aid table suggests that aid is being treated as a global total. Is this the intended behavior,…
- Global Architect
- Mark_Oldfield.1
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Cascade for date filter
Hi @Jeevitha I have placed a copy of my colleague's example on our Explore server, if you don't have an account you can sign up from the link below. Pyramid Explore Server - How to Sign up HOW TO:…
- Global Architect
- Mark_Oldfield.1
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
Re: model development
Hi @Tabitha DeCaprio could you put some screenshots to explain the example more for that scenario, i.e. the data flow and a discover showing the incorrect total by Campus many thanks Mark
- Global Architect
- Mark_Oldfield.1
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Highlighting the column and grid setup *help*
Hi @Ricky Melamed Let me start with the end result and then take you through how I got there. Hopefully this example will answer the questions you posed. I have put the example on our Explore server.…
- Global Architect
- Mark_Oldfield.1
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Highlighting the column and grid setup *help*
Hi @Ricky Melamed I hope to save your hair, In my discover example, I have a number of measures on my rows, and my categories are on the columns To color the columns based upon the product category,…
- Global Architect
- Mark_Oldfield.1
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Shareable rolling average formula
@Shir Ben-Gal I've made an example based upon my colleague Moshe's idea which you can find here on our 'Explore' server. The example is based upon our Training Models (2023) IMDB database and model.…
- Global Architect
- Mark_Oldfield.1
- 4 mths ago
- Questions & Answers
- Reported - view
Re: model development
@Tabitha DeCaprio It looks like the error you're seeing is because the 'TOTAL_AMT' column and the 'Total aid' column have different data types – one's text, and the other's a number.…
- Global Architect
- Mark_Oldfield.1
- 4 mths ago
- 1
- Questions & Answers
- Reported - view

1 2 3

Back to top

Home

View all topics