Recent activity
Subscribe to this feed
Eric Wikman replied on July 07, 2009 15:42 to the question "What does "superset values are not unique" mean?" in GoodData:
Hi Ray,
Thanks for the quick response. You are perfectly clear, I understand what you are saying, and your assumptions are correct in that there is a unique id field in the employees table that I am using in the mapping from two other tables (the calls and opportunities tables). However, I was already using the "overwrite previous uploads" checkbox because I was not trying to add new data, I was trying to update old data. I just did it again to double-check that fact. And there are no duplicate rows in the CSV file, it is literally the same csv file I used the first time, except I changed the team id's, but I don't have the team ID mapped in any way. I just changed each of the team ID's to be unique (1/2/3/4/5/6/7) to see if that could be the issue, but it wasn't.
This is just sample data, no corporate secrets, so I'm happy to share the CSV file or share the project.
Eric Wikman asked a question in GoodData on July 06, 2009 22:50:
What does "superset values are not unique" mean?I'm trying to refresh the data in the employee's data that I had previously uploaded by using the update data routine but it is failing with a message of "superset values are not unique". I'm using the exact same CSV file from before but I changed the default team for each user in a text editor. So the new csv file has the same number of columns and row headers as the previous one. However during the initial import I did tell gooddata to ignore some of the columns and I also renamed the display name of each field to make it look nicer, I don't know if after doing that future CSV files need to use the new display names or the new amount of columns. There is also the Mapping Base for Employees attribute that shows up under the upload data page that didn't use to exist but was created when I mapped other tables to this one. Any idea what I may be doing wrong?
Eric Wikman replied on July 06, 2009 21:45 to the question "How do I add a count metric?" in GoodData:
Eric Wikman marked one of ZD's replies in GoodData as useful. ZD replied to the question "How do I add a count metric?".
Eric Wikman asked a question in GoodData on July 02, 2009 20:53:
How do I add a count metric?I am testing out using Good Data BI with SugarCRM. I've added three tables from Sugar to GD, the calls, opportunities and employees. I mapped Calls.Assigned_User_ID to the Employee.ID and I also mapped Opportunities.Assigned_User_ID to Employee.ID. For Opportunities GD detected the Amount field was a countable object and added the Sum metric to it, and in calls it did the same for Calls.Duration_Minutes. Now I can build a report that shows me the sum of the amount and the sum of the duration minutes from opportunities and calls broken down by employee user name and sliced by year and quarter. That is something that I can't do in SugarCRM Pro (although I can in Sugar Ent, but it is hard to train a user how to do it). But what I really want to be reporting on is the count of calls, not the sum of the duration in minutes of calls. But GD didn't auto-create any count metrics, so I'm trying to create my own. If I try to create a count metric on a countable field then I get an error when I try to use that field on a report, so instead I've had to create a count field on an attribute, I chose Calls.ID. Now I can build a single dimension report on how many total calls are in the database, but I can't edit the How to do anything useful. The only option I have for How is to use the Call.ID, which then instead of saying there are 50 total calls, it makes 50 rows and has a count of 1 for each row. What I want to know is how many calls each employee made, and once I can do that, I'm hoping to be able to add back the sum of the amount of the opportunities and then subdivide by date (year/quarter).
I'm not sure if I'm adding the count to the wrong field or what my issue is. How do I add a count metric to the calls data that will allow me to report on the count of calls for each employee?
Also, as a separate question... when I did the import, there was only a single date field recognized, but normally there would be more (it recognized the call date, but not the create date or modified date, and I understand why (the time was present)), so if I had the call date as well as the create date, how would GD know which date field to use when I tell the How to use the Quarter of the Year attribute?
Loading Profile...
