To GoodData homepage

Analytics

Analytics

197 Topics

M
Mark PetersonNew Participant
asked in Dashboards and Reports

Is there a way of increasing the maximum height of a widget or enabling paginated reports in PDF

When I export a Dashboard to PDF, any long table visualisations is restricted to 24 rows of data.  Its fine when using the interactive dashboard because you can just scroll down, but I would have expected it to paginate the results in the PDF export.Any ideas how to get around this limitation?Thanks.

2
M
1 day 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

1
Moises Morales
GoodData Employee
1 day ago
P
Preetham ThangammaKnown Participant
asked in Dashboards and Reports

how sum the more than two column values in an insight

Hi,  can u please let me know how to sum the column values in the attached screenshot

5
Joseph Heun
GoodData Employee
1 day ago
P
Preetham ThangammaKnown Participant
asked in Dashboards and Reports

How to apply the column in insight only for single facts in the metrics

Hello,   i am creating an insight where the ‘year(Reporteddate)’ in the columns has to be applied only for the ‘Sum of Claims Opened’  in the metrics as shown in the attachment.How to do that? 

4
Joseph Heun
GoodData Employee
14 minutes ago
hanka
hankaNew Participant
asked in Dashboards and Reports

Date dimension names in "Date as" select

Hello!I have a funny situation where after adding a date to rows when creating an insight, not all dates in the select have proper names displayed. Our LDM assumes, that apart from regular date fields there are also few custom ones, that our customers can define freely, those are Group Custom Date Field 1-6. Once customers have defined their custom fields, we’re renaming them according to their settings. Here you can see that Group Custom Date Field 1-3 have been renamed to Project Scheduled Date…, Contract Signed Date … and Closeout Date & Time...In the date select, for regular date fields I can see their proper name, however, for those custom ones, there’s original name displayed (Group Custom Date Field 1) instead the one after renaming.What can be done to have date displaying proper name? Another issue is that the name is transformed and consists only of what’s in parenthesis if they are in the name. Here you can see only COM name. What naming conventions have to be met to have

6
hanka
12 days 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
13 days ago
P
Preetham ThangammaKnown Participant
asked in Dashboards and Reports

how to filter by 2 different date columns in the insight in Good data

Hi,In the Good Data insight, i want to use filter for effective date and expiration date but after i drag and dropped expiration date, it is not letting me drag and drop effective date as shown in the attached screenshot.So, is it possible to filter by 2 dates in insights in Good Data??

1
Moises Morales
GoodData Employee
15 days ago
JeffC
JeffCParticipating Frequently
asked in Metrics and MAQL

Null Value - Unanswered Phone Calls missing

I have a table of phone call facts, that includes a foreign key to a users table.  When making dashboards, things have been going well as long as the phone call is answered - because the user_id field is populated and aligns with a worker.  Unfortunately, some calls are not answered so the user_id for that row’s column is null. Once I add the full_name to the insight, all of the rows missing a name due to the foreign key disappear (but are still included in the roll up).  I’ve referenced the how-to guide but something isn’t clicking for me how how to cater this to my call center use-case. Can anyone access my account (admin has access from prior ticket) to tell me what I may be doing wrong?  This is a stopper for our migration.

1
Moises Morales
GoodData Employee
15 days ago
JeffC
JeffCParticipating Frequently
asked in Metrics and MAQL

Date Time - Date Time

In our lake we store multiple date times, specifically for our use-case a postgress database with columns utilizing timestamp with time zone, nullable. call_start_time: 2023-01-14T16:32:25+00:00call_end_time:  2023-01-14T16:35:16+00:00 We don’t have a calculated column today, nor are we calculating at insert so we’re trying to create a metric that selects the average of call end time - call start time).  Since things may cross over the 24 hour mark and of we want to present data stored in UTC across different timezones, I’m looking for a way to make this work. In SQL it would be something like: SELECT AVG(TIMESTAMPDIFF(SECOND, call_start_time, call_end_time)) AS avg_time_not_answered FROM your_table_name WHERE Interaction_handled = 0; How can I replicate this in Gooddata, secondly, what is the easiest way to change visualization of our data into a selected timezone?

3
Radek Nováček
Community Manager
16 days ago
N
Nicolas JACOBNew Participant
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

