6 Replies Latest reply: Nov 9, 2017 4:20 AM by Christian Schulz RSS

    Only show values of the last date

    Christian Schulz

       

       

      Hello everybody,

       

       

       

      I have a quick question for you.

       

       

       

      I want to create the following measure in my bar chart.

       

      The sum of the column 'Value', but only the last uploaded values.

       

       

       

      Background: new values are added to the data table at regular intervals, the old ones remain.

       

      For each load, the date of the load time is written for each new line. As an an example:

       

       

       

       

      Material

      Value

      • assets.day

      ABC

      2000

      2017-01-01

      ABC

      2500

      2017-02-01

      ABC

      3000

      2017-03-01

      ABC

      2750

      2017-04-01

       

       

       

      The measure should recognize that I only need the last (or in other words, the maximum) value for the column 'day'.

       

      My formula for this:

       

       

       

      Sum ({< assets.day = {$ (= max (assets.day))}>} Value)

       

       

       

      Although I do not see a syntax error, all values remain at 0 in the chart.

       

       

       

      Can anybody help me further?

       

      Many Thanks

       

      Chris