text in chart

[Anonymous]

Hi Guys,

I have a chart in which two expression is there(grouped expression) i want to put unit of exp in the chart. but in my chart one expression has count as unit and other expression has Date as unit. How should i do that

[andrefpc]

Hi Rajashmita! You want the value that appears in the chart to be the sum of the 2 expressions you have?

[simondachstr]

Have you had a look at the number formatting tab in the chart properties? That should work..

[datanibbler]

Hi Rajashmita,

so you have two different dimensions or two expressions?

=> The latter (expressions) you could do by putting one scale on the left, one on the right ("axis" tab)

=> The former can only be done if they are mutually exclusive - you could conditionalize them, but then of course you could only show one of your expressions.

HTH

Best regards,

DataNibbler

[Anonymous]

i have two expression..both has different units. one displays Max(Date) and other display count(Id) , which are grouped. If i select Max(Date) Date should be displayed in chart text and when i select Count(Id) it should display count as unit in chart text. I am using If(GetcurrentSelection(Max(Date)),'N','D') but it is taking only else values that is D....

[jagan]

Hi,

There is no option to get which expression is currently used in Expression group, so the workaround for this is create two charts and provide buttons to toggle or use container and give two charts.

Or

In Expression, Label give your expression instead of some name and it will display in the chart and enable Show Title in Chart option in General tab.

Regards,

Jagan.

[andrefpc]

You can use ad hoc dimension....

MetricsOptions:

LOAD * INLINE [metricsNo, metrics

1, Date,

2, Count,

];

MetricPickOne:

LOAD DISTINCT

       metrics as _metricPickOne

RESIDENT MetricsOptions;

Then create a listbox with _metricsPickOne

On your chart, make your expressions conditional, one for the Date and one for the Count, like this:

=SubStringCount(Concat(_metricPickOne, '|'), 'Date')

and the same for the count, that way, when you select date on your list box, the date expression will appear in the chart. Is this what you are looking for?