Escrever um comentário...
0/9000
AvisoTableau Engineers foi arquivado. Para reativar, contacte o proprietário do grupo Philip Lacey.
Grupo em destaque
Tableau Engineers
I have a toggle with a custom step having two values display and value .
Then I have a chart below which shows line chart by country
Now in my toggle I have Bar and Line as display and hbar and line as values. I am trying to replicate the example from Einstein learning .
I am doing a binding on the chart widget Visualization type property and "hbar" is replaced by below :
"visualizationType": "{{cell(Static_Step_1.selection, 0, \"Value\").asString()}}",
here "0" is hardcoded on the second parameter , but when i choose line or bar it automatically shows me the right chart , so binding replace the selected value , but 0 on second parameter refers to row 0 on static item right ? so how does it work for me .
Also for testing I tried to replace the above expression with column instead of cell .
{{column(static_1.selection, [\"value\"]).asObject()}}
but when i preview and select line it errrors out and i cannot go back to the dashboard.
Any suggestions is appreciated.
3 respostas
Column would return an array object, and you need a string for the chart type, so I would expect to see an error. cell is the easiest way to pick one value out of the column.
I have two columns in the recipe that is based on merging a contact (base contact) with another contact (leader contact) based on the reportsToID field. Now I have a rating field in the base contact and a rating field in the leader contact. My requirement is to create a new field that needs to based on the logic that if the base contact rating is not empty, leave it with the existing value and if it is not empty, get the rating from the leader contact.
I am trying to put this formula in the transform node of the recipe
case RATING__c when '' then RATING__c else "LeaderContact.RATING__c" end
This is not working. Is there a different way for us to check for spaces or null on a case statement within the transform node of a recipe?
4 respostas
@Chidu Subbiah Use the transform node and then create a custom formula that looks like the below;
case when BaseContact.Rating__c is not null then BaseContact.Rating__c else LeaderContact.RATING__c end
Ensure both fields are either dimension or measure datatype to determine how you set/populate your output field. Also make sure the blanks in the fields are recognizable as nulls and not populated with any other character.