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
Ian Macdonald
Admin
Ian_Macdonald
VP Product Management
UK
Follow
Joined
Fri Oct 14 14:58:14 UTC 2016
1200
posts
425
likes received
16
followers
Badges
2934
36
7
Company
Pyramid Analytics
Country
United Kingdom
Latest Posts
Re: Last 'N' dates list Based on Date Filter
Hi Immanuel Gem , The simplest way to do this is as follows: Create a Parameter to include all the dates from which you want your user to select. Make it single select. Create a Dynamic List.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
1
Questions & Answers
Reported - view
Re: Last 'N' dates list Based on Date Filter
Hi @Immanuel Gem , To clarify, you want the user to select a date and then view that date plus the 89 days preceding it? Individually or as a total? Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
1
Questions & Answers
Reported - view
Re: Create Patterns Within Bar Graphs
Hi @Nicole Musho , Understood. Please add your enhancement request to the Product Ideas Forum. In the meantime, we have a section in our Help on creating accessible content you can find here.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
Questions & Answers
Reported - view
Re: Create Patterns Within Bar Graphs
Hi @Vijayan Krishnan , That is correct. Currently you can select a fill pattern and its colour, the outline colour and thickness, but not the fill pattern background.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
Questions & Answers
Reported - view
Re: Create Patterns Within Bar Graphs
Hi @Nicole Musho , Can you show us an example of what you are looking for? Thanks, Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
Questions & Answers
Reported - view
Re: Mapping with "Layers"
Hi @Barbara Tantum , Currently we do not support the combination of point and coloured area (choropleth) maps, hence what you want to achieve is not possible at the moment. Hope that helps. Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
Questions & Answers
Reported - view
Re: Tiled Layout Inside Fixed layout in same presentation
Hi @Immanuel Gem , Add a scrollable panel and resize it to fill the slide, or however big you want it: Hope that helps. Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
2
Questions & Answers
Reported - view
Re: Creating a Line Graph With Year as X-Axis and a String as Y-Axis
@Michael Daun It's a function of the query / semantic model driven by the data. I.e. There are rows in the underlying data table that contain both Company A and 2015,…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
1
Questions & Answers
Reported - view
Re: Creating a Line Graph With Year as X-Axis and a String as Y-Axis
@Michael Daun That is the grid. I have no measures in the grid at all. I'm using Company Name to define the background color. This will color the background where the company exists for any given…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
Questions & Answers
Reported - view
Re: Creating a Line Graph With Year as X-Axis and a String as Y-Axis
Hi @Cindy Tran , @Michael Daun One has to ask what is the objective of the visualisation? I would assume you want to easily see and compare the companies' active life.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
2
Questions & Answers
Reported - view
Re: Creating a Line Graph With Year as X-Axis and a String as Y-Axis
Hi @Cindy Tran , Do you have some sample data we can work with to try and achieve this? Thanks, Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
Questions & Answers
Reported - view
Re: Sub Totals only if there is more then 1 element
Hi @Germann Apaev , Unfortunately, this option is not available aa part of the subtotalling engine, but it should be, so please raise a feature request in the Product Ideas Forum.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
1
Questions & Answers
Reported - view
Re: Plotting values on line chart without aggregating
@Puneet Mehta Perhaps I didn't make myself clear. currently you cannot edit the two series' labels separately, hence the suggestion to open a feature request on the Product Ideas Forum.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
Questions & Answers
Reported - view
Re: including google charts in Formulate ( custom visual )
Hi @Ajay SampathKumar , To get started, watch the video on building custom visuals from our Help page, then work your way through the example given. https://help.pyramidanalytics.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
1
Questions & Answers
Reported - view
Re: Plotting values on line chart without aggregating
Hi @Puneet Mehta , Currently there is no way to individually format the axis labels when two or more attributes are used, for example by formatting the dates with a white font to hide it or not…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
1
Questions & Answers
Reported - view
Re: Last non empty function Modell Pro
Hi @Wilhelm Jost , Currently we do not provide a "last non-empty" aggregation method, just "last child". It has been researched, but we've yet to find a performant solution that will give this result.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
1
Questions & Answers
Reported - view
Re: Publication | Report Triggers | Matrix vs Tabular Grid
Hi @Natalie-Anne Botha , The rather crass answer is that it isn't supported. A slightly more considered answer is that a tabular grid isn't really a grid.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
Questions & Answers
Reported - view
Re: Wrapping legend values in a line chart
Hi @Puneet Mehta , There isn't an option currently to wrap the text on legends. If you're placing the chart on a dashboard, you can access the legend object separately from the chart and resize and…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
1
Questions & Answers
Reported - view
Re: Disabling "Panel Tools" for Individual Visualizations
Hi @TKH TKH , Just turn off the panel for that object in the object panel formatting settings: Uncheck this box: Gives you: No panel on selected object. Hope that helps! Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
Questions & Answers
Reported - view
Re: How to show URL icons in matrix grid?
Hi again @Natalie-Anne Botha , If your data is very static, i.e. you only ever have 3 cities and 3 questions in those respective dimensions, i.e. you always have a 3x3 grid of URLs,…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
1
Questions & Answers
Reported - view
Re: How to show URL icons in matrix grid?
Hi @Natalie-Anne Botha , Pyramid does not currently support images in the data cells of Grids. However, we can post process the grid that contains URLs in Present using Dynamic Text.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
11 mths ago
3
Questions & Answers
Reported - view
Re: Filters-Two Different Models
Hi @Immanuel Gem I can see why you might want the geolocation perform like that as it forms a natural hierarchy, but Race, Ethnicity, Language, Gender, Military Ve...…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 yr ago
1
Questions & Answers
Reported - view
Re: Static value list for a dimension
Hi @Puneet Mehta , It comes down to how you have built your data model. If you are deriving your month and year dimension from your data and there are no records for months June - December in 2024,…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 yr ago
Questions & Answers
Reported - view
Re: Filters-Two Different Models
hi @Immanuel Gem , Let me restate your challenge to make sure I have understood it correctly. 1st Question You have a dashboard with analytic content from two models.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 yr ago
Questions & Answers
Reported - view
Re: Custom Date Time Format with Time Zone
Hi @Kyle Jordan Use the backslash character "\" to escape the M thus: yyyy-MM-dd hh:mm G\MT Z Gives you: Hope that helps! Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 yr ago
4
Questions & Answers
Reported - view
1
6
7
8
9
10
25
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs & Webinars
Pyramid Dashboard Gallery
Product
Product Announcements
Product Highlights
Product Ideas
Current Product Ideas
Archived 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