Skip to main content
User Community
Pyramid
Help
Learn
Support
Generative BI
How to enable Javascript
Sign Up
Login
Welcome to the community!
User Community
Search for answers here or
ask a question
Questions & Answers
Explore Pyramid
Product
Events & News
Latest Activity
Home
Profile
Ian Macdonald
Admin
Ian_Macdonald
Senior Director of Product
UK
Follow
Joined
Fri Oct 14 14:58:14 UTC 2016
930
posts
301
likes received
9
followers
Badges
11
2
Company
Pyramid Analytics
Country
United Kingdom
Latest Posts
Re: Dynamic caption for lag member
Hi @Katie Easton ,@Moshe Yossef In fact, this is an Analysis Services source and it is MDX. You can tell from the PQL editor window header. Pyramid Models show with a Pyramid Logo and "PQL" below the…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
3 hrs ago
Questions & Answers
Reported - view
Re: AVG OF WEEKDAY AND WEEKENDS
Hi @Immanuel Gem , You need to provide a bit more information for us to help you. Weekday column contains the weekday name dimension Mon - Sun, or something else? Count of what? Average across what?…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
yesterday
Questions & Answers
Reported - view
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
Senior Director of Product
Ian_Macdonald
yesterday
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
Senior Director of Product
Ian_Macdonald
yesterday
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
Senior Director of Product
Ian_Macdonald
2 days 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
Senior Director of Product
Ian_Macdonald
2 days 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
Senior Director of Product
Ian_Macdonald
2 days 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
Senior Director of Product
Ian_Macdonald
3 days 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
Senior Director of Product
Ian_Macdonald
3 days 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
Senior Director of Product
Ian_Macdonald
10 days 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
Senior Director of Product
Ian_Macdonald
10 days 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
Senior Director of Product
Ian_Macdonald
11 days 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
Senior Director of Product
Ian_Macdonald
2 wk 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
Senior Director of Product
Ian_Macdonald
2 wk 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
Senior Director of Product
Ian_Macdonald
2 wk 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
Senior Director of Product
Ian_Macdonald
2 wk 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
Senior Director of Product
Ian_Macdonald
2 wk 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
Senior Director of Product
Ian_Macdonald
3 wk 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
Senior Director of Product
Ian_Macdonald
3 wk 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
Senior Director of Product
Ian_Macdonald
3 wk 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
Senior Director of Product
Ian_Macdonald
3 wk 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
Senior Director of Product
Ian_Macdonald
3 wk 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
Senior Director of Product
Ian_Macdonald
3 wk 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
Senior Director of Product
Ian_Macdonald
3 wk 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
Senior Director of Product
Ian_Macdonald
4 wk ago
Questions & Answers
Reported - view
1
2
3
4
5
18
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs
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