2
Joseph Heun
GoodData Employee
18 days ago
K
kmcdavidNew Participant
asked in Metrics and MAQL

Calculating Days Open/days past due

I’m trying to build metrics for days open and days past due. I tried following a similar thread however, its not working quite right. I used the following to calculate days open and I was able to create a report but it did not filter out any completed processes and I was unable to filter the results at all.Similarly I tried to follow the thread for days past due, creating the metric below, but when trying to create a report for it, it said I couldn’t because it would create nonsensical results. Am I missing something or is this not possible to do?

4
Moises Morales
GoodData Employee
16 days ago
M
martymooseNew Participant
asked in Dashboards and Reports

Too many rows in insights

I have 2.3 million rows in a view.    The insight builder wont let me add attributes because their are too many. Is good data not capable of have a table with unlimited values using pagination or some other method?

1
Moises Morales
GoodData Employee
22 days ago
tylervaleo
tylervaleoNew Participant
asked in Dashboards and Reports

How do you apply a date filter for one graph but not the other?

Hello there,I noticed in my Kantata instance, there is a Date Filter “Date Filter for Graph” that is applicable to a specific graph on an out of the box dashboard, but not to the larger table below. When adjusting the date range, the bar graph will adjust, but the data in the table below will stay consistent with “To-Date” data. Can you please explain how I would be able to apply this? Screenshot below:  

1
Iva Gasparekova
GoodData Employee
25 days ago
AdamV
AdamVNew Participant
asked in Dashboards and Reports

Insight aggregation by week

Hi all,I'm trying to aggregate an insight by weeks. When I move the relevant date to the X-axis, it only offers aggregate by week (Sun-Sat), not the week (Mon-Sun) option. See the attached print screen.I changed my settings to have Monday as the first day of week. But still no luck.Where can I change the weeks starting on Monday for individual insights?Thanks!Adam

1
Michael Ullock
GoodData Employee
27 days ago
M
Mark PetersonNew Participant
asked in Metrics and MAQL

Can you create an attribute based on the value of another attribute

Does anyone know if there’s a way of creating an Attribute based on the value of another attribute, or does this need to be created prior to hitting the GoodData platform? The "Calculated Attributes" won't fit this use-case. My use-case is, I have an Employee Table which contains an "Age" column. I'd like to assign an additional Attribute to each employee called "Age Bracket" and depending on the value in Age, would determine whether the "Age Bracket" value is Gen-X, Gen-Y, Gen-Z, or Baby Boomer. I know I can create metrics for each of those and count the unique employees, but the outcome I'm trying to achieve is a table view which shows for each Age Bracket: Count of employees, Average Salary, Average Tenure, etc. Like attached.Based on this previous article I’m assuming it can’t be done, but hoping something might have changed since this was listed over 1 year ago. Thanks

2
M
1 month ago
M
martymooseNew Participant
asked in Dashboards and Reports

Checkboxes / Multiple Select by row in tables?

Is there a way to have checkboxes in each row of a table that allows you to select a row one by one?   

1
Julius Kos
GoodData Employee
1 month ago
scott.jacobsen
scott.jacobsenParticipating Frequently
asked in Metrics and MAQL

How do you count records with effective dates

If I have a `users` table with effective dates, so the columns like this:id, start_date, end_dateAnd I want to count the users that were active anytime in a filtered date range in sql I would just doselect count(distinct(id)) from users where start_date <= {end of range} and end_date > {start of range}The values {end of range} and {start of range} would be based on whatever date filter the user selected in the dashboard - for example if they selected YTD {start of range} would be 2023-01-01 and end of range would be 2023-02-20I can’t figure out how to do this in the metrics editor though. Is it possible?

1
Moises Morales
GoodData Employee
1 month ago
M
Mark PetersonNew Participant
asked in Metrics and MAQL

Is it possible to create a Metric for the "last known value"

I’ve got a strange one that I’m wondering if anyone has seen and been able to find a way around.  I’m trying to build a dashboard which shows headline Economic stats from various datasets.  The problem is, the datasets are all updated at different frequencies, some monthly, some quarterly.  The figure I’m trying to display is the “most current value” for each of the metrics.  Some are current from this month (Feb 2023), others are current from last month (Jan 2023), and others are current from three months ago.  Without having to configure the KPI or Metric for a “static” date, can anyone think of a way of doing this?  Below screenshot shows an example of a couple of the datasets.  

