Tips

How to keep your filters from immediately resetting your query!

I have this standard, boring dashboard that shows details for 1-5 IDs at a time. The data source is HUGE (it takes ~10 seconds to query) and the query would run every time I selected an ID. So, if I needed to look at 100, 101, and 201 the process would look like this:

Open Filter, Select All

Cancel Query

Open Filter, De-select All

Cancel Query

Open Filter, Select 100

Cancel Query

Open Filter, Select 101

Cancel Query

Open Filter, Select 201

Done!

It was frustrating enough that editing the filter was easier than using the filter card. Not quite good enough for sharing!

Then I noticed that a production workbook wasn’t doing this! By looking at the filter I discovered how to add the Apply Button to filters.

custom

Now the process looks like this:

Open Filter

Select All

De-select All

Select 100

Select 101

Select 201

Apply

Done!

Uncategorized

Data Science

For the past month I’ve been working through Microsoft’s Data Science curriculum on edX. I’ve completed Dat101 (intro to Data Science) and Dat201 (Querying with Transact SQL). Next up is DS101X (Columbia’s Statistical Thinking for Data Science and Analytics).  

So far the content has been great. The SQL course was surprisingly thorough. The Excel section of the intro course was mostly review, but even it had a few new things!  The courses are completely free, though you can give them money for an official certificate.