This is a also a very common basic chart. Histogram plots the frequency of occurrences. The input required for this is just one column of data.
Here is an example of a Histogram of quantity of items ordered from the Northwind databases' [Order Details] column.
Histogram.png
Note that R does not interpret Quantity as a numeric and further processing of data is necessary before it can be plotted using R Script in Power BI.
Note: Without the unlist() dataset1 will be double. With unlist() it becomes a numeric.
===============
dataset1=as.numeric(unlist(dataset))
hist(dataset1, main="Distribution of Quantity")
=============
Source of data: SQL Server 2012 | Northwind Database
Power BI: August 2016 Update
Here is an example of a Histogram of quantity of items ordered from the Northwind databases' [Order Details] column.
Histogram.png
Note that R does not interpret Quantity as a numeric and further processing of data is necessary before it can be plotted using R Script in Power BI.
Note: Without the unlist() dataset1 will be double. With unlist() it becomes a numeric.
===============
dataset1=as.numeric(unlist(dataset))
hist(dataset1, main="Distribution of Quantity")
=============
Source of data: SQL Server 2012 | Northwind Database
Power BI: August 2016 Update
No comments:
Post a Comment