Skip to main content
User Community
Pyramid
Help
Learn
Support
Generative BI
How to enable Javascript
Sign Up
Login
Welcome to the Pyramid User Community
Pyramid User Community
Search for answers here or
ask a question
Questions & Answers
Explore Pyramid
Product
Events & News
Latest Activity
Home
Profile
Mark Oldfield
Pyramid Employee Level 3 Certified
Mark_Oldfield.1
Principal Customer Solutions Consultant
United Kingdom
www.linkedin.com/in/mark-oldfield-15bb1563
Follow
Joined
10 Jun 2019
58
posts
55
likes received
14
followers
Badges
5
3
1
1
Company
Pyramid Analytics
Country
United Kingdom
Latest Posts
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
Principal Customer Solutions Consultant
Mark_Oldfield.1
10 days 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
Principal Customer Solutions Consultant
Mark_Oldfield.1
1 mth 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
Principal Customer Solutions Consultant
Mark_Oldfield.1
2 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
Principal Customer Solutions Consultant
Mark_Oldfield.1
4 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
Principal Customer Solutions Consultant
Mark_Oldfield.1
5 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
Principal Customer Solutions Consultant
Mark_Oldfield.1
5 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
Principal Customer Solutions Consultant
Mark_Oldfield.1
5 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
Principal Customer Solutions Consultant
Mark_Oldfield.1
5 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
Principal Customer Solutions Consultant
Mark_Oldfield.1
5 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
Principal Customer Solutions Consultant
Mark_Oldfield.1
6 mths ago
Questions & Answers
Reported - view
Re: How to apply borders, based on grouped columns
@Vijayan Krishnan without knowing the exact use case above, Im assuming that when you apply a grid line (or other formatting) to a parent member it affects its children.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
6 mths ago
Questions & Answers
Reported - view
Re: How to apply borders, based on grouped columns
Hi @Vijayan Krishnan To add to this for your specific example the best way to approach this is to remove the existing grid by selecting 'None' then select the 'Expense' column and select the 'Left'…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
6 mths ago
1
Questions & Answers
Reported - view
Re: What is the maximum size for a text variable?
Hi @Daniel Van Wyk The 2 approaches you could use are either putting a Python script into your flow (with the option to create a new table if applicable),…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
6 mths ago
Questions & Answers
Reported - view
Re: What is the maximum size for a text variable?
Hi @Daniel Van Wyk Have you tried to use the JSON file source as a source within a data flow instead, this is more aimed at receiving a JSON data payload, where a web application API is one use-case,…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
6 mths ago
2
Questions & Answers
Reported - view
Re: Filter Selected Date
Hi Immanuel, The scenario would require a model parameter (based on the date attribute you wish to filter) and then this parameter could be used to generate a list of dates as a range,…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
6 mths ago
1
Questions & Answers
Reported - view
Re: Report URL Options
Hi @Vaughan van der Merwe Unfortunately, I can't think of an alternate approach as the approach implemented is the method that Chrome (and other browsers ) use to open URL links in a new window.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
7 mths ago
Questions & Answers
Reported - view
Re: Has anyone used Pyramid with Dynamics (D365 - FinOps and CE) ?
Hi @Richard Varley I would look at CData's connectors to get the ability to extract the data from MS Dynamics https://www.cdata.com/drivers/dynamics365/jdbc/ This can then be added as a custom…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
8 mths ago
Questions & Answers
Reported - view
Re: Report URL Options
As an alternative to having the URL link as fields with a URL type, would it be possible to perform the same using an Action using 'Jump to URL' in a discovery?…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
8 mths ago
Questions & Answers
Reported - view
Re: Exploration empty in a publication
Hi @Aurelie , the page trigger is for all the items on a page. The input of the trigger is a discovery and the metrics created by a KPI can be placed into this discovery further details on the…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
8 mths ago
Questions & Answers
Reported - view
Re: Exploration empty in a publication
Hi Aurelie, You could implement a page trigger to control when a page is produced within your publication. For your use case you could check to see if a discovery contains data,…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
8 mths ago
Questions & Answers
Reported - view
Re: Connecting to Tidal software to get the job data and display batch status in Pyramid.
Hi Prakash, I'm assuming it is the Tidal software that Christian has linked to in his reply. Tidal Software look to provide a rich API interface to its product,…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
9 mths ago
1
Questions & Answers
Official response
Reported - view
Re: How to Create a Slider Filters
Hi @Vijayan Krishnan The 'Between' filter example I provided creates 2 global parameters for the 'From' and 'To', with the initial example showing 2 text boxes, alternatively,…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
10 mths ago
1
Questions & Answers
Reported - view
Re: How to Create a Slider Filters
Hi@Vijayan Krishnan , To achieve the functionality of filtering a range based on the available measures within a Discover you can use the Quick Filter functionality.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
10 mths ago
Questions & Answers
Reported - view
Re: Waterfall Chart to show the actual growth split by category
@Christian Langmayr @Natalie-Anne Botha this approach fits the use case perfectly. The IBCS Waterfall chart uses 2 value fields for the waterfall, a 'from' and a 'to'.…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
10 mths ago
1
Questions & Answers
Official response
Reported - view
Re: Question on How to use Measure Lists and Parameters
Hi Natalie, A Measure parameter does not support multi-select as a parameter in this scenario represents a single measure. A Measure List can hold multiple measures and the approach you could take is…
Mark Oldfield
Pyramid Employee Level 3 Certified
Principal Customer Solutions Consultant
Mark_Oldfield.1
10 mths ago
1
Questions & Answers
Official response
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
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
View all topics