Hi Henry, We can count the Frequency of a Value in a Column by, modifying the table calcs for subtotals described here then, we can use the table calc below: count(${view.field}) - match(${view.field}, offset(${view.field}, count(${view.field}) - row...

Sara_Guzman: Doc Hi @sani It is possible to shorten the URL. Could you please visit us at help.looker.com or come to our chat support? There is more info and details we need in order to address this. Best, Sara

Using the url we can change the model, but we cannot change the connection. In order to dynamically change your connection, you can use the user attributes in the Additional Params field, of the Connections page in the Admin section of Looker, as sho...

Hi @sani Could you please provide us with more details on how are you trying to change the connection using the URL? I can see that some browsers/servers have problems with URLs over 2K characters. Could please you tell me the length of your URL? you...

Hi @Harika1, in order to debug what is happening in your case, we need more info on this. Could you please send an email to help.looker.com with more details on that specific query, or come to our chat support? From there we could help you more.