End of the beginning by Benedict Evans.
Great example of storytelling through data:
StandardEnd of the beginning by Benedict Evans.
Year: 2018
Two great posts on DAU/MAU and Measuring Power Users
StandardTwo great posts from Andrew Chen. Links below:
These posts were perfectly timed for me as we started thinking about Annual Planning for Alexa Voice Shopping org (Amazon) this week. As a part of my research of which metrics to use to measure things that our business cares most about and then setting the right benchmarks/goals for the org, the posts below were super helpful. So if you are in tech and if you care about 1) measuring frequency of usage 2) measuring the most engaged cohort then you should take some time to read these posts.
DAU/MAU is an important metric to measure engagement, but here’s where it fails
Cheers!
Excel 2013: Display hidden rows columns and data on an Excel Chart
StandardIf you hide rows, columns and data on excel, the chart that’s uses this data also hides it — while this is the default behavior, you can override this by following the steps below.
Let’s reproduce the behavior first.
I have a simple excel chart like shown below:
Now, if I hide the data that is selected for this chart then the chart stops showing this as well:
To fix this and if you want the cells (rows, columns and data) to be still hidden but still have the chart show up, then follow the steps:
- Select the chart
- Under Chart Tools > Design > Select Data
- Click on Hidden and Empty Cells
- Check the Show data in hidden rows and columns check-box
- Go back to excel and you should see the data on the chart now even though the data is hidden
Hope that helps!