-
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
-
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.…
-
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
-
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
-
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
-
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
-
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
-
Tooltip-Designer
Hello everyone, I would like to create a tooltip in a dashboard. The font size is set to 120. If I reduce this to the desired font size (e.g. 12), this is done with one click.…
- 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
-
Connecting buttons to a slicer to display lists
I have constructed a global parameter with 3 buttons: "All Customers", "Customer group A" and "Customer Group B". I have made 3 corresponding lists (All based on the same dimension,…
- Answered
-
Comparing dates in a formula
What would be the best practice for comparing two date dimension fields in a formula? Here's an example formula we are trying to create: if(created_date<=evaluation_date, 1,…
- 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
-
Help Getting Stacked Bar Plot to Use a Consistent Set of Colors
I am building a discovery that is a paired stacked bar plot with the following characteristics: The X-axis is year. The Y-axis is a percentage of total annual insurance cost of workplace injuries.…
- Answered
-
How do I limit the available months per year
I’m trying to maintain two columns (2024 and 2025) on my Discover Matrix Grid. However, I only want the 2024 column to reflect data from July 1 to December 31,…
- Answered
-
Subscriptions via SMS
Is it possible to subscribe via SMS rather than email? I can't find anything in the support documentation... Thanks!
- Answered
-
Monthly percentage of annual value
Hello, I have created a line chart showing the monthly distribution of reported sales. I tried to add a tip tool that shows the percentage of the month's value relative to the annual value.…
- 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…
-
How to rename the forecast label
Hello, When I use the forecast tool I get Forcast1, forecast 2, forecast 3... I also do see an option to change the word forecast , but what I don't know is how I change it to be the next 6 months.…
- Answered
-
Add "Select All" Option to Multi Select Tree
Hello PA-Team! It would be highly beneficial to add a "Select All" option to the Multi Select Tree slicer, similar to the functionality already available in the Multi Select Drop Down slicer.…
- Answered
-
Add User Search Box within the Role Management Panel
Hello PA Team, I'd like to suggest a simple but very important usability enhancement for the role management interface in the Admin Console. Currently, when I open a role to manage its members,…
- Answered
-
Configuring FTP Source with Host, User, and .ppk File
Hi, Can I configure an FTP source using a Host, User, and a .ppk file? Thanks, Raveena
- Answered
-
Hierarchy Not Totalling Correctly When Adding Logic to a Measure Formula
I have a report example that shows values accumulating over a two-year time frame. If, at any point, the value for a specific Part/Type falls below a defined threshold,…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.