To GoodData homepage

Analytics

Analytics

270 Topics

L
Linda JInspiring
asked in Metrics and MAQL

Use filter as a parameter

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

2
L
3 years ago
J
Julia KNew Participant
asked in Metrics and MAQL

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 :)

3
Boris
GoodData Employee
3 years ago
L
Linda JInspiring
asked in Metrics and MAQL

Prior year calculation

Hello,I have been able to create a metric to compute prior year - but am having an issue with filtering - see screen shotI need to be able to see the prior year values for Dec, Jan and Feb  - If I ignore the parent filter I get values for all time

5
Iva Gasparekova
GoodData Employee
3 years ago
L
Linda JInspiring
asked in Metrics and MAQL

Help with Previous year calculation

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   

4
L
3 years ago
K
Konstantin KomissarchikNew Participant
asked in Dashboards and Reports

Bar chart sort order

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.

1
Joseph Heun
GoodData Employee
3 years ago
K
Konstantin KomissarchikNew Participant
asked in Metrics and MAQL

Zero values in bar chart insights

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.

4
K
3 years ago
L
Linda JInspiring
asked in Dashboards and Reports

Column chart How to color by group

I have a simple Column chart see below - in which I want to break down each business line by Sales region.  For Example instead of 1 bar per Business line I need 4.  Each should be a separate color.See example from another tool.  

1
Iva Gasparekova
GoodData Employee
3 years ago
M
Manu MeicNew Participant
asked in Dashboards and Reports

Filters and metrics

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 :) 

1
D
GoodData Employee
3 years ago
T
TommyGNew Participant
asked in Metrics and MAQL

DateDiff in MAQL?

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

1
Joseph Heun
GoodData Employee
3 years ago
M
Maria NawrocikNew Participant
asked in Dashboards and Reports

Linking between reports with saved filter

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!

1
Boris
GoodData Employee
3 years ago
A
AshleighNew Participant
asked in Metrics and MAQL

Difficulty creating new MAQL metric based on Customer Segment

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 ‘£

3
A
3 years ago
A
Allan TalverNew Participant
asked in Metrics and MAQL

Struggling with MAQL (aggregation and filtering)

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

1
Petr Olmer
GoodData Employee
3 years ago
M
Manu MeicNew Participant
asked in Metrics and MAQL

Results locked by attribute

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. 

1
Petr Olmer
GoodData Employee
3 years ago
S
suseteNew Participant
asked in Metrics and MAQL

How to get data from a specific table not in a child table? For example, all Users without any Skill?

How to get data from a specific table not in a child table? For example, all Users without any Skill?

1
Michael Ullock
GoodData Employee
3 years ago
L
LenaKnown Participant
asked in Metrics and MAQL

Cannot pull multiple Date dimensions into one Insight

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!

4
L
3 years ago
T
Tony J.New Participant
asked in Dashboards and Reports

KPI alerts - on what level can they be set?

Hi, I’ve got a question regarding KPI alerts (this is a question kinda related to this question). When there are multiple users within a workspace, can each user set-up their levels for KPI alerts, or are these alerts set on a workspace level? Thank you!

2
T
3 years ago
M
Mia W.New Participant
asked in Dashboards and Reports

Metric threshold alert

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

2
M
3 years ago
T
Tara L.New Participant
asked in Dashboards and Reports

Do Drill Across Reports constrain by dashboard timeline dimension?

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).

1
Joseph Heun
GoodData Employee
3 years ago
C
Courtney VadnaisNew Participant
asked in Dashboards and Reports

Combo Chart

Looking to create a combo chart with a stacked bar chart and a line chart, but so far I am not having any success. Any ideas on how to make this work? My secondary access keeps coming up as another bar chart when I set it to line. 

1
Moises Morales
GoodData Employee
3 years ago
S
Simone HaasNew Participant
asked in Metrics and MAQL

Calculating how many days are invoices past due

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

2
S
3 years ago
A
Anonymous
asked in Dashboards and Reports

Notifications for other users?

I know that a user can setup metric based email notifications using the bell icon on a dashboard. Is there a way how I can (maybe even programmatically) configure notifications for other users?

1
Moises Morales
GoodData Employee
3 years ago
M
Michelle
asked in Dashboards and Reports

Embedding KPIs

Can KPIs and insights be embedded directly instead of the whole dashboard?

2
A
3 years ago
J
JamesParticipating Frequently
asked in Dashboards and Reports

Can I Filter The Entire Dashboard Based on a Click

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?   

1
Joseph Heun
GoodData Employee
3 years ago
M
Mia W.New Participant
asked in Dashboards and Reports

Is pagination available on charts?

Hi,does anyone know if pagination on a chart with many results is possible in GoodData?The use case is a horizontal bar chart where the number of entity names causes the chart to be cramped and difficult to use.Thanks!Mia

1
Zuzana Bednarova
GoodData Employee
3 years ago
J
JamesParticipating Frequently
asked in Metrics and MAQL

How To Ensure A Metric Available In Analytics Designer

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 

2
Pavel
3 years ago
Welcome to the GoodData Community!Cookie settings