3 Replies Latest reply on Jun 14, 2018 5:25 AM by francesco.fincato.1

    Change Format of the Last Mark in a Graph

    francesco.fincato.1

      Hi everyone!

       

      I have this graph in which I would like to avoid showing the very last Mark as a line. Instead, I would like to have both of the last Marks (for Sales and Order ID in this sample dataset) showing up as Points (as they are partial data and I don't want the line to give an idea of a "bad trend").

       

      I made several attempts among which using this formula:

       

      if (DATETRUNC('month',[Delivery date]) <> [Month Chosen]) then [Order Number (ID)] else null END

       

      However, it is always showing the Mark in the very last month, even if it will be just a 0. I guess I am missing something very easy here.

       

      I cannot filter it out, because in my case it won't show up another value that I would like to be shown in the overlapping graph (a forecast I made up for the same month).

       

      Please find attached a sample workbook from which I tried to give an idea of the situation I have.

       

      Thank you in advance to anyone who can help.

       

      Cheers,

       

      Francesco