Mark Oldfield's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

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.…
- 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 ] <…
- 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…
- 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…
- 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,…
- 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,…
- 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:…
- 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
- 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.…
- 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,…
- 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.…
- 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.…
- 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.…
- 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,…
- 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.
- 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.…
- 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
- 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.
- 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.…
- 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.…
- 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:…
- 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,…
- 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…
- 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.…
- 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…
- Global Architect
- Mark_Oldfield.1
- 10 mths ago
- Questions & Answers
- Reported - view

1 2

Back to top

Home

View all topics