2
Francisco Antunes
GoodData Employee
1 month ago
JeffC
JeffCParticipating Frequently
asked in Metrics and MAQL

Rollup/ Aggregation Wrong

I have a simple table that has an attribute of ‘Resource Direction’ and an attribute of ‘Call Sid’.  I’ve created a metric called Actual Calls Offered, and am trying to select and count all ‘Call Sids’ where Resource Direction = ‘inbound’ OR ‘Resource Direction = ‘inbound with attached outbound’.  The value comes back as 135 records, when I query the database I have 142.  When I add the insight, I get the wrong value of 135, but when I add a row to split the data, the row level data is accurate.  114 + 28 is NOT 135 as shown in the screenshot. SELECT COUNT(Call Sid) WHERE (Resource Direction = inbound OR Resource Direction = inbound with attached outbound)Edit - I tested in insights without using metrics and see the same roll up behavior that matches my metric, but seems accurate when SUM is utilized. 

8
Joseph Heun
GoodData Employee
1 month ago
P
Preetham ThangammaKnown Participant
asked in Dashboards and Reports

INSIGHT design in the image

Hello,   i have a reference insight and i don’t know how the ‘Policy Count - SP year ago’ in the metrics are calculated and why the same column is unchangeable as in to view the calculations done for the same column.Please do help me to solve this issue to create a same insight in another workspace and consider the attached image too!! Thank you

2
P
1 month 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 month ago
P
Preetham ThangammaKnown Participant
asked in Dashboards and Reports

where does the data (empty value) column value appears from in the insight?

Hello, can u please let me know why 'empty value' is dispalyed in the attached image. i thought because of null value in the source that is the sql table but there is no null value in the sql table for featureid column!! Thank you

1
Iva Gasparekova
GoodData Employee
1 month ago
mares
maresParticipating Frequently
asked in Dashboards and Reports

Start End Date bar chart by Months

Hi Folks !I'm reviewing GoodData, and of course I'm here cause I have some really basic questions.To make the example easy, I'have a data set with 3 fields user, start end date (subscriptions base data). I'm trying to build a simple chart in which each MM-YY as (X axis) and count the active subscriptions (Y axis). user start end 1 jan-22 dec-22 2 jan-22 mar-22   result would be (bar char): 2 2 2 1 1 jan-22 feb-22 march-22 apr-22 … rest of months ...   The issue I'm encountering is that GoodData is associating the date with only 1 date field either start or end. How can achieve this?I read date-attribute-arithmetic, if I understood correctly that won't solve my query, as it calculates the duration by a given granularity 

8
mares
1 month ago
henrique santos
henrique santosNew Participant
asked in Dashboards and Reports

How to resolve some records showing empty value on a analytics.totvs report?

Hello, I recently created a report that shows an empty value (valor vazio) in two specific columns of some records, even if this data exists in the database and is in the CSV used in the ETL process, does anyone have any idea what it could be? Thanks anyway. 

2
henrique santos
1 month ago
Jay Finegan
Jay FineganNew Participant
asked in Metrics and MAQL

RUNSUM doesn't seem to like intermittent data

GoodData Enterprise;Metrics in play include:# Incidents_Recordable: SELECT IFNULL(COUNT(incidentID),0) WHERE isRecordable=1 AND Date (Event) BETWEEN _Timeline_Start AND _Timeline_EndYTD Recordables: SELECT IFNULL(RUNSUM(# Incidents_Recordable), 0) BY Month (Event) WHERE Date (Event) BETWEEN _Timeline_Start AND _Timeline_End Here is the data table where the issue manifests itself:The highligted elements in the data table show the YTD count dropping to zero, rather than preserving the YTD from the previous period. Cleveland, for example, should remain a 2 through March and April, as the YTD count was 2 at the end fo February. I’ll note that if Cleveland had an incident in May (outside the range of the image), the YTD count would (and does) correctly reflect the value of 3. Analysis shows that these “gaps” occur whenever a month has no incidents (and there is at least 1 incident in a predecessor month). It is clear that the RUNSUM function works correctly when there is an essentially cont

5
B
4 days ago
Welcome to the GoodData Community!Cookie settings