Hi! I’m looking for a suggestion on how to move between two reports without a need to manually apply a filter on each.This is about a dashboard in pixel perfect UI.We have a dashboard with two reports. One report is of Overview type and shows a list of clients per country, the second report gives Detailed View of the data per client.The type of intuitive user experience we would like to achieve is for a user to be able to click on a client name in the Overview report and be redirected to the Detailed View report with a filter for this specific client applied.I know this exact behaviour is not possible, but is there anything that comes to mind to make navigation between these 2 reports intuitive and minimise the need to manually apply a filter in the Detailed View report?Thanks in advance for any suggestions!
Hi,I have a dataset containing sale orders, which includes:Order Date - Date the order was placed Customer ID - Unique ID for each customer Order ID - Unique ID for each order Customer Type - ‘New’ if it’s the first order placed by the customer, ‘Repeat’ for all subsequent orders £ Amount - Total order amount in GBPWe would like to introduce a Customer Segment, which is dependent on the reporting period (week/month/year) and is defined as:‘New’ if the customer placed their first order within the reporting period (regardless of whether they also placed repeat orders within the reporting period) ‘Existing’ if the customer placed their first order before the reporting periodI want to create a metric ‘£ New Customer Sales Monthly’ which is the SUM of the sale order amounts (£ Amount) for New customers each month.Note - if the customer places their first order in a given month and places repeat orders within that same month, then all of those sale order amounts should be included in the ‘£
Hello,I have:A fact named Workday (values 1 and 0). The dimensions attached to the fact: Company, Employee, Date. Companies are essentially our subsidiaries in different countries where different holidays are applicable, resulting in differences in maximum available Workdays.In my report I want to see metrics:A: the number of Workdays per Employee in a selected time period B: number of MAX Workdays any Employee had in the sae Company and in the same time period (basically how many workdays were available if a specific employee had worked on all possible days) C: % of A/BI am struggling to create a metric for B where I want to find the maximum number of Workdays any Employee in the same Company had within a chosen time period.The closest to what I need is when I define the metric B as follows:SELECT MAX(SELECT SUM(Workdays) BY Employee WITHOUT PF EXCEPT Date (Worked Date)) BY Company ALL OTHERHowever, as soon as I filter the report for any subgroup (specific employee, team, etc.) the
Hello! I’m having a problem trying to lock the agregation level in a result. I have a report showing : store, articule, sales and stock. I need that the sales metric doesn’t change despite the store.For example: if one articule had 3 sales in one store and 2 sales in other one, the report should show 5 sales no mather what store I am looking.
Here is my Logical Data Model:For each WorkOrder have Ticket Created Date, Wo Created Date,… dimensions, when I add Ticket Created Date dimension then I can not use Wo Created Date or others in the same insight. I have to work around that I created a view to convert other Dates to text to display on the report (Ticket Created Date Text, Wo Created Date text,...).Do we have any solution or better ways of this? Please help me.Thank you so much!
Hi there. I hope that somebody can help me with my situation. Some KPI dashboards I have are actually important only in case some metrics are bellow a threshold. I have to always check the dashboard or e-mail I get. Is it possible to be somehow notified based on a value of a metric? If it is not possible, it would be really helpful and it should be added into the product! Thank you, Mia
I have a headline stat drilling into a separate report showing table data for that stat. Headline Stat: # of WidgetsFilterable by in Dashboard:Widget Category Date (Timeline) App Store StatusDrills into a report showing: Widget Name, Widget Developer, Widget Description, Date (Submitted) Actual Behavior: The drill into report is filtered correctly by widget category but NOT by the timeline filter. It’s showing Widget info across all submission dates. The headline stat for my applied dashboard filters is showing 7 Widgets, however the drill in report is showing a much larger group. Expected Behavior: I want the dashboard filters including the timeline dimension to apply to the Drill Across report. I cannot change the drill-in report to display based on Date (Timeline) (the report says it’s not available for the data I selected).
Hello there. I uploaded our invoice data into GoodData and I would like to create a report where I will see how many days are open invoices past due. I do not have this number in my source data, I have just due date. Is it possible to calculate it? Thank you. Simone
I know I can add filters to the entire dashboard, but some BI tools have the ability to click on one widget in a dashboard, and filter all other widgets based on that interaction. For example if I had a donut chart with different categories displayed, I could click on that to show only those categories across the entire dashboard. Is this possible? Or would I only be able to do it using GoodData.UI?
Hi I created a metric based on two values that I’m using in an insight. However, when I use the metric ( a measure that simply chooses which of the other two measures should be shown) I get a message saying “Sorry, We Can’t Display This Insight”. And then when I use other data values, it moves into “unrelated data measures” Do the metrics need to be applied to the LDM? Or do I need to somehow associate the metric with a given dataset? Thanks James
Already have an account? Login
Login to the community
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.