Watch videos with subtitles in your language, upload your videos, create your own subtitles! Click here to learn more on "how to Dotsub"

BAG_pbi_02

0 (0 Likes / 0 Dislikes)
[00:00:01] I've got a simple report here, which you probably have seen in some of the other videos. And I've got this tree map over in the bottom right hand corner. Let's just make that a little bigger so you can see what everything is showing. And, I can see this is the number of units sold by state. So, in my underlying dataset, I've got individual sales transactions, and they will aggregate up into this overall number. So, across the whole of California, I've got 1.3 million worth of sales; Texas was at 650,000 or so. And, if I want to export this data up on the dot dot dot menu. I get an ‘Export Data’ option. I don't need to be in the pop-out mode to do that; I can export it just here just fine as well. And. I'll get given an option. So, this is where I can choose whether I want that summarized data, where I would get one line in my Excel document per data point in my chart, or the underlying data, and this would give me many rows. So, you know, if I had four underlying transactions that were aggregated up to give me one data point in my chart, that's what it would - all those four rows would get shown into the Excel workbook. You can also see that any of the filters that have been applied on my page are going to apply to the export as well. And, this is really useful if you're talking about from a security point of view, what this user’s got access to because only the data that they can see is what's going to get exported into that file. Let's hit ‘Export’ now. And, this will generate that excel file or CSV file, if that's what I chose, and add it to my downloads. Here’s my ‘units by state’ file. Open this one up. And, you can see I get a summary of all of the different filters that have been applied. We had a filter on manufacturer to just show four or five of the different manufacturers here. And, you can see I've got multiple rows for each of the states here, so although I only had one block in my tree map for California and it had aggregated up all of these units, actually, all I'm saying is, rather what I get in the underlying export is one row per each of the transactions or one row per each of the reported units, whatever it was that was being aggregated up to my total California value.

Video Details

Duration: 2 minutes and 25 seconds
Country:
Language: English
License: Dotsub - Standard License
Genre: None
Views: 4
Posted by: csintl on Feb 14, 2019

BAG_pbi_02

Caption and Translate

    Sign In/Register for Dotsub above to caption this video.