Skip to main content
User Community
Pyramid
Help
Learning Hub
Support
How to enable Javascript
Sign Up
Login
Welcome to the Pyramid User Community
Pyramid User Community
Questions & Answers
Explore Pyramid
Product
Events & News
Member Lounge
Latest Activity
Home
Profile
Mark Oldfield
Pyramid Employee Level 3 Certified
Mark_Oldfield.1
Global Architect
United Kingdom
www.linkedin.com/in/mark-oldfield-15bb1563
Follow
Joined
10 Jun 2019
76
posts
81
likes received
14
followers
Badges
1445
7
5
2
1
Company
Pyramid Analytics
Country
United Kingdom
Latest Posts
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.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
2 wk ago
6
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 ] <…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
1 mth 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…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
1 mth 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…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
1 mth 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,…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
1 mth 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,…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
1 mth 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:…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
1 mth 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
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
1 mth 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.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
1 mth 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,…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
1 mth 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.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
1 mth 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.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
1 mth ago
1
Questions & Answers
Reported - view
Re: model development
Hi @Tabitha DeCaprio To better understand your needs, could you please elaborate on your requirements? Specifically, when appending two tables, the columns must align for the data to merge correctly.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
1 mth ago
Questions & Answers
Reported - view
Re: 2 elements in 1 minitab
@Ricky Melamed I have placed an example of the approach described by Moshe here on our Explore server environment. within the dashboard you will find 2 mini tabs,…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
2 mths ago
2
Questions & Answers
Reported - view
Re: How to use the 'Execute JavaScript Action' Click Action to Modify a Filter
@Alexander Khater Ian's great example can be found here on our Explore server.
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
3 mths ago
1
Questions & Answers
Reported - view
Re: `itemId` Parameter for `dataSources/addRolesToItemAndBubbleUp` API
Hi Raveena, The APIs are well documented with both the input and output parameters being defined in our online help For your example, you can find the parameter definition here https://help.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
4 mths ago
Questions & Answers
Reported - view
Re: Maps in Pyramid
Hi James You can find the custom geospatial shapes that you may require here. https://data.humdata.org/dataset/cod-ab-ken? thanks Mark
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
6 mths ago
1
Questions & Answers
Reported - view
Re: Dashboard Gallery: Bourbon Selection
@Michael Daun Please login into the Explore server, this content should now be available to you—many thanks for bringing this to our attention.
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
6 mths ago
Pyramid Dashboard Gallery
Reported - view
Re: including google charts in Formulate ( custom visual )
Hi @Ajay SampathKumar In addition to the above resources, there is an article on Custom visuals in our community forum here. https://community.pyramidanalytics.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
9 mths ago
1
Questions & Answers
Reported - view
Re: How to show URL icons in matrix grid?
What a great approach, I've placed a copy of this ingenious approach of using Dynamic text here on our Explore server environment so you can see this example first-hand.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
9 mths ago
Questions & Answers
Reported - view
Re: How to show URL icons in matrix grid?
Hi @Aaron Yohannan in your data model definition (within model pro), you need to define the category of the attribute you wish to be shown as an image as 'Image URL', note:…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
9 mths ago
Questions & Answers
Reported - view
Re: Data Model - summarize column, unique row
Hi @Tabitha DeCaprio I would see this more as a logical data model challenge initially, looking at your data I think it's represents the below:- the left-hand side represents what you currently have,…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
9 mths ago
Questions & Answers
Reported - view
Re: Rolling average formula
Hi @Katie Easton The example above is using MDX (as Im assuming it is connecting to an MS tabular/olap model with the use of the IIF) , instead of trying to see where Lag(1) = 'NULL' you can use the…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
10 mths ago
3
Questions & Answers
Reported - view
Re: Forecasting Label
@Tamizhanban K the currently supported options are a label that is customizable with a counter ... i.e. forecast 1 , 2 ,3 or the AI captions which match the rest of the entries logically.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
10 mths ago
2
Questions & Answers
Reported - view
Re: Forecasting Label
Hi @Tamizhanban K My colleague @Angelie Janssen made a great post on this very topic here https://community.pyramidanalytics.com/t/x2y32qb/how-to-use-ai-driven-forecasting-captions you can also find…
Mark Oldfield
Pyramid Employee Level 3 Certified
Global Architect
Mark_Oldfield.1
10 mths ago
Questions & Answers
Reported - view
1
2
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs & Webinars
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
Embedding Pyramid
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
Publish
SAP
Security
Events & News
Upcoming Events & Webinars
Getting Started
Community News
Customer Success Activities
What's New
Member Lounge
View all topics