show only the last value in a graphic

[#1]

is it possible to show only the last value (written in the Graphic):

Thanks....

[datanibbler]

Hi Ingo,

so you want this whole x-axis (1990 to 2004), but only the value for 2004 visible?

How about editing the "background colour" of the chart (formula_properties, click on the "+" sign) to be

- blue for the last dimension value

- white otherwise

HTH

Best regards,

DataNibbler

[Nicole-Smith · Accepted solution]

For example, if your dimension is Year and your expression is sum(Sales), you need to set up a second expression that looks like the following:

if(Year=$(=max(Year)), sum(Sales), '')

An example is also attached.

[#4]

Hey,

thank you for the quick response.

The line should be visible, but only the last value should be shown in the graphic:

[#5]

Hey Nicole,

its working....thank you very much for the correct solution.....great!!

Best regards...

[Nicole-Smith]

I'm glad it works

[#7]

Hi Nicole,

sorry, one more question. In the following case it doesnt work (second Graphic). Do you have any idea? Thank you in advance.

Best regards...

[Anonymous]

Hi Ingo,

It is a because of a problem with your Date format.

try this:

if(num(Datum) = $(=num(max(Datum))), Umsatz_Auto, '')

[#9]

Hi,

thank you very much . In the above example your solution is working. Do have any idea for the following

one?Is the date Format, the Variable or the group by period the Problem?

[Anonymous]

Hi,

I think you'd better change your model to create a separate calendar from your model, like this:

FACT:
LOAD
     Anliegen_Nr,
     [Vers. Person],
     Eingangskanal,
     Anliegen_Status,
     A_Eröffnungsdatum,
     A_Erledigungsdatum,
     A_Abschlussdatum,
     ANL_versch_Flag,
     ANL_versch_Anz,
     ANL_erl_min
FROM
C:\Users\p14890\Desktop\test.xls
(biff, embedded labels, table is [Sheet1$]);

CALENDAR:
LOAD DISTINCT
  A_Eröffnungsdatum      as Date,
  Month(Date(A_Eröffnungsdatum))    as Mois,
  Year(Date(A_Eröffnungsdatum))    as Annee,
  'Q'&Ceil(num(Month(Date(A_Eröffnungsdatum)))/3) as Trimestre
RESIDENT
FACT:
;

Then you can work easily on the year, month or date as you want.