Recent activity
Subscribe to this feed
ZD replied on July 22, 2009 03:36 to the problem "Cannot create trial account" in GoodData:
What browser do you use? Can you take a look at this post http://getsatisfaction.com/gooddata/t... ?
ZD replied on July 03, 2009 09:35 to the question "How do I add a count metric?" in GoodData:
First, thank you for the excellent feedback!
The COUNT metrics are a bit more tricky. We are still scratching our heads how to make them easier to use.
Let me start with a simple visualization of your model. The picture below shows a structure of your data.

The COUNT aggregation function can accept one or two arguments. The first one is what you want to count. You are counting distinct values of an attribute (non-countable field). You choice was right, you used the ID. As the ID is unique for each call, the COUNT(ID) computes the total count of all calls. This number is always the same, no matter in what report you place it. No matter how you filter the calls (e.g. by PHONE # or EMPLOYEE). The COUNT focuses solely on the ID and always returns the same number.
Then you wanted to do something a bit different. Let's say that want to count calls from specific employee. Then you need to explain what you want to count if you put an EMPLOYEE.NAME together with COUNT(ID) to a report. In your case, you want the system to count the number of calls that the employee made. This is the point when you need to use the second COUNT function argument. Our system creates a special "Facts of X" attribute that represents an entity (e.g. calls, opportunities etc.). This is exactly the attribute that you need to use to tell the system, that you want it to count calls when you put COUNT(ID) and EMPLOYEE.NAME in your report. So the final formula is COUNT(ID,Facts of CALL).
You need to use the Advanced metric editor to create such metric. Please click advanced link in the WHAT part of the Slice & Dice and then follow the Custom metric link, give your metric a name (e.g. Count of Calls) and write the metric definition: SELECT COUNT(ID,Facts of CALL) . Please note that you'll need to select the attributes ID and Facts of CALL from the right list (you still can't type the names unfortunately). I would recommend to make this metric global in order you can reuse it in your other reports.
Regarding the mapping of multiple dates in our UI. This is something what we are working on right now. You should be able to do such multiple mappings in our UI very soon.
I would be very much interested in talking to you about your experience with our product. I hope that your feedback can help us to make it far better in terms of usability. Can you please send me an e-mail at zd@gooddata.com? Thanks a lot!
ZD replied on May 15, 2009 16:30 to the idea "Portable ETL and Reports Layer" in GoodData:
ZD replied on May 13, 2009 13:11 to the idea "CSV Upload Hints" in GoodData:
ZD shared an idea in GoodData on May 01, 2009 22:13:
CSV Upload HintsHere are few hints regarding CSV file uploads to Good Data:
* Remove the thousand separator commas from all numbers (use the plain #######.## format)
* Don't use the scientific number format (e.g. 12E3)
* Remove all currency or percent characters from your numbers
* Remove all empty trailing rows from your CSV file
* Save your CSVs as "Windows CSVs" on Mac
* Don't use the Finder's "Compress File" on Mac, it adds some hidden files to the archive. Use command line utilities on Mac or avoid compression
* Avoid special characters like umlauts and other diacritics
We know these limitations are lame. We are working hard on removing them very soon. Thanks for your patience
ZD set one of ZD's replies as an official response to "Upload issue with dollars" in GoodData
ZD replied on April 27, 2009 20:55 to the problem "Upload issue with dollars" in GoodData:
Davis,
You are right, we can't automatically strip any alpha characters from a number. This is something what we have just implemented and will be deploying very soon in our data cleansing pack.
Currently you unfortunately to remove all non-numeric characters like %, currency symbols (e.g. $) from your CSV. You also need to remove commas as the thousands separator.
I apologize for the inconvenience. It'll be better soon.
Regards
ZD
ZD replied on April 25, 2009 00:08 to the question "Upload Api, Data-size limits" in GoodData:
Alvin,
ad a) we don't have good public benchmarks of our service available. I can offer you some assistance with loading larger amounts of data and trying out your specific usecase. The performance very much depends on reports, number of rows, columns, data types etc. Generally we can handle the performance level that you are talking about.
ad b) We have some Python examples how to use our REST API to automate the data uploads. I can provide you with this example.
ad c) There are upload limits and project data size limits that apply to our community projects. These are not 'hard' technology limits. We can give you access to environment that doesn't have any limits (except the limits of underlying technology)
d) Integrating snowflake schema is easy. We have numerous toold that we use internally for migrating star schema to our project.
I'm curious about your use case. I think that we can both enjoy a short phone call. Please let me know if you are interested at zd at gooddata.com.
Thanks
ZD
ZD replied on April 02, 2009 04:24 to the problem "Captcha doesn't render in IE8" in GoodData:
ZD replied on March 27, 2009 15:03 to the problem "Adding Custom Metric to Existing Folder Results in New Folder" in GoodData:
ZD replied on March 25, 2009 10:40 to the question "Dashboard table (Iframe) does not load in IE7" in GoodData:
ZD replied on March 20, 2009 21:27 to the question "Table resizing issues" in GoodData:
ZD replied on March 20, 2009 20:17 to the question "How do you filter a dashboard table appearing in an iframe?" in GoodData:
You are right, currently the embedded reports are not interactive. We are working on the interactivity in this sprint (first of three weeks) and we hope that we will be able to deliver more interactive dashboards in 5 weeks from now. We are including following features:
* Predefined drill down. The author of the report can specify the way how the dashboards users can drill down (by double-clicking on attribute heading or value).
* Predefined break down. The author of the report can specify the way how the dashboards users can break down metric values (by double-clicking on metric value).
* Sorting via the up/down arrows.
* Simple filtering (exclude / show only).
Hopefully this is going to be enough for what you need.
ZD
ZD replied on March 19, 2009 16:19 to the problem "Error with Entering and Saving Comments" in GoodData:
ZD replied on March 19, 2009 15:55 to the idea "Need Refresh Report Button" in GoodData:
ZD replied on March 14, 2009 05:36 to the question "Report Change Indicator" in GoodData:
ZD replied on March 14, 2009 05:30 to the problem "Problem adding filter while creating a report" in GoodData:
ZD replied on March 06, 2009 14:57 to the question "Good Data just got a brand new facelift!!" in GoodData:
ZD replied on December 24, 2008 05:53 to the problem "Field name edit boxes don't disappear when switching screens" in GoodData:
ZD replied on December 17, 2008 10:57 to the problem "Incorrect import of tables in UTF-8" in GoodData:
| next » « previous |
Loading Profile...


