Hi, everyone.
So I wanted to add in two more cards just showing the one year low price and the one year percent change
price as it's something I'm often interested in.
So I'll just add a new sheet here and name it one year.
Low.
So it's pretty straightforward for the one year low.
We'll just create a calculated field.
And it's just going to be the min.
Of the close.
You could also show a one year high if you wanted.
It would just be a max instead.
But I'm only interested in the one year low for now.
And then we could drag that into our text field.
So for me, it's already white.
But you might need to change the color to white.
Then we can just double click our columns.
Create our title.
I can kind of see it here.
So I'm just going to hide the field labels and then I'll just format it in the dashboard actually.
So we'll add another sheet which will show the one year change.
And for that we'll just need to calculated fields.
So.
Uh, yeah.
We'll need the one year ago price, which will just be if.
Date.
Equals the minimum date.
Since we only have one year worth of data in this.
Then close.
No mandate is an aggregation.
So again, we just need our curly brackets.
So I'll just save that, create another calculated field, which will be the percent change.
For one year, and then that's going to be open brackets and it's going to be the sum of our latest
price column that we created minus the sum we need to keep these aggregated.
As the one year ago price that we just created and then close our brackets and then we divide that by
the one year ago price.
I just need to delete the ones.
Okay, so that's our percent change.
So I'll first, I'll just change the default to be a percentage.
I'm happy with one decimal place.
I'll just drag it into text.
And again, just a column that says.
One year percent change.
All right.
So now we'll just go back to our dashboard and we can drag them in.
Let's just make them floating first.
So I'm going to move the two that we have already just over to the left a bit.
Okay, so the first thing I'll do is remove the background.
And then I'll fit the entire view.
And let's just center these.
And hide the tail.
Make it a bit smaller for now.
So let's just copy our formatting from our other cards.
So it's Roboto Slab Lite 14 and Bold.
And I believe this Roboto slab.
I think this is done in the actual text box, though.
Yep.
14.
It's just not bold.
That's the only difference.
So again, I need to go to sheet and do it in our actual text box.
And just while we're here, let's just remove our row dividers.
Okay.
May as well change the color and the layout as well.
So our background, I'll just do a pick screen color.
And our border.
Is it that one?
No.
Yep.
It's that one.
It's just a bit thicker.
We'll position them after.
So let's just bring in our one year change as well and do the same thing.
Just make it floating first and then.
Hide the tile fit the entire view.
And then remove our background.
Reporter slab light 14 and bold and then go to sheet and our final text change.
Roboto slab.
Stuck tracker.
Okay.
Uh, we might want to make this red or green.
Yeah, but first of all, we're here.
We'll just change the container color.
Backgroundcolor and border dot color, I think.
Yep.
Might just remove the row binding the row divider.
Sorry.
And yeah, we will just drag this percent change while holding control into color.
And just make it a red green.
A reversed was ticked.
That's why Green was on the left and we can just center it at zero.
This looks like it's bold.
I might have made it bold just to.
Yeah, just to make it stand out a little better.
I'll do the same for this.
Okay.
So you can see these two cards aren't applying for this filter yet.
So Tesla's selected, but the percent change would be much more than -6.5.
It's went from $300 ish to 166.
So.
Yep, I will.
Just go on the filter, remove it, and then we'll just reapply it.
And then now you can see it affects it nine -40%.
And I think the last thing I'll do is just reposition all the cards to be the same.
So.
Let's just click on our last price.
One, you can position these wherever you want, but we'll do our last price one first and then if we
on the layout for position, we've got nine, four, nine and 125 for the x and Y.
So X will be this bottom side and y will be the left.
Or horizontal and vertical, I should say.
So we'll do the same.
So we want the the Y position to be the same for one year low.
So we will make it 1 to 5.
Almost there.
And we also want the width and height to be the same for the mall.
So two, five, five and 90.
And they're a little close together.
Maybe I'll just move this to the left a little bit.
For my part anyway.
And do that again.
So 92312525, five and 90.
Yep.
This is the same.
So our x position is 1213.
So that's going to affect the card directly below it.
Maybe we'll just move it down, actually.
So 2.63 will be the Y position.
For our other card.
And then for this card, we'll keep the X position the same as the card above it, which is 923.
Okay.
And then we'll just make the width and height the same for them.
Also.
255 by 90.
Okay, perfect.
So I think I'll leave it at that.
I will just save it.
And then it will republish to Tableau Public.
So I'll see you in the next section.