Here is a quick visualization challenge for you.
There are 25 KPIs and each has a base value, current month, corresponding month values. The KPIs also have targets.
The data looks like this:
Download the data:
Click here to download the data for this contest.
Rules for this contest:
- Visualize this data using one Excel chart (one chart per KPI is ok too).
- You may omit any data
- You can use interactive charts.
- Do not use add-ins or VBA to make your charts
Go ahead and make your chart(s).
Last date & how to submit:
- Last date for this contest is 1st November, 2015 (Sunday).
- Once your chart is ready, email the workbook to chandoo.d@gmail.com with the subject “KPI contest“
- Winners will be announced in 2nd week of November, 2015.
What do winners get?
After carefully reviewing all the charts, 2 winners will be selected by our panel of judges. Each of them will get $100 Amazon gift card.
So what are you waiting for. Go ahead and visualize the data and show us how awesome you are.
Thanks to shaikhrulez @ Chandoo.org forum
Thanks to shaikhrulez at Chandoo.org forum for the data & question that became this contest.
8 Responses to “What is LAMBDA? 4 Practical examples to REALLY understand it”
Thanks so much for this, it's utterly brilliant!
Silly question - I assume LAMDA will work with dynamic arrays?
Very much so. Many of the new functions like MAP only make sense in the context of dynamic arrays and Lambda functions.
As usual, very informative material. Easy to understand and apply!
Thanks for making everyone awesome!
Easy to understand Lambda function through this tutorial. Thanks Chandoo.
I have Officce 365 (updated), but I can't see LAMBDA function. 🙁
I dont see "Office Insider" option in my excel 365.
Another option for First Monday...
=LAMBDA(anydate,WORKDAY.INTL(EOMONTH(anydate,-1),1,"0111111"))
Loving the binary options in WORKDAY.INTL David...