Display the last data point

[#1]

Hi all

Please how can I display the last data point of the following expression?

=sum({1<Sale_Date={">=$(=Max(Sale_Date)-12)<=$(=Max(Sale_Date))"},Product={'Product 1'}>} Sales)/

Count({1<Sale_Date={">=$(=Max(Sale_Date)-12)<=$(=Max(Sale_Date))"},Product={'Product 1'}>} Sales)

Regards

[sunny_talwar]

Not sure where you are trying to display it? Can you elaborate a little?

[Anonymous · Accepted solution]

you are talking about max(Date) only, like this?

=sum({<Sale_Date={'$(=Max(Sale_Date))'},Product={'Product 1'}>} Sales)

/

Count({<Sale_Date={'$(=Max(Sale_Date))'},Product={'Product 1'}>} Sales)

It will give you max date values only

[Anonymous]

also make sure format of both Sale_Date and =Max(Sale_Date)) should be same

[#5]

Hi Sunny T,

I am trying to achieve want was done this:

Display data point values on line chart

Re: Display data point values on line chart

JohnW 02-Sep-2011 12:20 (in response to aryehgros)

The reason the legend is displaying "Value" twice is that I stated one of the instructions VERY poorly.  I'd said "Only display data values on the second expression."  I really meant two things by this - on the first expression, do not display data values, and on the second expression, ONLY display data values.  In other words, remove the checkmark next to "Line" for the second expression.  I definitely should have written that differently.

The example is also using a variable, which I wouldn't bother with, and the example fails when you don't select any date.  You can fix that by changing the expression to what I said to use, which in the context of this example would be this:

if(Date=max(total Date),Value)

Heh, nope.  One minor error.  It's displaying the nulls as '-'.  I didn't expect that.  So change it to a space, I guess:

if(Date=max(total Date),Value,' ')

That works.  Thanks for building the example, Erika.

Edit:  Oops, I didn't remove the variable like I suggested.  I've updated the attachment to do so.  Here's the new expression for Value:

sum({<Date={"<=$(=max(Date))"}>} Value)

[#6]

Hi Balarj,

Your suggestion worked. The only issue is other data points are showing dash ("-") . Please how can I remove this?

[Anonymous]

Try suppress null values under dimension tab

[#8]

Hi, suppressing null values did not work.

[sunny_talwar]

Would you be able to share a screenshot of what you are seeing right now?

[Anonymous]

Agree with Sunny, share a snapshot or sample, if possible?