To GoodData homepage

Analytics

Analytics

267 Topics

M
MarketaParticipating Frequently
asked in Metrics and MAQL

Diff between Start Date and End Data

Hi, I am trying to do a diff between end and start date, I am trying this formula in metric: SELECT SUM(SELECT DATETIME_DIFF({label/startdate2.day}, {label/enddate2.day}) BY {dataset/flights}), and it doesnt show any error, but when I am trying to visualize, I am getting error trace: d9781182e7f70bd623d858893b240c73 { "title": "Bad Request", "status": 400, "detail": "A result cache error has occurred during the calculation of the result", "resultId": "db07993fb7512eae09bf975606466e10c948704c", "reason": "General error", "traceId": "d9781182e7f70bd623d858893b240c73"}

4
M
3 months ago
jamesjenkins
jamesjenkinsKnown Participant
asked in Metrics and MAQL

Average age from date of birth

I am trying to find the average age of customers from date of birth but struggling. Any pointers would be appriecated. I have looked at the following two webpages but still just keep getting errors. I imagine it will look something like this. SELECT AVG(SELECT Date({metric/this_year}) - {label/DateOfBirth.year} ) https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/maql-analytical-query-language/maql-use-cases-and-tutorials/date-attribute-arithmetic/

6
jamesjenkins
8 months 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
N
Nicolas JACOBParticipating Frequently
asked in Dashboards and Reports

Opening Dashboard with default filtered value

