To GoodData homepage

Analytics

Analytics

268 Topics

P
plaubeKnown Participant
asked in Metrics and MAQL

How use MAQL command Count with similar condition SQL (NOT EXISTS)

Hello, please help me, how to correctly write this SELECT in MAQL. SQL:select count(*) FROM table_a WHERE NOT EXISTS(select * FROM table_b WHERE table_b.id_table_a = table_a.id_table_a)  Thank you very muchPetr

5
Joseph Heun
GoodData Employee
2 years ago
S
Sankar SandipNew Participant
asked in Dashboards and Reports

GoodData embedded analytics on public web

Our intention is to have analytics on our public website based on our data. It should include also a report builder. Can GoodData do that?

4
Josh Collins
2 years ago
K
Konstantin KomissarchikNew Participant
asked in Dashboards and Reports

More than two columns in a dashboard

Is it possible to customize the dashboard layout to allow more than two insights on one row? The dashboard editor is limiting to two per row. For my usecase, I am trying to have about half a dozen horizontal bar chart insights on one row, to show different slices of data all at once. 

5
Moises Morales
GoodData Employee
2 years ago
P
PD5Known Participant
asked in Metrics and MAQL

How to filter by 2 different dates

I have a data model with orders and refunds in separate tables. I would like to use MAQL to create a metric showing the sum of all the order totals, less the sum of all the refund totals for a particular date and/or date range. The problem is that the two tables are using different dates. The orders table has “date the order was created” and the refunds table has “date the refund was created”. This is fairly simple in pure SQL using 2 sub-queried, Is there a way of making this work in an MAQL query? Edit: I should also mention that the order refunds table is linked to the orders table via the order id which complicates things further.   

4
Joseph Heun
GoodData Employee
2 years ago
D
DipperNew Participant
asked in Metrics and MAQL

Filter Date in Metric

Hi Community,Our HR team are wanting to do 90 Day Turnover by restaurant.  I’ve been able to create the below metric that I can use in a report to bring me back by employee by site however the date is a fixed date.  Any suggestions for how to use a single date within the dashboard filter instead of having it written into the metric?  Ideally I was hoping to get something along the lines of excel with Today() then that date to be overwritten when filtered in the dashboard.Currently the date 11/28/2021 is the period end, I would like this to be dynamic.New Starter MetricSELECT IF (Employee Start Date (HR_Events) + 91 > 11/28/2021 AND Employee Start Date (HR_Events) <= 11/28/2021) THEN 1 ELSE 0 ENDLeaver MetricSELECT IF Employee Start Date (HR_Events) +91 > 11/28/2021 AND Employee Termination date (HR_Events) <= 11/28/2021 AND Employee Termination date (HR_Events) <> 01/01/1900 THEN 1 ELSE 0 ENDThanks in advance

1
Iva Gasparekova
GoodData Employee
2 years ago
S
Samantha ZhangNew Participant
asked in Dashboards and Reports

Export/Import: some Dashboards not visible after copying from a different project

Hi team,I have copied 3 dashboards between 2 workspaces. After importing the dashboards to the target project, 3 other similar dashboards in the target project disappeared. I cannot see them anymore, but the 3 new dashboards are there. I copied 3 dashboards from this project: havcd723mmm69cs5ujz6d9k4a7ce8 - to this project: audcfba5qtg8k3o8bheiln8p0zdfetqv3. Now in the destination project audcfba5qtg8k3o8bheiln8p0zdfetqv3 the 3 other dashboards are not visible anymore. I have also checked grey pages and I cannot see them there either. Can you please help me to understand why I can no longer see those dashboards?Thank you! 

2
S
2 years ago
A
AdventaNew Participant
asked in Dashboards and Reports

MS SQL Data Integration

We are trying to connect to our server, which is Microsoft SQL. However, it is only offering the URL option as opposed to connecting via an IP address. Can anyone please help?

1
Jan Kos
GoodData Employee
2 years ago
G
Gabriel RubinsteinNew Participant
asked in Dashboards and Reports

Can a field be a fact/measure AND an attribute? (or other work around)

Hiya,I’m trying to create a dashboard and I want viewers to be able to use filters including one filter on a measure. However, it seems that measure filters are only available at the insight level, so cannot be used by viewers. I could change the field I want to filter on to be an attribute I suppose, but this would mean I can’t use it as a measure in other reports. Is it possible for the field to be a both a fact and an attribute? Is there another way to get around this? Am I missing something fundamental? Any help would be greatly appreciated! Many thanks, Gabriel

