-
Sequential sorting of a single dimension by multiple measures
Hello everyone, I am trying to ascertain whether I can sort a table on a single dimension column but apply sequential sorts using more than one measure.…
- Answered
-
Changing Slicer Settings
I've noticed that when I change a slicer from Single Select Tree to Multi Select Drop Down that it places my Single Select Tree selection into the background and does not change the Slicer Type.…
- Answered
-
Dynamic texts for Slicers
Hi Folks, I am trying to use Dynamic text in Pyramid analytics 2018 which is based on the slicer (single select-drop down) so that the Presentation header in each slide changes with the slicer…
- Answered
-
Tooltips
Hi, My tool tips don't appear to be working. I have told the software to display the Netlocation as tooltips, but when I scroll over or click on the lines in the line graph nothing appears.…
- Answered
-
Time Intelligence Wizard
Is there something like the Time Intelligence Wizard available in Pyramid 2018?
- Answered
-
Pyramid Data Tip of the Day - Hierarchical Support in Context Calculations
Our video of the day looks at the new hierarchical support for context calculations. Context functions let users build calculations that can only be resolved efficiently in the context of a report.…
-
Setting dimension elements to a secondary axis
Hi, I don't know if the following is even possible using an OLAP cube model. I'm looking to create a graph to view the YoY data with the percentage change overlaid on the secondary axis as a line…
- Answered
-
Tip of the Day - Custom Totals by Measure
Video of the Day – Custom Totals by Measure Our video of the day looks at Custom Totals by Measure. Adding grand totals and sub-totals to your grids provides additional context and information.…
-
How to chart the Top 5 along with an aggregate of the Other
How to chart the Top 5 along with an aggregate of the Other In a Question in the Q&A Section of the Community User @Bruce Campbell asked how to combine the Top 5 of a list with an Aggregate of the…
-
Learning Live: Enriching Data with Python Scripts
About this Video: In this video we give you an overview about how you can enrich your analytics data with Python Script. Content: Lets check out this session,…
-
How to Customize Totals in a Grid
How to customize the totals in a grid When you add totals to your Grid Pyramid automatically adds the sum of the columns. Sometimes this does not give you the optimal result.…
-
Sorting with Trellis
Hi, I have a trellis graph and I want to be able to sort values descending on both graphs separately. At the moment it half sorts the graphs, as you can see below it picks up the largest value…
- Answered
-
How to combine Values from different Measures in one chart
How to combine Values from different Measures In this question we got from a customer, the user tried to combine two values who are in different measures into one single chart.…
-
How to add subtotals for % Values to sum up to 100% in the category
Question: How to add subtotals for % to sum up to 100% for the category In a recent internal discussion we came across this question and wanted to share the solution to a broader audience.…
-
Why are my formulas not showing up
I have a handful of formulas that execute successfully in a Public Content folder. However, in Discover, only 2 of them show up Even if it is a blank discover panel.…
- Answered
-
Combining two discovery tables in present
Hi We have two tables which we are trying to merge. The left one defines top 20 suppliers with their market share in cur month, previous month, cur ytd, current ytd.…
- Answered
-
Change path of Discovery in Presentation
There are a lot of duplicates within our Discovery's. While cleaning this up, i stumbled across two of the same Discovery's. Both of them are used in the same presentation.…
- Answered
-
How can I convert date hierarchy into specific format?
Hi together, I need a graph with a dynamic changing x-axis (last 12 months) with dates in the format “MM-YYYY”. I am using a date hierarchy to get the dynamic part working.…
- Answered
-
how to create nest folder view in configuration section
Hi, May i ask your help how to achieve nested folder structure in Pyramid model development from the snapshot provided the second screenshot is taken as reference from different BI application.…
- Answered
-
How would I stop the percent from being displayed in Discover on a Pie Chart?
How would I stop the percent from being displayed in Discover on a Pie Chart? It would be confusing to my end-users.
- Answered
-
In Explore Further is there any easy way to filter out records with $0 measures?
We have users using explore further and add a measure but have no way, that we can see, to easily filter out the records with 0 as the measure value. Is there a way for them to do this?
- Answered
-
Change Value on horizontal axis based on variable value selected
I am trying to change dimension in horizontal axis of my graph based on the filter selected. For example, In graph I would like to change value in horizontal axis to created date year, quarter,…
- Answered
-
Sort multi-select Slicer
Can we sort data of multiselect slicer(Filter)? I have 'Date' slicer. I want to show Date in descending order.
- Answered
-
Is there a way to create groups and then filter within those groups
My discovery table needs to contain some groups so I can filter by those. For example with countries the data set we use has them broken out, I will need to create a group for all the European…
- Answered
-
'Lagging' Time-Scale in Discovery
Hi all, Please see attached screenshot. I am trying to build a section of an existing report at my company in discovery for export to excel (for the time being).…
- Answered