Hello everybody,I have a dashboard that display data for several Office and can be filtered for these Office, with a Dashboard filter.I would like that the manager of the office can open the dashboard with their Office selected by default. My idea was that it could be done using the Url (/dashboards/#/workspace/xx/dashboard/yy?filter={attr.office.name: “My Office”}) or using user varibale and filter configuration in the Dashbord.  But this do not seem to be possible.Do you see other possibilities that actually works ? Thanks in advance.Best

3
J
10 months ago
P
Preetham ThangammaKnown Participant
asked in Dashboards and Reports

Regarding Export pdf in Good data

Hello,As i want to Export the dashboard data to pdf in good data but it is exporting only the data found on the screen for the table insight.Please do let me know how to export the entire data in the table insight into pdf.Thank YouPreetham Thangamma K 

1
Joseph Heun
GoodData Employee
1 year ago
Z
ZafarNew Participant
asked in Dashboards and Reports

Embedding dashboard React vs Html

I have embedded two dashboards, one using react app where i have to login manually other is html page where i am logging in using SSO. I can see edit dashboard button on the html page. What's the reason i am seeing this in html but not on react app?

2
Jiri Zajic
1 year ago
Douglas Paiva
Douglas PaivaNew Participant
asked in Metrics and MAQL

Add column with comparative percentage of years

Hi guys!I would like to know how I can add a column that presents the percentage calculation comparing the values ​​of a year with the previous year, as shown in the table below. I only need three columns... if possible to show in "green" the growth and in "red" the fall. Could you help me please?

3
Joseph Heun
GoodData Employee
1 year 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
B
B. LoganNew Participant
asked in Metrics and MAQL

Issue plotting RUNSUM without data at regular intervals

Hello,I’m attempting to plot fees + expenses to date by week to show project expenditure against budget. I’m using the following metric definition to create this specific trend. SELECT RUNSUM(IFNULL(Time Entry: Fees In Cents/Currency: Base Unit, 0)) + RUNSUM(IFNULL(Expense: Amount In Cents/Currency: Base Unit, 0)) with PF except Date (Shared)This works as expected when there is data every week, however not all projects will have expenses each week. When there is intermittent data, RUNSUM doesn’t graph correctly. Essentially there are holes in the graph, and as soon as there is data again the graph will continue, but leave a gap. This issue is not corrected by the “ifnull” statement in the metric definition. For example, the yellow trend below is fees + expenses to date, the green trend is fees to date. Fees to date is shown correctly because there are fees already entered for the week of Sun 3/19/2023, but there are no expenses yet so the yellow trend line stops at the previous week. I

3
Moises Morales
GoodData Employee
1 year ago
A
Andrew IlinNew Participant
asked in Metrics and MAQL

GoodData.CN Community Edition / MAQL metric calculation

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!

3
Iva Gasparekova
GoodData Employee
2 years ago
jeferson.nunes
jeferson.nunesParticipating Frequently
asked in Dashboards and Reports

Error copying a tab to a new dashboard

Good Morning!!Yesterday I started getting this error when trying to copy a tab to a new dashboard.I couldn't identify the problem as it was working normally before. Could you let me know what could be happening?Thanks for the help!

2
Michael Ullock
GoodData Employee
1 year ago
M
Michelle
asked in Dashboards and Reports

Duplicating dashboard alerts

When I duplicate a dashboard, will the email alerts be duplicated as well?

1
Moises Morales
GoodData Employee
3 years ago
R
RodrigoVM14New Participant
asked in Metrics and MAQL

Struggling with filters

Hi there,I need to build a table that brings the cumulative number of fired employees, by month, since the beggining of the company. I’ve managed to build the metric and the table brings the monthly numbers correctly, when I don’t apply a filter. However, when I filter this table to show only the last 12 months, the results are not cumulative anymore, it shows only the number of fired employees of that month alone. How can I overcome this?I’ve tried using many functions, like RUNSUM, BY, WITHIN, ROWS BETWEEN, but none of them seems to work.I’m new to MAQL and kind of struggling with this problem. Any help is welcome. Thanks!

4
R
1 year ago
K
kaviKnown Participant
asked in Metrics and MAQL

Grouping Metrics into folder

Hi, In our system, we employ the LCM approach. Two new metrics that I created have been added to the folder in the DEV master workspace. I then executed the release and rollout bricks to implement the modifications in other client workspaces. Unfortunately, the supporting client workspaces do not have those 2 new metrics.Can somebody explain to me why this is acting in this way? Thanks,Kavi

4
Iva Gasparekova
GoodData Employee
11 months ago
M
MashaKnown Participant
asked in Dashboards and Reports

KPI alerts

Hello, could you please let me know if it’s only possible to create KPI alerts based on metrics that are being calculated within GD and exist as metrics? Here’s an example - let’s say I want to track open to visit rate (O/V) as well as raw visits number. Can I create KPIs and alerts for both or only or O/V? If i cannot create a KPI and alert for such raw metric as visits, is there any way in GD I can track it and be alerted if that number falls/raises?Thank you! 

5
M
1 year ago
J
Jean-Christophe
asked in Metrics and MAQL

Specific SQL keyword

Hi, Is there a a way to do a MINUS/EXCEPT like in SQL ?Objective is to count all users that are having event for something but not for something else.example :    SELECT DISTINCT LEARNER from ...    WHERE USER_ACTION_FACT_TYPE  in ('Bookmark', 'Share', 'Comment', 'Like','ArticleView'  )    MINUS    SELECT DISTINCT LEARNER from ...    WHERE USER_ACTION_FACT_TYPE in ('Training Session' ) What about INTERSECT ?    SELECT DISTINCT LEARNER from ...    WHERE USER_ACTION_FACT_TYPE  in ('Bookmark', 'Share', 'Comment', 'Like','ArticleView'  )    INTERSECT    SELECT DISTINCT LEARNER from ...    WHERE USER_ACTION_FACT_TYPE in ('Training Session' ) Best regardsJean-Christophe 

5
Joseph Heun
GoodData Employee
1 year ago
A
aboucNew Participant
asked in Dashboards and Reports

Line Chart for Tracking Remaining Budget Week Over Week

I’m looking to use the line chart to create a budget burndown report in Kantata that works in the following way.X AxisWeekly timeline based on Project Start Date and Project End Date Week = Sunday - SaturdayY Axis Target burndown trend line based on Project Hours Estimate / number of weeks between Project Start Date and Project End Date Trend line beginning with Project Hours Estimate, populating week over week with Hours Remaining Begin with Project Hours Estimate (total available hours) Each week, add a data point based on Remaining Hours Bonus if this can be combo chart with a weekly column to display hours used each week. 

1
Julius Kos
GoodData Employee
11 months ago
hanka
hankaKnown Participant
asked in Dashboards and Reports

Automated migration of dashboards / insights to use new attributes

Hello!As I have updated my data model a bit, I’d like now to migrate all the dashboards to use new attributes in place of the old ones.What can be done to automate it, at least partially?https://help.gooddata.com/doc/enterprise/en/workspace-and-user-administration/managing-workspace-data-and-data-access/manage-attributes/find-where-an-attribute-is-used/ article shows the usage of `https://secure.gooddata.com/gdc/WORKSPACE_ID/usedby2` endpoint, so I can check which old attributes are used where. Unfortunately I couldn’t find any documentation page describing which categories of the returned entities means what. Some are self descriptive, but not all.So, knowing how my old attributes are used, and to which attributes they should be changed instead, what are the options, preferably via Ruby SDK or grey pages endpoints, to update existing dashboards/insights/metrics, so it doesn’t have to be made manually? Best,Hanna 

6
A
9 months ago
R
Ron BorensteinNew Participant
asked in Metrics and MAQL

Top 10 results per day

I have a measure called `timeSpent` which is time a user spent in seconds on a page.I have attribute called domain which is the site the user visited, and I have the date.I want to create a stacked bar chart showing the sum of timeSpent for each domain on each day. As there are too many domains I try to filter the top 10. However, that returns the top 10 overall, and I would like to show the top 10 sites per each of the days.I went over the maql courses, and tried many different things, and I am struggling. I think that row_number could somehow help here, or at least that’s how I would have solved it in sql, but I am not sure how to use it here.  

2
R
2 years ago
M
MashaKnown Participant
asked in Metrics and MAQL

Working with metrics

Hello,I have a question regarding the working with metrics topic. I have read through documentation related to this topic but it's still unclear to me why Attributes become unavailable when I pick a metric that I created. I'm trying the basic concept of creating a metric by summing up 2 facts from different fact tables of the data model. Both tables are related to one dimension table (that stores all attributes) as 1:N.The interesting part for me is that if I'm using these same 2 facts separately, most of the attributes remain available.  Please see the screenshots below. 

7
Julius Kos
GoodData Employee
1 year ago
valerieholman
valerieholmanNew Participant
asked in Metrics and MAQL

Format Text

Is there formatting code to ‘wrap text’ in a column heading or an attribute? 

2
valerieholman
1 year ago
D
dlookNew Participant
asked in Dashboards and Reports

Change Dashboard Permissions: How to use Share dashboard via Post-messages and/or API request(s)?

According https://support.gooddata.com/hc/en-us/articles/4411041867283-January-27-2022 new Dashboards create as Private.Our App use Embedded GoodData iframe also we use some API calls.How to use Share dashboard via Post-messages and/or API request(s)?

1
Moises Morales
GoodData Employee
2 years ago
Pushkar
PushkarNew Participant
asked in Dashboards and Reports

Is their any limitations to loading data as a table in GoodData to display it on the GoodData UI

I am trying to load almost of about 170k rows using pivot table in gooddata UI, but it throws an error saying "Too many data points, try applying filters".How can one overcome this issue?

1
Joseph Heun
GoodData Employee
1 year ago
P
Preetham ThangammaKnown Participant
asked in Metrics and MAQL

How to display from 1 to 10 in the order which is an attribute column?

Hi,   Please let me know how to display from 1 to 10 in the correct order because in the attachment 10 is displaying after 1 which is incorrect. And this is an attribute column. Thank You

5
Iva Gasparekova
GoodData Employee
4 months 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
Welcome to the GoodData Community!Cookie settings