Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

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.…
- Senior Director of Product
- Ian_Macdonald
- 5 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.…
- Senior Director of Product
- Ian_Macdonald
- 5 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…
- Senior Director of Product
- Ian_Macdonald
- 5 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.…
- Senior Director of Product
- Ian_Macdonald
- 5 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.…
- Senior Director of Product
- Ian_Macdonald
- 5 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…
- Senior Director of Product
- Ian_Macdonald
- 5 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
- Senior Director of Product
- Ian_Macdonald
- 5 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,…
- Senior Director of Product
- Ian_Macdonald
- 5 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.…
- Senior Director of Product
- Ian_Macdonald
- 5 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...…
- Senior Director of Product
- Ian_Macdonald
- 5 mths 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,…
- Senior Director of Product
- Ian_Macdonald
- 5 mths 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.…
- Senior Director of Product
- Ian_Macdonald
- 5 mths 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
- Senior Director of Product
- Ian_Macdonald
- 5 mths ago
- 4
- Questions & Answers
- Reported - view
Re: Custom Date Time Format with Time Zone
Hi @Kyle Jordan , Where are you setting the format? Sorry, but from the small screen grab I can't tell the context in which you are working. Can you show the complete screen?…
- Senior Director of Product
- Ian_Macdonald
- 5 mths ago
- Questions & Answers
- Answer
- Reported - view
Re: Concerns about Python Access
@Dmitri Kanounnikov As it can be difficult to anticipate the resources consumed by the IMDB service, it is recommended practice for production systems to isolate the IMDB service on its own server so…
- Senior Director of Product
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Count of last three months regardless of year
@Immanuel Gem Oops! I just noticed from your last post i still got the algorithm wrong! Same approach, but different lag options! Ian
- Senior Director of Product
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Count of last three months regardless of year
Hi @Immanuel Gem OK. First off, if this is a model you have built, then it would be much, much easier if you created a dimension of year-month or alternatively easier if you have a year --> month…
- Senior Director of Product
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Count of last three months regardless of year
OK, that's clear now. Do you have a dimension of year-month? And what are you counting?
- Senior Director of Product
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Count of last three months regardless of year
@Immanuel Gem I'm still not entirely clear on your algorithm for selecting the months to count. Are you saying it is the three months prior to the year/month selected? Also,…
- Senior Director of Product
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Count of last three months regardless of year
Hi @Immanuel Gem Just to make sure the above is not a typo, you want the count of the three months counting backwards from the month selected of the year preceding that selected?…
- Senior Director of Product
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Forecasting Label
Hi @ArunKumar , In order to have the AI driven Forecast Labels available in the drop down, then the Pyramid AI integration must be enabled. Without it, the only Forecast Label Option available is the…
- Senior Director of Product
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Rolling average formula
@Mark Oldfield, @Katie Easton Works well, but it will become cumbersome when looking at wider rolling average ranges. It is also very static in terms of how the user to interact with it.…
- Senior Director of Product
- Ian_Macdonald
- 6 mths ago
- 3
- Questions & Answers
- Reported - view
Re: PPT related queries.
Hi @Vijayan Krishnan 1. This appears to be a PowerPoint screenshot. All PowerPoints have Notes sections for each slide, whether they are used or not. it may be you haven't noticed them before.…
- Senior Director of Product
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Create a Text Column
If you mean a grid as a set of columns, change the grid type from Matrix to Column.
- Senior Director of Product
- Ian_Macdonald
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Create a Text Column
Hi @RAJESH Gonuguntla , Any text column in the underlying data tables will show up as a dimension / hierarchy in your model provided it is identified as such (i.e.…
- Senior Director of Product
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view

1 3 4 5 6 7 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Plotting values on line chart without aggregating

Re: including google charts in Formulate ( custom visual )

Re: Plotting values on line chart without aggregating

Re: Last non empty function Modell Pro

Re: Publication | Report Triggers | Matrix vs Tabular Grid

Re: Wrapping legend values in a line chart

Re: Disabling "Panel Tools" for Individual Visualizations

Re: How to show URL icons in matrix grid?

Re: How to show URL icons in matrix grid?

Re: Filters-Two Different Models

Re: Static value list for a dimension

Re: Filters-Two Different Models

Re: Custom Date Time Format with Time Zone

Re: Custom Date Time Format with Time Zone

Re: Concerns about Python Access

Re: Count of last three months regardless of year

Re: Count of last three months regardless of year

Re: Count of last three months regardless of year

Re: Count of last three months regardless of year

Re: Count of last three months regardless of year

Re: Forecasting Label

Re: Rolling average formula

Re: PPT related queries.

Re: Create a Text Column

Re: Create a Text Column

Home