Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [chart]

For the visual representation of data in histograms, scatter plots etc. For node and vertex data models use [graph].

8 questions
4
votes
3 answers

Grouping data into 5 minute intervals within a time range

I am trying to prepare data for a candle stick chart. I have some records on MySQL database as shown below: | Rate | Date | |----------|---------------------| | 0.001111 | 2017-11-12 19:13:05 | | 0.001214 | 2017-11-12 19:14:11…
Uttam Rabadiya
  • 41
  • 1
  • 1
  • 4
2
votes
1 answer

Plotting graphs for MYSQL

I was executing following command mysqladmin ext -i1 -c3600 It produces valuable output but I want to use the output to plot graphs so that I can visualize inserts, updates, buffer and other stuff. Anyone has any idea on how to use the output to…
roger moore
  • 367
  • 3
  • 18
1
vote
1 answer

How to fill gaps with calendar table, count and group by

I'm building a bar chart. I would like a query which counts the entries from a particular day and groups them together as one row with a count. I have the following query working and I have a working date dimension table which I would like to try to…
Sauceman
  • 13
  • 1
  • 4
1
vote
2 answers

Open Source tools to visualise MySQL/MariaDB performance metrics (show global status with interval)

I'm searching for an Open Source tool to visualise MySQL/MariaDB performance metrics (output of show global status in nice graphs). In MongoDB world there is the Closed Source Ops Manager and the Open Source mtools. I'm searching for something…
Sybil
  • 2,578
  • 6
  • 34
  • 61
1
vote
1 answer

SSRS - Graph Line Value for Parameter

For the purpose of reporting database growth, I am created everything except one and most important thing. In SSDT I'm created report, which contains graph line which need to be show in depend of parameters. I have drop-down list of databases, graph…
Darko Milic
  • 464
  • 3
  • 8
  • 17
0
votes
1 answer

creating a Pie Chart in SSRS

how can I create the pie chart that displays the Count of columns with filters like ( Active Paths / Courses / Sections /----- this is my column name )from 4 different tables and combined them in one query?
mitu habtay
  • 1
  • 1
0
votes
1 answer

What is the advantage of setting a character column as VARCHAR(32) over VARCHAR(255)

What is the advantage of setting a database column VARCHAR(32) over VARCHAR(255) even though the two of them consume 2-byte memory?
Navaneet Raman Bhaskar
  • 11
  • 1
  • 6
0
votes
1 answer

How does one create a data base for a survey/questionnaire?

I need to create a database for a wordy questionnaire. At the end I want to be able to graph my information. Where can I do this?
user75873
  • 1
  • 1