New Pivot Table Charting Component

UD-PivotTable

A powershell version of https://github.com/plotly/react-pivottable

My Reason For This Component

At my work I always seem to find that I have to put the raw data into a prettier format. Obviously UniversalDashboard does a great job in making this happen. But for instance when it comes to the sales team and you show them a grid but that grid has 1420 results or more, then you have to show them how to to export that data to excel, then all the steps involved to put that into a pivot table within excel. Just so they can have the data grouped better and not so many rows to digest. Well you know they are not going to remember, or simply carry on asking you. So this is how I plan to tackle that issue through the use of New-UDPivotTable an interactive dynamic pivot table/graph component.

Parameters

• -Data This is the only parameter in this component this is a mandatory paramater, as without this being supplied there will be no data to display

The Data Parameter Has To Be A HashTable

So the trick with passing the data to this component is it has to be in a hashtable format. This component works wonders
displaying SQL data, but for this example I will show how to put the output of get-process into a hashtable

 $Processes = Get-Process | sort-object CPU -Descending | Name, CPU, WorkingSet, VirtualMemorySize, StartTime
                $DataHash = @()
                foreach ($item in $Processes) {
                    $DataHash += @{
                        Name              = $item.Name
                        CPU               = $item.CPU
                        WorkingSet        = $item.WorkingSet
                        VirtualMemorySize = $item.VirtualMemorySize
                        StartTime         = $item.StartTime
                    }
                }

Now the variable $DataHash can be passed to the component like so
New-UDPivotTable -Data {$DataHash}
Literally that’s is all there is to passing the data to this component

Demo Of The Component

Import-Module -Name UniversalDashboard
Import-Module -Name UniversalDashboard.UDPivotTable
Get-UDDashboard | Stop-UDDashboard
$theme = Get-UDTheme -Name Default
Start-UDDashboard -Port 1000 -AutoReload -Dashboard (
    New-UDDashboard -Title "Powershell UniversalDashboard" -Theme $theme -Content {
        New-UDRow -Columns {
            New-UDColumn -Size 8 -Content {
###For DEMO purposes selecting the top 4 CPU processes on my local machine###            
                $Processes = Get-Process | sort-object CPU -Descending | Select-Object -first 4 Name, CPU, WorkingSet, VirtualMemorySize, StartTime
###Now we need to convert the data we want to show in New-UDPivotTable into a hashtable
                $hash = @()
                foreach ($item in $Processes) {
                    $hash += @{
                        Name              = $item.Name
                        CPU               = $item.CPU
                        WorkingSet        = $item.WorkingSet
                        VirtualMemorySize = $item.VirtualMemorySize
                        StartTime         = $item.StartTime
                    }
                }
###Once you have all your data in a hashtable format simply pass that to 
###New-UDPivotTable -Data parameter in a scriptblock
                New-UDPivotTable -Data { $hash }
            }
        }

    }
)

Then simply drag and drop for how you wish your data to be displayed.




I hope people enjoy using this, you can get your copy here:-
https://marketplace.universaldashboard.io/Dashboard/UniversalDashboard.UDPivotTable
or here:-


powershellgallery.com