-
How to: Display Daily Data in a Calendar View
How to: Display Daily Data in a Calendar View When you are working with Daily Data it will sometimes make sense to display the information in a Calendar view.…
-
Tip of the Day - How to format a measure that is in seconds as hours minutes and seconds
How to format a measure that is in seconds as hours minutes and seconds Imagine you have a table column in a model that represents the duration of a period in seconds,…
-
Tip of the Day - Dynamic dimensions and measures
How to create dynamic dimensions and measures that can be exchanged This tip & trick has been provided by @Michael Daun who created this solution while working on a project What to we want to achieve…
-
How to: Create a dynamic set of dates
Question: How to create a dynamic set of dates During a recent discussion we got asked how to create a dynamic set of dates. There are two approaches to the tasks,…
-
How to add a Custom Visual
How to add a Custom Visual Pyramid offers a broad spectrum of standard visualizations that are available to users in the Discover App. In order to include additional visualizations,…
-
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.…
-
Tip & Trick Pre-Query Slicers
Pre-query Slicers allow users to set the slicer selections for specified slicers and parameters upon opening the Discovery report, before the query is loaded.…
-
How to use KPIs and Gauges in a Dynamic Way
How to use KPIs and Gauges in a Dynamic Way The Use Case Working with a customer, I recently ran into an interesting use case that required dynamic band values in a KPI and a gauge view.…
-
Tip of the Day - use formulate to calculate percentages of some elements
Our video of the day looks at a way to calculate percentages of elements A question came up from a client on how to calculate the percentage of two elements in a dimension from the total of this…
-
Tip of the Day - How to create a switch list in a report
How to switch between two sets measures list in a report If you want to display different sets of measures in a Report, you can do so by creating a variable list in Discover.…
-
How to build Aggregate blocks for a Dimension
How to build Aggregate blocks for a Dimension When you are working with larger lists it is often necessary to define groups of elements into a single aggregated element that contains the totals for a…
-
How to create a parameter driven list and search across multiple attributes
How to creating a parameter driven list and search across multiple attributes Imagine we have a long list of Values in a table. Now we want to filter out all lines that contain certain values but…
-
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.…
-
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.…
-
How to add and work with Bookmarks
How to add and work with Bookmarks For frequent users of reports with many slicers, choosing pre-saved filter combinations for your area of interest can be a significant time saver.…
-
How to create a Sankey Chart and Cascading Slicers
How to create a Sankey Chart and Cascading Slicers Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
How to use a Report or Page Trigger to generate a Publication when criteria are met
How to use a Report or Page Trigger to generate a Publication when criteria are met When you offer to trigger a report or page from your Publication, it only makes sense to start the process if the…
-
How to use a chart to filter other charts
How to use a chart to filter other charts In a question in the Q&A Section of the Community we got asked how to interact several charts so that they work as actual filters not just highlighting the…
-
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…
-
Tip of the Day - Visual Tool Tips
Create custom graphic tool tips that display a given data discovery or presentation when hovering over a specified measure in a selected visualization. The report displayed in the tool tip is…
-
Tips & Tricks: How to identify duplicated elements
How to identify duplicated elements? A recent Question on the Community asked what would be a good way to identify duplicates. E.g. where an Element has been assigned a Status twice where it only…
-
How to build a Waterfall Charts with Context Calculations
How to build a Waterfall Charts with Context Calculations Waterfall Charts are a great way to see contributions to a resulting value in an easy way. With Context Calculations the Waterfall represents…
-
How to build an Accounting Table with Images and Links
How to build an Accounting Table with Images and Links Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
-
How to build Aggregates with Context Calculations
How to build Aggregates with Context Calculations Working with the more advanced functionalities of Discover can be seen as daunting, but don’t be afraid.…
How To's and Knowledge Base for the Discover Module