3
Moises Morales
GoodData Employee
2 years ago
A
Alejandro BNew Participant
asked in Metrics and MAQL

Last day of the selected month

Hello, I would need to create a metric to bring me the last day of the month that I am selecting in the filter of a report.For example, If I select the day March-18-2021, it should bring me the number 31.If I select the day April-14-2021, it should bring me the number 30.And so on, 28 in February (or 29 if that year is a leap year).Thank you very much!

4
A
2 years ago
P
PD5Known Participant
asked in Dashboards and Reports

Setting consistent bar chart colours for all insights on a dashboard

I am currently setting up a dashboard with multiple insights on it. Many of the insights are bar charts where the bars are coloured depending on the product category. However, the colours do not match between insights. e.g. the Helmet category is orange on one insight but purple on another.Is it possible to set the category colours globally so that whenever they are used in a chart they remain consistent or do we have to manually set them in each insight using the settings there?   

2
P
2 years ago
E
Elly BryanNew Participant
asked in Metrics and MAQL

Issues with Rounding & Aggregation metric

Hello, I want to calculate the value on each order in a table, then round each value to the nearest 2 decimal place, and then add up all those rounded numbers. But when Aggregate Table Data by SUM I am not getting the same result as the Total for my ROUND metric. It seems the SUM row is rounding and then summing, but the ROUND metric is summing and then rounding, then they're getting different results for the same metric. Can you help me with this? Slice metric1 by attribute2, round sliced metric to two decimal places, then sum the rounded values? 

2
E
2 years ago
L
Lori MNew Participant
asked in Dashboards and Reports

Users downloading original csv

When using a .csv to upload data, is it possible for users (viewers only) to download that original csv when they sign in to view the dashboard?

1
Moises Morales
GoodData Employee
2 years ago
K
Keyser SözeNew Participant
asked in Dashboards and Reports

On issues regarding multiple time zones

I am facing an issue of displaying the same embedded analytics to various users in different time zones, in my research and evaluation of GoodData, I haven’t yet found much on the subject. Could someone help me out on how this can be solved within the GoodData platform, if there are multiple solutions (some more convenient than others), I would like to hear all of them. Thanks,Keyser

1
Michael Ullock
GoodData Employee
2 years ago
L
LuciaDelloNew Participant
asked in Metrics and MAQL

Is it possible to create an attribute type metric?

Hi, I am trying to create price range bucket to group together products by prices ranges <£50, £50-<£100 in MAQL as a metric then to use it to display results by price ranges.I am able to do the calculation but my new metric is created as a fact not an attribute so I cannot build analysis of different price buckets.I looked at computed metrics too but these only allow me to use pre-created attributes and not fact values within them.Is this possible to do or does this need to happen before the data model enters GooddData. Thanks. 

3
Joseph Heun
GoodData Employee
2 years ago
L
LenaKnown Participant
asked in Metrics and MAQL

Lookup a value not exists in the attribute value list of an attribute

Hi there,I’m creating a metric with a condition that is looking for a value in the attribute value list, but that value doesn't exist in the Attribute values appearance, my case: ‘Vacant’ value doesn’t appear at this time, maybe it will be in the future.How could I use it anyway?Thank you!

5
Iva Gasparekova
GoodData Employee
2 years ago
T
Tuan VoNew Participant
asked in Metrics and MAQL

How can I display a decimal number in HH:MM:SS format when creating metric?

Hi guys,I have request for creating metrics with the formatting like HH:MM or MM:SS or HH:MM:SS like the image above. My metric will return a decimal number and then I must format it in the time format. Assume that my metric result is a number of seconds, I think that maybe I will divide the number by 86400.0 (the number of seconds in a day), 3600.0 (the number of minutes in a day) and 60 (the number of hours in a day).This is the first time I’ve formatted metric related to time format, so I don’t have any idea about it. Do you have any better idea?Thanks for your help!

2
T
2 years ago
jeferson.nunes
jeferson.nunesParticipating Frequently
asked in Dashboards and Reports

Disable Saved Views

Good afternoon!!I enabled Saved Views, but I would like to disable it.I'm not finding the option to disable Saved Views.It is possible? Or do I need to delete my dashboard and create it again?

1
Moises Morales
GoodData Employee
2 years ago
jeferson.nunes
jeferson.nunesParticipating Frequently
asked in Dashboards and Reports

