Several values in a chart on the GUI - display only the first?

[datanibbler]

Hi,

in a chart (straight table) there are, for certain combinations of the dimension_values, several possible values to display. The values are dates, all numeric.

The one I would want displayed there is always the first one (the smallest value).

=> Is there any possibility to have only that one value so that it can be displayed?

Thanks a lot!

Best regards,

DataNibbler

[marcus_sommer · Accepted solution]

Hi DataNibbler,

maybe with min() or rangemin()?

- Marcus

[datanibbler]

Hi Marcus,

rangemin sounds good. How would I then pass all possible values (a field from a table) to that function? Like

>> rangemin(Table_A.Date) <<?

P.S.: OK, that seems to work - funny, now it seems to work with a simple min(Table_A.Date) - just what I had tried before ...

Thanks a lot! I think we have it. I'll wait a few minutes to make sure this is right and then I'll mark your answer as correct.

Best regards,

DataNibbler

[tresesco]

If it is about a single field values, min() would be ideal. Could you please explain a bit more with a small example?

[marcus_sommer]

Not quite - rangemin needs several parameters like: rangemin(value1, value2, value3). If you asked in this way I think you couldn't really fill rangemin in this way so that concat might be better, like:

subfield(concat(Table_A.Date, ',', Table_A.Date), ',', 1)

- Marcus

[datanibbler]

Hi,

the problem appears to have been a set_expression in the formula. The colleague told me that was not strictly necessary at all and without that it seems to work. So it seems that all is fine now.

Thanks a lot!

Best regards,

DataNibbler