I thought I’d reflect on the months I’ve shared with the other inhabitants of the DS. After each client project we did a ‘start/stop/continue’ where we went through what we should have done, what we should not have done and what we should continue to do. I’m going to structure this blog in a similar way looking at what I’ve done/liked and what I should have done more.
Today we spent a bit of time talking about filtering table calculations. This is obviously a pretty useful thing to want to do, but doesn’t immediately work. In this blog, I’ll show you an example of filtering table calculations, give you the preamble explaining why it’s slightly tricky, and then give you a solution.
It’s been a while since the last JTT, so I thought I’d get back in the groove of things by showing a quick and easy way to show total labels as well as composite labels on your stacked bar charts. No LODS or dual axes needed!
This week was Teaching Week in DS8, and Jevon took it upon himself to educate us in the ways of Data Densification. He had a cool exercise looking at ways of counting how many lightbulbs were on at one moment, but I’ll leave him to explain that. As part of his exercise he wrote a calculated field which ‘filled in’ rows a lot like the Multi Row Formula tool can do in Alteryx. We immediately got to put this calculation into practice helping someone out on our CoE. They wanted to be able to count how many tickets were open any given month. In this blog I’ll walk through how I went about solving this problem.
In this blog, I’m going to walkthrough and explain the calculations required to make Week 41’s dashboard. This uses worksheet actions to allow the user to see Sales by Profit for all US States, and then click a State to see the Sales by Profit of all the Cities in that State.
Dashboard week is over! The past five days have been undeniably intense, but also incredibly rewarding and enjoyable. As a sort of #ReflectiveLog I thought I’d look back over the past week, show all my dashboards in one place and also talk about what I’ve learned this week.
We’re over the hump of Dashboard Week. 4 days done and 1 more to go. It’s been a long week, but I’ve learnt an awful lot in it. In this blog I offer a quick introduction to the Throttle Tool. I’d never heard of this before Monday, and on the off chance that you’re in a similar position, then read on to find out more!