Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
brindlogcool
Creator III
Creator III

Difference in Comma separated values

Is it possible to get the difference in the comma separated values. For example if i have the table as

Key, ct

A,10,20,30,40  

B, 20,50,70

c, 1,2

so i am looking for

Key, ct

A,  10,10,10    ------> Got the values in ct by 20-10,30-20,40-30

B,   30,20       ------> Got the values in ct by 20-50,50-70

c,   1              ------> Got the values in ct by 2-1

so on..... it is calculating the difference in the dynamic comma separated values without splitting into multiple columns. but it would be consistent as per the above example.

11 Replies
brindlogcool
Creator III
Creator III
Author

Does evaluate works on date/timestamp?

Clever_Anjos
Employee
Employee

Yes, it does

Capturar.PNG