Daily trend to show up, down and same indicator

[harveyd]

What I’m trying to do

Create a table that compares data from Todays note vs. Yesterdays and shows an up, down or same trend for each Item.

Things I have tried

I have been able to create the following dataview table:

Using the following code:

TABLE WITHOUT ID 
	choice(mood>this.mood, mood + " -> " + this.mood + " ▼", mood + " -> " + this.mood + " ▲" ) AS "Mood",
	choice(anxiety>this.anxiety, anxiety + " -> " + this.anxiety + " ▼", anxiety + " -> " + this.anxiety + " ▲" ) AS "Anxiety",
	choice(sleep>this.sleep, sleep + " -> " + this.sleep + " ▼ ", sleep + " -> " + this.sleep + " ▲" ) AS "Sleep",
	choice(food>this.food, food + " -> " + this.food + " ▼", food + " -> " + this.food + " ▲" ) AS "Food"
WHERE file.day = date(this.file.name) - dur(1day)

As you can see though, with Anxiety, where the values are the same, I can’t find a way to denote that there is no change as choice only provides an if then else. What I really need is an if, else if and else option.

Is this achievable in dataview or do I need to look at something like dataviewjs?

Can anyone provide a potential solution?

Many thanks.

[holroy]

@harveyd

Can anyone provide a potential solution?

Just increase the level of choice().

mood + " -> " + this.mood + " " +
choice( mood < this.mood, "▼",
  choice( mood > this.mood, "▲", "=" ))

If it’s not less than, and if not larger than, it’s got to be equal…

[harveyd]

@holroy

mood + " -> " + this.mood + " " +
choice( mood < this.mood, "▼",
  choice( mood > this.mood, "▲", "=" ))

One again, thank you @holroy. Simple and to the point. I should have considered nesting.

For completion, this was my end result:

TABLE WITHOUT ID 
	mood + " -> " + this.mood + " " +
		choice( mood > this.mood, "▼",
		  choice( mood < this.mood, "▲", "◌" )) AS "Mood",
	anxiety + " -> " + this.anxiety + " " +
		choice( anxiety > this.anxiety, "▼",
		  choice( anxiety < this.anxiety, "▲", "◌" )) AS "Anxiety",
	sleep + " -> " + this.sleep + " " +
		choice( sleep > this.sleep, "▼",
		  choice( sleep < this.sleep, "▲", "◌" )) AS "Sleep",
	food + " -> " + this.food + " " +
		choice( food > this.food, "▼",
		  choice( food < this.food, "▲", "◌" )) AS "Food"
WHERE file.day = date(this.file.name) - dur(1day)