Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Fixed Static Parameter
Hi @Len Stockdale , Can you explain a little more clearly the Measures, Dimensions involved? What are you Distinct Counting? What is being used for the Range 1 to 1000?…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Formatting For Multi-Select Drop Down
Hi @Cindy Tran , You appear to be correct. Please submit an enhancement request though the Product Ideas Forum. Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: How can I get the count of days for every month using Formulate (Custom column)?
Hi @Raja Sambasivam , This is a function of deriving your Date dimension from your fact table. As soon as you filter the fact table, the dates will be filtered as well,…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
Re: How can I get the count of days for every month using Formulate (Custom column)?
@Raja Sambasivam If you want to use a custom column to drive the measure, simply select the date attribute and create a Measure against it using Distinct Count as the aggregation method and hide the…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: How can I get the count of days for every month using Formulate (Custom column)?
Hi @Raja Sambasivam , This very easy. I am assuming you have Date, Full Month, Year type attributes in your model. Create a new Formulate formula against your model.…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Display Text Value Instead of Numeric Value
@Tamizhanban K Great. I've also reshaped your data so that for my example when I create a Discovery query with Field, Subfield and Count I get The calculation is essentially the same as previously…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Display Text Value Instead of Numeric Value
Hi @Tamizhanban K The simple answer is, no. As explained above, you are fighting the core semantic model approach of Pyramid. While we can bend it so far, we can't break it.…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Difference in Filters
Hi @Daniel Van Wyk , The filter on the Table block is pushed down into the initial SQL query that retrieves data from the database, whereas the Filter block filters data as it is moving through the…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Display Text Value Instead of Numeric Value
Hi @Tamizhanban K , Pyramid operates on what are known as dimensional models. As such, it takes each field n the data table, extracts the list of unique values from it as a dimension,…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Dynamic caption for lag member
@Avi Perez Oh yeah. As @Moshe Yossef said, watch out for tve differences between PQL and MDX :-)
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- Questions & Answers
- Reported - view
Re: AVG OF WEEKDAY AND WEEKENDS
Hi @Immanuel Gem Making the assumption that you have a dimension of weekday name and one that contains your dates and that you want the average of each weekday in a month or a year derived from the…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
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…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- 1
- 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?…
- Senior Director of Product
- Ian_Macdonald
- 4 mths ago
- 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.…
- Senior Director of Product
- Ian_Macdonald
- 4 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
- Senior Director of Product
- Ian_Macdonald
- 4 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.…
- Senior Director of Product
- Ian_Macdonald
- 4 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.…
- Senior Director of Product
- Ian_Macdonald
- 4 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
- Senior Director of Product
- Ian_Macdonald
- 4 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
- Senior Director of Product
- Ian_Macdonald
- 4 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
- Senior Director of Product
- Ian_Macdonald
- 4 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,…
- Senior Director of Product
- Ian_Macdonald
- 5 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…
- Senior Director of Product
- Ian_Macdonald
- 5 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.…
- Senior Director of Product
- Ian_Macdonald
- 5 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
- Senior Director of Product
- Ian_Macdonald
- 5 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.…
- Senior Director of Product
- Ian_Macdonald
- 5 mths ago
- 1
- Questions & Answers
- Reported - view

1 2 3 4 5 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Fixed Static Parameter

Re: Formatting For Multi-Select Drop Down

Re: How can I get the count of days for every month using Formulate (Custom column)?

Re: How can I get the count of days for every month using Formulate (Custom column)?

Re: How can I get the count of days for every month using Formulate (Custom column)?

Re: Display Text Value Instead of Numeric Value

Re: Display Text Value Instead of Numeric Value

Re: Difference in Filters

Re: Display Text Value Instead of Numeric Value

Re: Dynamic caption for lag member

Re: AVG OF WEEKDAY AND WEEKENDS

Re: Dynamic caption for lag member

Re: AVG OF WEEKDAY AND WEEKENDS

Re: Last 'N' dates list Based on Date Filter

Re: Last 'N' dates list Based on Date Filter

Re: Create Patterns Within Bar Graphs

Re: Create Patterns Within Bar Graphs

Re: Create Patterns Within Bar Graphs

Re: Mapping with "Layers"

Re: Tiled Layout Inside Fixed layout in same presentation

Re: Creating a Line Graph With Year as X-Axis and a String as Y-Axis

Re: Creating a Line Graph With Year as X-Axis and a String as Y-Axis

Re: Creating a Line Graph With Year as X-Axis and a String as Y-Axis

Re: Creating a Line Graph With Year as X-Axis and a String as Y-Axis

Re: Sub Totals only if there is more then 1 element

Home