Good Morning!I need help to make a metic where I need to display the average sales for the last 10 days I tried to do it this way and I was not successful SELECT AVG(Sales WHERE (Date “in this case the day”) BETWEEN THIS - 10 AND THIS)In short, I need to return the average sales volume of the last 10 days.Thank you very much in advance!
HiThis article provides an example of writing a request to the system - https://www.gooddata.com/developers/cloud-native-community-edition/ like Active Users:SELECT COUNT(User) WHERE User Status = "Active"We have installed the system and cannot find a way to make such a request. Are they available there? Where could we go wrong?Thanks!
Hello, I would like to be able to change the metric displayed on the report based on a paramenter.For exampleA drop down box on the Dashboard has 2 possible selections A and B - only 1 can be selectedIf A is selected the formula for the metric is Z+YIf B is selected the formula for the metric is Z-Y I believe I would have to start by loading a phony table with just the values of A and B - and then add a filter onto the dashboard for the selection. But after that I am stuck. Thanks for your help
Timestamps - I need to calculate how many users were active each minute, having single intervals of their activity
Hello!The problem I’m struggling is how to create an AMR (Average Minute Rating) using MAQL. For simplicity I started with one day period when I want to observe how users activity changes over time (for example minute by minute). So I have data of a form:userID start time - atribute refering to Start time table having M, H, S values as a facts, start time label as a key HH:MM:SS and an atribute start time [min] HH:MM start day - date end time - atribute refering to table with a structure like Start time table already described end day - date activity detailsI was able to build a very inelegant vay to find out how many unique users were active during particular hour (e.g 20:45 HOUR = 20, MINUTE = 45), but with one major drowback which is that I need hour and minute as a variable to do those calculations. Here’s the MAQL form:I need solution that could be visualised - for every minute, automatically. Hoping for your help! I would appreciate any hints :)
Hello, I am trying to create a calculation to show the variance between the select time period (based on the dashboard filter) and the previous year. It looks like I need to use the previous function - but I am receiving the below error. When I use this calculation the result is always zeroSelect SalesCredit Business Line- SalesCredit Business Line where Year (Billingdatekey) = Previous
Can I control the sort order of bars in a bar chart? The default sort order sorts by magnitude, which is good for many situations, except when there is a natural semantical sequence of values, such as state transitions, and showing them out of their natural order is not desirable.
I have a bar chart that is using the basic “count of id attribute” for the measure. The problem that I have is that some of the “view by” values are missing from the chart if their count happens to be zero. I need to show all possible values of the “view by” column on the chart, even if their count is zero.
Hi everyone! I have a question about a report which contains two attributes and three metrics. I have some filters in the Dashboard but I need that those filters apllies only on two of the three metrics. Is anything I can do with the metric editor in order to achieve that? Thanks in advance :)
Hi there everyone,I was just wondering if there is a simple way to perform a DateDiff function in MAQL. More specifically I want to be able to count number of days between Order Date and Today. I will be using Order Status to determine whether the order was completed and this MAQL metric would help me in highlighting those that take too long. Thanks a lot,Tomas
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.
Hi I have a fact that can be Null at times.I can count the records where it is not nullselect count(attribute) where fact > 0.I am trying to count the amount of records that are null.I do not see anything in the MAQL guide for that. Is there a way?I tried fact = 0 even know I know null is not 0.I tried fact <=0 Neither worked.
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).
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.