Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Show the value of a column in a text visualization.

Accepted answer
57
Views
2
Comments

H,

Is it possible to display a fixed text and a column value in a text visualization. I've tried using ${valuesForColumn:COLUMN} and also {column_name} but this does not show the column value. This is the use case:

  1. I have a data action that takes me to Canvas 1 and pass all values e.g Sales amount
  2. When I'm in Canvas 1, I need to show a text like "Total Sales :" {Sales column} and be able to format it.

How can I do this?

Thanks for your help.

Best Answer

  • Hi @Erikaa-Oracle ,

    TextBox visualisations support parameters. You can reference them with the following syntax: @parameter("parameter name")('default value')

    You have to define parameters in your target workbook, and eventually bind them to a filter or use a logical SQL to dynamically update their value.

Answers