Topics started by andybuchanan
Currently, our corporate policy on Google BigQuery requires a billing project ID. The dataset that the data lives on, not many (if any) have direct query access to the Project ID. Query access is given to individuals via Billing projects. That way the compute costs can be divvied up based on who made the query. I have spoken with Support and others familiar and have been told it is not possible with the current connector / integration and must have direct query access to the Project ID provided in the connector setup. Our policy will not allow us to leverage the Connector as is due to this, and therefore requesting that the ability to specify a Billing project ID (optional) is added to the connector configuration for the Google BigQuery setup. We utilize other tools, such as Tableau which allow for this - https://help.tableau.com/current/pro/desktop/en-us/examples_googlebigquery.htm (search for “billing” on this page.
Currently Duration (in min) is stored as a number. This number on an individual timeline basis may be fine, although when trying to sum up or count hours spent against a given client, or by CSM over last 7 days, Month, etc… # of Minutes quickly becomes a meaningless number. For reporting on a dashboard, we were able to create a widget that SUM the “Total Hours” (Duration in MIN / 60, 2 decimal places). However, when drilling into the formula field, there is no setting to specify how many decimals a formula field should have in a drill down report. The widget looks like this - Summary of “Total Hours”This is what the drill down looks like. Total Hours has no decimals and rounded to 1 or 0. Two possible fixes:Ability to summarize a field into Hours/Minutes (not just by Thousands, Millions, etc.). In this way the Summary widget could be built off the sum of duration in minutes, then the drill down report would also use the same field (thus negating the need of a formula field)
When using the relationship / customer search, the current limit is only 4 fields. We currently have a large number of fields as well as a number of different relationship types that would like different criteria. Ultimately, would be nice to have some sort of way to have a different search for each relationship type, but at a minimum need more fields to display in the search. These fields do NOT need to be searchable, as they are just attributes that helps determine the right product card. For example, CSM, Tier, Relationship Status (Active, Churned, Inactive), among others that would be helpful, but wouldn’t be something that you’d necessarily search for. Secondarily, when searching would be helpful if there was a way to edit the text / colors if a product card and/or customer is churned, active, etc. Right now it’s very tough to identify in the current search when there are multiple cards for a single customer that are very similar.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.