To GoodData homepage

Topics started by Ron Borenstein

2 Topics

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
R
Ron BorensteinNew Participant
asked in Data models

CSV missing values

Hi, I am new to GoodData and trying to get started, but having an issue I can’t get around.I am uploading a csv, created using a jupyter notebook. The file is 15.5mb and has 56k rows. Everything seems fine when I upload it, but when I try to create my first insight, the data is different than in the file.I have a measure called `timeSpent` . When I sum `timeSpent`  the number in GoodData is significantly lower than it is in the file.sum of timeSpent in GoodData - 1,849.10 sum of timeSpent in the file - 19,670,743.42How can I check what’s wrong? 

2
R
2 years ago
Welcome to the GoodData Community!Cookie settings