About goncalosilva123

goncalosilva123 · ‎03-08-2021

Thanks for all! Finally, how can I change order based on the most recent date and number (2021-01-20, descending) and also change the cell color based on the value? Ex: -> If the cell value is bigger than 5, puts cell color red, If cell color is between 0 and 5, puts orange, if is less than 0, puts green. -> 2021-01-20 31 25 13 5 ################################################################# The goal! 2021-01-19 2021-01-20 Dif_19_20 Item 1 29 31 -2 (31-29) (Green) Item 2 37 25 -12 (25-37) (Green) Item 4 10 13 3 (13-10) (Red) Item 3 8 5 -3 (5-8) (Green)

goncalosilva123 · ‎03-03-2021

Hi again, this as done the work...and just another question, if I have several dates, how can I show only the last two and the difference? ex: 2021-01-19 2021-01-20 Dif_19_20 Item 1 29 31 -2 (31-29) Item 2 37 25 -12 (25-37) Item 3 8 5 -3 (5-8) Item 4 10 13 3 (13-10) Thanks in advance and sorry for the delay in answer.

goncalosilva123 · ‎02-22-2021

Hi, I have an automatic process that daily writes some information in a CSV file [1]. Then I have a dashboard that picks up some data and uses xyseries so that I can see the evolution by day. [2] Now I want to calculate the difference between everyday, but the problem is that I don't have "field" names so that I can use in an Eval, so I can I solve this? [3] Please see examples below. ################################################ [1] Information Saved every day [ | is the separator of each column] [Item_Name] | [Date_1] | [Total] 2021-01-18 Item 1 | |2021-01-18 | 32 Item 2 | |2021-01-18 | 50 Item 3 | |2021-01-18 | 10 Item 4 | |2021-01-18 | 15 2021-01-19 Item 1 | |2021-01-18 | 29 Item 2 | |2021-01-18 | 37 Item 3 | |2021-01-18 | 8 Item 4 | |2021-01-18 | 10 2021-01-20 Item 1 | |2021-01-20 | 31 Item 2 | |2021-01-20 | 25 Item 3 | |2021-01-20 | 5 Item 4 | |2021-01-20 | 13 ################################################ | inputlookup blabla | xyseries Item_Name Date_1 Total [2] Applying xyseries I get the following 2021-01-18 2021-01-19 2021-01-20 Item 1 32 29 31 Item 2 50 37 25 Item 3 10 8 5 Item 4 15 10 13 ################################################ [3] What I would like to have 2021-01-18 2021-01-19 2021-01-20 Dif_18_19 Dif_19_20 Item 1 32 29 31 -3 (29-32) 2 (31-29) Item 2 50 37 25 -13 (37-50) -12 (25-37) Item 3 10 8 5 -2 (8-10) -3 (5-8) Item 4 15 10 13 -5 (10-15) 3 (13-10) ################################################ Thanks in advance. Best Regards,

Posts	3
Solutions	0
Karma Given	0
Karma Received	0
Member Since	‎02-21-2017

Online Status	Offline
Date Last Visited	‎03-08-2021 09:15 PM

Use eval (or other) to make automatic calculation ...

Re: Use eval (or other) to make automatic calculat...

Re: Use eval (or other) to make automatic calculat...

Use eval (or other) to make automatic calculation ...