Add counter

[Anonymous]

Dear reader,

I want to do the following, when a line (an order for example), appears for the 1st time in the dashboard, I want to give it the mark "New". When it is 1 day later, I want to see it is in 1 day, so give it the mark 1, day after this day becomes 2, and so on.

Any ideas someone?

[Anil_Babu_Samineni]

What "Line"

[Anonymous]

a new line of data/information, were the Order is the unique key

[Anil_Babu_Samineni]

Do you have Date field?

[MarcoARaymundo]

BASE:

LOAD

If(Date(Today(), 'YYYYDDMM') - Date(DATE, 'YYYYMMDD') = 0,

'New',

Date(Today(), 'YYYYDDMM') - Date(DATE, 'YYYYMMDD')

) as Status,

Date(DATE) as DATE,

Upper(DESCRIPTION) as DESCRIPTION,

Num(VALUE) as VALUE;

LOAD * INLINE [

DATE,INVOICE,DESCRIPTION,VALUE

01/10/2017,1,XYZ,100

02/10/2017,2,YZX,50

19/10/2017,10,ZYX,150

];

[MarcoWedel]

please post some sample data and your expected result.

[Anonymous]

Yes, but this is not the correct one, so I need to amend the dashboard and the data a bit, but that is not the problem.

[Anonymous]

Thanks, gonna try this one out later today

[Anonymous]

Hi Marco,

Please see attached what I want to achieve.

[Anil_Babu_Samineni]

May be this?

Date(Today(), 'DD MMM YYYY') - Date([Date insert in list],'DD MMM YYYY')