Recently active topics in Good Data

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?

I would like a gauge as indicator (a meter, like in a car dashboard, with a 'clock' and a needle). Preferrably with area's of status (Red, Amber, Green), that can be found in the table.
Example:
I have a data set where I have in one row an item, the month, a progress indicator and a target for that month. I want to have, for this item, the progress indicator shown on a 'clock', where there are 'zones' projected in red, amber, green for the value. Say if progress in mont June is 25 %, and the planned progress is 20, I want it green. If the planned progress is 27, I want the indicator in the amber zone, and if it is 40, I want the indicator in the red zone.
Like in the image added, where the clock runs from 0 to 1, the indicator is at 0.4; and the red zone runs from 0 - 0.1, the Amber zone from 0.1 to 0.3 and the green zone from 0.3 to 1.

Is this possible?

Hi, how can i see when you have uploaded the latest CF stats? I can now only see one mark (27th).
Regards,
Martin

The signup confirmation email never arrived - how do I resend it or change email address?

Hi guys, can I connect to Amazon SimpleDB or S3 as a data source?
For example I would like to capture changes on Force.com, put them in an Amazon SQS queue, load them in S3 or Simple DB together with other data and report on it with a platform like GoodData.

Kind regards,

Arjen