Semantic Type

14 views
Skip to first unread message

Larissa do Val Siqueira

unread,
May 3, 2024, 12:52:18 PM 5/3/24
to looker-studio-developers-forum
Hello,

I am trying to create a connector between Cube and Looker Studio based on an existing one. I had a problem with data granularity, where Looker was not w=calculating well when changing it to Month or Week for example. To work around it, we created several time dimension fields with all the granularities we want. However, they all come with Date as Semantic Type. We wanted to add different Semantic Types depending on the date granularity. We tried doing it adapting the following function: 

function cubejsTypesToDataStudioTypes ( cubejsField ) {
var types = {
number : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
count : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
countDistinct : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
countDistinctApprox : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
sum : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
avg : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
min : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
max : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
runningTotal : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
time : function () {
return "YEAR_MONTH_DAY" ;
},
string : function () {
return "TEXT" ;
},
boolean : function () {
return "BOOLEAN" ;
},
imageUrl : function () {
return "URL" ;
},
link : function () {
return "URL" ;
},
id : function () {
return "TEXT" ;
},
geo : function () {
return "LATITUDE_LONGITUDE" ;
},
};
return types [ cubejsField . type ]( cubejsField );
}

to

function cubejsTypesToDataStudioTypes ( cubejsField ) {
var types = {
number : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
count : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
countDistinct : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
countDistinctApprox : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
sum : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
avg : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
min : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
max : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
runningTotal : function ( cubejsField ) {
return cubejsNumberType ( cubejsField . format );
},
time: function ( cubejsField ) {
if ( cubejsField .title.includes("MONTH")) { return "YEAR_MONTH"; } else if ( cubejsField .title.includes("WEEK")) { return "YEAR_WEEK"; } else if ( cubejsField .title.includes("YEAR")) { return "YEAR"; } else { return "YEAR_MONTH_DAY"; } },
string : function () {
return "TEXT" ;
},
boolean : function () {
return "BOOLEAN" ;
},
imageUrl : function () {
return "URL" ;
},
link : function () {
return "URL" ;
},
id : function () {
return "TEXT" ;
},
geo : function () {
return "LATITUDE_LONGITUDE" ;
},
};
return types [ cubejsField . type ]( cubejsField );
}
But when I test it I have NULL values on the graphic. Is it possible to set Semantic type in some way?

I thank you all in advance.
Regards,
Larissa
Reply all
Reply to author
Forward
0 new messages