Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Blank Line Chart with Streaming

Hello!   I have created a Streaming Dataset and if I create a Line Chart from the Report Page the graph is showed with no problem. But I have to do a manual refresh.    But if I go to the Dashboa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello Anonymous ! I set up like this:

 

v-alq-msft  If it helps, here is the Powershell Code, used from Guyinacube, did I do something wrong?

$endpoint = "Removed for security reasons"

while($true)
{

$ComputerCPU = (Get-WmiObject -Class win32_processor -ErrorAction Stop | Measure-Object -Property LoadPercentage -Average | Select-Object Average).Average

$ComputerMemory = Get-WmiObject -Class win32_operatingsystem -ErrorAction Stop
$UsedMemory = $ComputerMemory.TotalVisibleMemorySize - $ComputerMemory.FreePhysicalMemory
$Memory = (($UsedMemory/ $ComputerMemory.TotalVisibleMemorySize)*100)
$RoundMemory = [math]::Round($Memory, 2)

$Date = Get-Date -DisplayHint Date -Format MM/dd/yyyy

$Time = Get-Date -DisplayHint Time -Format HH:mm:ss

#$RoundMemory
#$ComputerCPU 
#$Date
#$Time

$payload = @{
"Date" =$Date
"Time" =$Time
"CPU" = $ComputerCPU
"Memory" = $RoundMemory
}
Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))

Write-Host "Date: " $Date " Time: " $Time " CPU: " $ComputerCPU " Memory: " $RoundMemory

sleep 2
}

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

    According to your provided screen shot, it seems OK. Could you please create a line chart visual with field Time and CPU and check if the data can display normally? I need to check if there is any problem in field Time...

    In addition, please try to update Powershell codes as below and check if it works:

    while($true)
    {

    $ComputerCPU = (Get-WmiObject -Class win32_processor -ErrorAction Stop | Measure-Object -Property LoadPercentage -Average | Select-Object Average).Average

    $ComputerMemory = Get-WmiObject -Class win32_operatingsystem -ErrorAction Stop
    $UsedMemory = $ComputerMemory.TotalVisibleMemorySize - $ComputerMemory.FreePhysicalMemory
    $Memory = (($UsedMemory/ $ComputerMemory.TotalVisibleMemorySize)*100)
    $RoundMemory = [math]::Round($Memory, 2)

    $Date = Get-Date -DisplayHint Date -Format MM/dd/yyyy

    $Time = Get-Date -DisplayHint Time -Format HH:MM:ss

    #$RoundMemory
    #$ComputerCPU
    #$Date
    #$Time

    $endpoint = "Removed for security reasons"
    $payload = @{
    "Date" =$Date
    "Time" =$Time
    "CPU" = $ComputerCPU
    "Memory" = $RoundMemory
    }
    Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))

    Write-Host "Date: " $Date " Time: " $Time " CPU: " $ComputerCPU " Memory: " $RoundMemory

    sleep 2
    }

    Best Regards

    Rena

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you for the response Anonymous!

       

      With your adjusted code the Line chart visual that you asked updates every few seconds and works. However, if I add a "Real time Tile" on the Dashboard  it does not work. An onbservation: The historical analysis is "on" in the dataset. 

       

      Idk, can you check if in your computer the code works maybe?

       

      • hs_sydney's avatar
        hs_sydney
        Regular Visitor
        5 years ago

        Did you get this working?  I have exactly the same issue with the line chart trying to update in real time.  I tried also changing the time to HH:MM:ss rather than HH:mm:ss but the resulting time was picking up the month as minutes so I have reverted back to mm for minutes.