Latest Activity

Like for Like reporting

Hi, I'm trying to do some like for like reporting - i.e. if one of our locations wasn't open more 365 days ago, we need to exclude the location from our report.…

Suggestions for Tabulate Excel Export Formatting and Multiselect Slicer Settings

Hi Community! I have attached a step by step procedure to almost have an excel export with formatting using Themes. But having issues (i.e) while saved and run,…

'Average' line that has no data points

Hello, When I add an 'Average' line it has data points for each full month name. I want it to have no data points despite the other data on the line graph having data points.…

• Answered

Interaction between slides

I'd like to have data interactions between slides. Currently I can only perform data interaction on the elements within 1 slide. Is that possible?

• Answered

Open Linked Dashboards in a New Slide Instead of a New Tab

Hi Team, I've built several dashboards in Pyramid and created a summary chart that lists all the dashboard names along with their respective links. This summary chart is part of a final master…

• Answered

Learning materials for level 2 professional certification

Hello, I am looking to complete my level 2 professional certification. I wanted to ask if the learning materials for the level 1 also apply to the level 2 assessment. Thanks! Connor

• Answered

Can we make a video as landing and it should auto play

I wanted to make a video as landing page, it should auto play once and should move to next page

• Answered

Custom Filter

Hi Team, I’m trying to build a date filter in Pyramid that includes the following options: Current Week Last Week Last Month Last Year Custom Range (with the ability to select a specific date range)…

• Answered

I have calculated field as 'Average Time Spent.' Now I want to use that field as a filter in Discover or as a filter in other formulas.

I have calculated field as 'Average Time Spent.' Now I want to use that field as a filter in Discover or as a filter in other formulas. is this possible without writing anything in data model

• Answered

Can not find Sales Models in Training Models 2023

There only exist Returns and Training-Store Date -PK Models in Training Models(2023), So I can not open the Discover I made in the past which used Sales Models. So does the course need to be updated?

• Answered

I want to prepare a present that has a list of all the other presents available to the user. How can I acehive this

• Answered

Dashboard Interactions

Dear community, Is there a way to filter multiple elements one after the other by clicking on them in the presentation mode of a dashboard? Here is an example:…

• Answered

Target Interaction - Background Filters

I'm trying to use a target to filter a table of transaction data based on the selection in a visual on a different page of the presentation. This doesn't seem to work when the visual has background…

• Answered

Pyramid Explore Internal Server Error 500

Hello, I hope I'm not asking a repeat question but I have been having this issue for the last few days when trying to complete the walkthroughs on Pyramid Explore.…

• Answered

Calculate the number of days from a date to the current date

Hello, How do you calculate the number of days from a given date in the model to the current date. We tried the following but cannot get it to work. We consistently get an empty set. Thanks, Rob Clark

• Answered

How to call or execute(take as data-source) an SQL stored procedure in pyramid analytics

hi all, I was trying to call an SQL stored procedure from custom query into pyramid analytics in below way. exec dbo.[Get_SalesdetailsPyramid] The statement is valid,…

• Answered

Filter a second dimension based on the value of a first dimension in Discover

Contents Hi Community, Please bare with me whilst I try to explain what I am trying to achieve. This is a very slimmed down example, but suffice to say,…

• Answered

Finding Numbers for Yesterday

Hi Everyone, Our daily numbers (sales, manufacturing etc.) works behind by a day. When we say daily, we mean what we did yesterday. How can I achieve that in a formula?…

• Answered

Indicator to ONLY the total/subtotal

I am aware of the option to remove/include the indicator from Totals.... Is there a way to include it ONLY for totals/subtotals?

• Answered

Last month of Quarter - Date Lists & Formulates

I need to create a rollforward which is a Quarterly rollforward (see SNIP below of rough draft). This will past 5 quarters of data. I will be creating formulas for each of the listed items (Beginning…