Default View in Dashboard.

 Good Morning!I enabled in Dashboard the option that allows the user to save filter presets as below:However, when the user refreshes the browser by reloading the page, a panel keeps the definition of the chosen filter.I would like that when the user reloads the page the filter goes back to the default.In the tests we performed when choosing a filter and loading a page, the filter is filled. I wish that didn't happen. Is it possible to do that?

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

Doubt regarding Dashboard

Good evening!Is there any way to create a button inside a dashboard that when pressed directs the user to a tab present on that dashboard?

1
Joseph Heun
GoodData Employee
2 years ago
G
gaurav.patilNew Participant
asked in Metrics and MAQL

Update Variable Value dynamically

Hello I am using GoodData for our application. My question is related to variable and update its value dynamically.I will explain you what I have done so far.I have created variable with name organisation_id and set type to filter variable and selected attribute as a id column of one of our database table (Please check attached image - 1)After that I have set user-specific value for that variable e.g. organisation_id = 12, 34, 56 etc.After that I have create custom matrix and use this variable in MAQLe.g. SELECT COUNT(id) WHERE organisation_id(Please check attached image - 2)And then I have added this matrix in insights and in the widget and it filter the data which related to value of organisation_id variable i.e. it only display data related to id - 12, 34, 56 My Question is:Can we update variable value using API?like in above example we set organisation_id = 12, 34, 56now I want to update organisation_id = 89, 90 and get result related to 89 and 90Instead of updating organisation_id

1
Joseph Heun
GoodData Employee
2 years ago
K
GoodData Employee
Kyle ShimekGoodData Employee
published in Metrics and MAQL

Creating measures with conditional expressions using the IF keyword

With MAQL, you have the ability to create measures that use conditional expressions, allowing you to compute your more complex business requirements. One way to do so is to use the IF keyword. It looks like this:SELECT IF condition THEN expression ELSE expression END The IF keyword works just like it sounds: you will set a condition after “IF”, the value to use if that condition is met after “THEN”, and the value to use if the condition is not met after “ELSE”. Finally, you end the expression with “END”. The IF keyword can be used in both GoodData Platform and GoodData.CN.  Here are a few examples of measures we can create in the metric editor: SELECT IF AVG(Duration) > 60 THEN 1 ELSE 0 ENDSELECT IF Category = “Email” THEN SUM(Budget - Spend) ELSE SUM(Spend) ENDSELECT SUM(SELECT IF Cost > 200 AND Supplier = “Acme Products” THEN Price * 2 ELSE Price END) And those same examples as created in GoodData.CN using the API:SELECT IF AVG({fact/call_center.duration}) > 60 THEN 1 ELSE 0

980
K
GoodData Employee
2 years ago
jeferson.nunes
jeferson.nunesParticipating Frequently
asked in Dashboards and Reports

Dashboard Useful Area

 Hello good Morning!!I would like to know if it is possible to use the edges of the Dashboard as a useful area.Is there any way to configure to be able to use this area in red? Thanks for the help!! 

2
jeferson.nunes
2 years ago
D
dasteinParticipating Frequently
asked in Dashboards and Reports

Can't create Insights, results cache crashing

Now that we setup our data source (BigQuery), the LDM can be built fine, first insights could also be created and saved, but after a few minutes of usage, any query prompted by the Report Designer would have the following result: This also happens when trying to load previously saved insights. Looking under the hood, it turned out the results cache keeps crashing:pod/gooddata-cn-result-cache-c8f8f9cb9-8l9ps 0/1 CrashLoopBackOff 7 20mpod/gooddata-cn-result-cache-c8f8f9cb9-mlcc2 0/1 CrashLoopBackOff 7 18mNAME READY STATUS RESTARTS AGEI have attached the log output, any help is appreciated!

2
R
GoodData Employee
2 years ago
J
JRAlvesNew Participant
asked in Metrics and MAQL

Number of days of a customer's last purchase

Hi everone,I'm trying to develop a metric that shows the number of days of a customer's last purchase.I tried to do it, for this way:SELECT max (Date (Data de saída da nota fiscal) - this)but this way, I need put in report, the attribute Date (Data de saída da nota fiscal) and not only a metric by customer name. If I don´t put the attribute, the report return error. Thanks for help. Alves.

5
J
2 years 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
Welcome to the GoodData Community!Cookie settings