-
Creating a Line Graph With Year as X-Axis and a String as Y-Axis
I want to create a line graph in discover that shows all of the years as the x-axis and the company name as the y-axis. So like a line graph that shows that a company existed from 2009-2024 and…
- Answered
-
including google charts in Formulate ( custom visual )
how can i use google charts in formulate-custom visuals , I have a code for for a chart - (have attached the code below) , how can I integrate it in FORMULATE_ CUSTOM VSUAL ,…
- Answered
-
Sub Totals only if there is more then 1 element
Hello! Is it possible to show the sub totals only if there are more then 1 element to calculate? Here is an example. If there is only 1 element i'd prefer not to see the Subtotal.…
- Answered
-
Last non empty function Modell Pro
Hello Pyramid Community, is it possible to select the function 'last non empty' for Measures in the modell pro designer? I want to show the last filled amount for the month.…
- Answered
-
Plotting values on line chart without aggregating
Hello Pyramid Community! I have plotted a line chart on monthly data as shown in attached screenshot. I want to remove dates from axis, instead have only year on x-axis (the way I have at the bottom…
- Answered
-
Wrapping legend values in a line chart
Hello Pyramid Community! I have a very simple query on legend text. I am creating a line chart and the dimension I am using has long text values. Is there a way we can wrap legend text(each value…
- Answered
-
How to hide Hierarchy/Measures for specific Role Types (CLS)
This use case is around column level security and hiding certain columns based off of user role. I am trying to hide certain dimensions and measures depending on the role of the user that is looking…
- Answered
-
Disabling "Panel Tools" for Individual Visualizations
Hello, PA team! I would like to be able to hide the "Panel Tools" for only one or more visualizations on a presentation slide, for example, have "Panel Tools" for one visualization and none for…
- Answered
-
Making Custom Bins With Measures For Discover
So I have a measure that I want to use to make bins. Discover is able to have me create bins by rank, value, category, size, parameter, etc. Still, is there a way for me to create bins by custom…
- Answered
-
Static value list for a dimension
Hello Community, I am building a report for a client. I need to create a matrix grid with monthly return values(Jan to Dec) for each year starting 2017.…
- Answered
-
Filters-Two Different Models
I have two dashboards from two different models where the sources for the dashboards are also different but both of the dashboards uses same filters . I want to use the filter in only one dashboard…
- Answered
-
Help regarding pyramid learning materials.
Hi, I'm a beginner with the Pyramid Analytics tool and I want to learn from scratch. Could you guide me on where to find materials or provide any guidance on how to start learning Pyramid?…
- Answered
-
Custom Date Time Format with Time Zone
Is there a way to avoid interpretation of text in the custom date/time format? I am following the Pyramid help reference for DateFormat, where it explains that the masking is based on Java…
- Answered
-
Publication | Report Triggers | Matrix vs Tabular Grid
We are needing to use Report Triggers on a publication that has Tabular Grids. Is there a reason that a Report Trigger will work with a Matrix grid and not a Tabular grid? Matrix Grid: Tabular Grid:…
- Answered
-
How to show URL icons in matrix grid?
Hello, I have a requirement to show URL icons in matrix grid. I am able to show URL's under question as URL after doing MAX of the URL value but i need to show it as URL icons.…
- Answered
-
External IMDB Service Setup
We have been advised to set up the IMDB (in-memory database) service on a separate server for our multi-tenancy architecture. We're looking for detailed documentation or resources that describe how…
- Answered
-
Data Model - summarize column, unique row
Hello, I am running into a problem when developing my data model. I have two rows of data: ID AMT CREDITS COUNT_REG UID1 24775 18.00 1.00 UID1 -1286 18.00 1.…
- Answered
-
Model app missing from Explore Pyramid
Hello, I'm trying to work through the Data Modeler certification modules using explore.pyramidanalytics.com however the Model app isn't showing (see image). How do I get it added? Much Thanks, Sarah.
- Answered
-
Geocode Missing error
Hi, I got results on state wise data on discovery. But In presentation I getting geocode missing error in state region on united states country. how to resolve geocode location issue?
- Answered
-
Count of last three months regardless of year
I have two filters year and month for few years where I want to find the count of members for the last three months . For say if am selecting year 2023 in the filter and the month December in the…
- Answered
-
Illustrator
I have a gender pie chart with values male female and unknown where I want to insert icons instead of data labels for male female and other which I want that to be dynamic if the value changes for…
- Answered
-
SAP blocks usage of ODP (Note 3255746)
Can someone at Pyramid confirm the impact of this significant change made by SAP on our continued integration on SAP BW and SAP HANA? Most of our company uses Pyramid for direct analytics on SAP.…
- Answered
-
Concerns about Python Access
Hello, On our Pyramid installation, we're looking to host multiple tenants. However, we've encountered an issue where we can access the host's file system through Pyramid,…
- Answered
-
Date comparison with DateDiff
Currently the date comparison of two dates can only be done with one format “yyyy-MM-dd HH:mm:ss”, but to work with another one the DateDiff function does not work correctly.…
- Answered
-
Rolling average formula
I'm currently trying to create a formula to calculate the 3 week rolling average, the reason we're doing it in formulate rather than through the context calculations is because it will form part of a…
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
2024 Gartner MQ for BI and Analytics
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help