Date and corrsponding value
I have started using thoughtspot recently and I am unable to solve one problem. I have a column which has dates and the other column has corresponding values in amount($). I want only unique amount($) values irrespective of the date. As an eg.
# job Date Amount
1 15/08/19 10
1 16/08/19 10
1 17/08/19 10
1 19/08/19 5
I only want the dates 19/08 and amount 5 i.e the date when it was captured first and then 17/08 and 10 which is the date when there was a change in amount,
Could you please help me with this problem?
Thanks and Regards
I believe the keyword you are looking for is 'standard deviation'.
You should be able to read more about that keyword here: https://docs.thoughtspot.com/5.2/reference/keywords.html
Were you already able to solve this or were you still having issues?Reply