How to get 2 column values on Google Map tooltip?
18 January, 2012
I need to have a report with a Google map showing on a tooltip something like "Column1: XX, Column2: YY"
XX, YY - numeric values, Sum by date.
Since google map takes only 1 column as a tooltip I am trying to build a "tooltip column" to feed it to the map.
Here is where I stuck -
I can use Advanced formula to concatenate 2 columns and get tooltip like: "Column1: XX", but it does not allow me to concatenate more columns.
I cannot convert values of column1 and 2 to varchar before report builder since those values are summarized in report based on filter.
Is there any other way to make this sort of column?
it is so easy in sql, but I don'e see in YF ability to feed freeformed sql as column definition.
Using freehand sql as a report does not work for me, since I need filters by date ( between) and by other parameter in list of defined values.
XX, YY - numeric values, Sum by date.
Since google map takes only 1 column as a tooltip I am trying to build a "tooltip column" to feed it to the map.
Here is where I stuck -
I can use Advanced formula to concatenate 2 columns and get tooltip like: "Column1: XX", but it does not allow me to concatenate more columns.
I cannot convert values of column1 and 2 to varchar before report builder since those values are summarized in report based on filter.
Is there any other way to make this sort of column?
it is so easy in sql, but I don'e see in YF ability to feed freeformed sql as column definition.
Using freehand sql as a report does not work for me, since I need filters by date ( between) and by other parameter in list of defined values.
Hi,
Unfortunately there is no way currently to include multiple lable on a google map, you will only be able to specify a single field for the label.
So in your instance, you would need to concatenate all 4 columns into 1 field.
If you are having issues with concatenating these fields you can use an analytic function to combine 2 columns (irrespective of data type) using an analytic function (see screenshot below).
Though when concatenating multiple columns you will need to use a calculated field, which is easy to do at the report level if the fields are text fields, if the data types differ you will need to create a calculated field at the view level which allows you to use convert functions.
An enhancement request has been created that will allow multiple labels when using Google maps (TASK ID = 108930).
Regards,
David
Unfortunately there is no way currently to include multiple lable on a google map, you will only be able to specify a single field for the label.
So in your instance, you would need to concatenate all 4 columns into 1 field.
If you are having issues with concatenating these fields you can use an analytic function to combine 2 columns (irrespective of data type) using an analytic function (see screenshot below).
Though when concatenating multiple columns you will need to use a calculated field, which is easy to do at the report level if the fields are text fields, if the data types differ you will need to create a calculated field at the view level which allows you to use convert functions.
An enhancement request has been created that will allow multiple labels when using Google maps (TASK ID = 108930).
Regards,
David