Create a chart for use of number of RDS users & groups

• January 29, 2018 at 7:27 pm #18968
  
  stevenbaert

  Hi,

  I would like to create an RDS overview of number of total of users per hour, for over a full year.
  Then I also would like to show the number of users per team.
  Got all data in Powershell (which gets it from a sql database).

  $Overview => type is System.Management.Automation.PSCustomObject

  $Overview
  GroupName Details
  ——— ——-
  Team01 {{ x: new Date(2018,1,29,14,00), y: 57 },{ x: new Date(2018,1,29,16,00), y: 20},}
  Team02 {{ x: new Date(2018,1,29,14,00), y: 3 },{ x: new Date(2018,1,29,17,00), y: 4 },}
  Team03 {{ x: new Date(2018,1,29,14,00), y: 9 },{ x: new Date(2018,1,29,18,00), y: 6 },}
  Team04 {{ x: new Date(2018,1,29,14,00), y: 5 },{ x: new Date(2018,1,29,19,00), y: 25 },}
  TOTAL {{ x: new Date(2018,1,29,14,00), y: 74},{ x: new Date(2018,1,29,20,00), y: 55 },}

  I found this chart: https://canvasjs.com/javascript-charts/multi-series-chart/
  which could show the different teams and stats, but how do I get
  the $Overview into the html in a decent way now?
  Could import the html via Get-Content -Path C:\path\to\my\file.txt but then still my data $overview won’t be in it.

  Thanks for your input.
  Steven

  January 30, 2018 at 10:00 am #18983
  
  Suyash Singh

  @stevenbaert,

  Can you please share a sample project along with sample data reproducing the issue that you are facing and share it over one drive(or any other similar service) so that we can understand your code better and help you out?

  ___
  Suyash Singh
  Team CanvasJS

  February 1, 2018 at 5:13 pm #19239
  
  stevenbaert

  Hi,

  Thanks! However, figured it out meanwhile but do have another question.
  My date notation is wrong, although I use f.e. { x: new Date(2018,1,30,20,0), y: 133 } it shows month as March.
  Can you help me with that?

  Hope screenshot clarifies it:
  

  https://www.dropbox.com/s/in035b263k3mklf/Screenshot_1.jpg?dl=0
  S.

  • This reply was modified 6 years, 9 months ago by stevenbaert.
  February 2, 2018 at 10:31 am #19283
  
  Suyash Singh

  @stevenbaert,

  In JavaScript month starts from 0 instead of 1. So new Date(2018, 2, 1) would be Mar 02 2018(as February 2018 has 28 days). Please take a look at this link on JavaScript Dates for more info.

  ___
  Suyash Singh
  Team CanvasJS

  February 2, 2018 at 5:43 pm #19292
  
  stevenbaert

  Thanks, just what I needed!