charts – How to avoid performance issues in user-customizable dashboards by limiting in some way the amount of information being displayed

I work for a Product that allows users to create customs dashboards. They have the possibility to create 1-25 custom charts and the available chart types are indicators, columns, bars, area, pie, and line.

The problem that we are currently facing is that some users create dashboards with dimensions that not only bring an insane amount of data which causes performance issues but also are really hard to read and analyze.

I would like to receive some advice about how to:

  • Reduce the data that we render in the charts.
  • Limit the users so they don’t create no-sense reports.

Thanks in advance,

Creating distinctive designs for business cards, book and magazine covers, as well as making charts. for $5

Creating distinctive designs for business cards, book and magazine covers, as well as making charts.

Thank you for choosing us, we will do our best to satisfy you,
We do the best designs
All you have to do is order and we will provide it to you as soon as possible. *Designing a business card (restaurants) (coffees) (lawyers)……
* magazines Cover.
*Book cover.
*Schemes.

.(tagsToTranslate)Design(t)Cover(t)Planned

Crypto Currency Tracker – Realtime Prices, Charts, News, ICO’s and more | NullScripts

Track the prices of 1600+ Crypto Currencies like Bitcoin, Ethereum, Litecoin, Ripple etc.

Crypto Currency Tracker is an ultimate platform to keep track of crypto market and prices. It has a clean, user-friendly, contemporary design, awesome features, continuous updates, 24/7 customer support and free installation and updates support at server..

Providing 3 different website layouts along 12 different color schemes those are easily…

.

formulas – Google sheets – how can I use functions to resort my table in a way charts can read it well

I’m using app sheets to see what I do in a day. I select the task i am starting on the app and app sheets dumps the data into a table in google sheets.

I have made an example of what this looks like. Sheet1 is what it looks like At the moment and sheet2 is what I would like it to look like (or something else that will help charts read it)

https://docs.google.com/spreadsheets/d/1GF6cjlNMSTJov4G6ZMusXSWS-DMwnK4SgQqNs8d8uws/edit?usp=sharing

I have been pulling my hair out trying to do this so if you know how please tell me.

charts – How to delete missing data and the name associated with the missing observations

I want to construct a bar char for the following data, but I am having a problem with Missing[]:

countries = {"Afghanistan", "Bangladesh", "Bhutan", "India", 
   "Maldives", "Nepal", "Pakistan", "Sri Lanka", "Brunei Darussalam", 
   "Cambodia", "Indonesia", "Laos", "Malaysia", "Myanmar", 
   "Philippines", "Singapore", "Thailand", "Timor-Leste", "Vietnam", 
   "China", "Japan", "Mongolia", "North Korea", "South Korea", 
   "American Samoa", "Fiji", "French Polynesia", "Guam", 
   "Hong Kong SAR, China", "Kiribati", "Marshall Islands", 
   "Micronesia", "Nauru", "New Caledonia", "Northern Mariana Islands",
    "Palau", "Papua New Guinea", "Samoa", "Solomon Islands", "Tonga", 
   "Tuvalu", "Vanuatu", "Australia", "New Zealand"};
sAsia = {"Afghanistan", "Bangladesh", "Bhutan", "India", "Maldives", 
   "Nepal", "Pakistan", "Sri Lanka"};
seAsia = {"Brunei Darussalam", "Cambodia", "Indonesia", "Laos", 
   "Malaysia", "Myanmar", "Philippines", "Singapore", "Thailand", 
   "Timor-Leste", "Vietnam"};
eAsia = {"China", "Japan", "Mongolia", "North Korea", "South Korea"};
SIDS = {"American Samoa", "Fiji", "French Polynesia", "Guam", 
   "Hong Kong SAR, China", "Kiribati", "Marshall Islands", 
   "Micronesia", "Nauru", "New Caledonia", "Northern Mariana Islands",
    "Palau", "Papua New Guinea", "Samoa", "Solomon Islands", "Tonga", 
   "Tuvalu", "Vanuatu"};
Pacific = {"Australia", "New Zealand"};

data19 = {2.55, 8.05, 4.05, 5.25, 7.55, 7.15, 3.7, 2.8, 2, 7.25, 5.1, 
  5.5, 4.55, 6.6, 6.15, 2.4, 3.25, 0.35, 7.05, 6.25, 0.45, 6.2, 
  Missing[], 2.45, Missing[], 1.7, Missing[], Missing[], 0.8, 3.85, 
  4.8, 0.7, 3.35, Missing[], Missing[], 2, 2.8, 0.75, 2.55, 0.5, 4.6,
  3.1, 2.35, 2.9};
data20 = {-5, 3.8, -0.8, -8, -32.2, -1.9, -0.4, -3.6, 
  1.2, -3.5, -2.1, -0.4, -5.6, 3.2, -9.5, -5.4, -6.1, -6.8, 2.9, 
  2.3, -4.8, -5.3, Missing[], -1, Missing[], -19, Missing[], 
  Missing[], -6.1, -0.5, -3.3, -1.6, 0.7, Missing[], 
  Missing[], -10.3, -3.9, -3.2, -4.3, -0.5, 0.5, -9.2, -2.4, -3};
data = {data19, data20};
names = {"2019", "2020"};
ds = Dataset@Map[AssociationThread[names, #] &]@Transpose[data]

I like to use the database ds in constructing special charts in: https://mathematica.stackexchange.com/a/249707/60365

Initially, I gave the data as a list of lists and I had no problem. But now because of the Missing[] observations in my data, I realized that using the database ds is more advantagous but then I am stuck with how touse ds in the code given in the above link.

How to avoid the dreaded Data Table when copying and pasting charts in Libreoffice Calc

Libreoffice Calc has a curious and frustrating behaviour, in that when copying a chart from one tab to another in a workbook, in the majority of cases the duplicated chart is furnished with a copy of the data from the original source, not a live link to the original data. The result is that if the source data changes, the duplicate chart does not update as expected.

The behaviour appears to be intermittent, where sometimes, the duplicate chart maintains a link to the original data. I am yet to identify any difference in process that leads to this result. How does one reliably copy and paste a chart in Calc without having it create a fixed Data Table.

Steps to reproduce:

  1. Create chart with link to data
  2. Create new tab
  3. Copy the existing chart either with Ctrl+C or /Copy
  4. Paste chart into new tab with either Ctrl+V or / Paste
  5. <right click)/Edit new chart
  6. new chart while in edit mode
  7. Observe presence (or absence) of ‘Data Table’ menu item in context menu

charts – Labeling the bars in a stacked BarChart

I have the following data, which shows the number of events by day of the week (Sunday through Saturday) and hour of the day (00 through 23):

  data={<|0 -> 2200, 1 -> 300, 2 -> 100, 3 -> 50, 4 -> 150, 5 -> 1850, 
  6 -> 2450, 7 -> 2600, 8 -> 3050, 9 -> 4400, 10 -> 5550, 11 -> 8450, 
  12 -> 7650, 13 -> 7750, 14 -> 6750, 15 -> 6350, 16 -> 5250, 
  17 -> 4600, 18 -> 3700, 19 -> 2800, 20 -> 2700, 21 -> 2650, 
  22 -> 2500, 23 -> 1950|>, <|0 -> 1750, 1 -> 100, 4 -> 300, 
  5 -> 2500, 6 -> 3100, 7 -> 7350, 8 -> 10550, 9 -> 5900, 10 -> 7150, 
  11 -> 7350, 12 -> 7850, 13 -> 7500, 14 -> 6300, 15 -> 6900, 
  16 -> 9050, 17 -> 8150, 18 -> 3800, 19 -> 3000, 20 -> 2450, 
  21 -> 2450, 22 -> 2250, 23 -> 2150|>, <|0 -> 1450, 1 -> 50, 2 -> 50,
   4 -> 650, 5 -> 2500, 6 -> 3050, 7 -> 7700, 8 -> 10450, 9 -> 6400, 
  10 -> 8250, 11 -> 8050, 12 -> 8450, 13 -> 8250, 14 -> 7200, 
  15 -> 7800, 16 -> 9600, 17 -> 9100, 18 -> 4400, 19 -> 3200, 
  20 -> 2700, 21 -> 2550, 22 -> 2450, 23 -> 2200|>, <|0 -> 1650, 
  1 -> 150, 2 -> 100, 4 -> 750, 5 -> 2550, 6 -> 3050, 7 -> 7650, 
  8 -> 11300, 9 -> 7100, 10 -> 7750, 11 -> 9350, 12 -> 9250, 
  13 -> 8000, 14 -> 7950, 15 -> 7900, 16 -> 9500, 17 -> 9150, 
  18 -> 4900, 19 -> 3600, 20 -> 2950, 21 -> 2650, 22 -> 2550, 
  23 -> 2350|>, <|0 -> 1650, 1 -> 100, 2 -> 50, 3 -> 200, 4 -> 700, 
  5 -> 2550, 6 -> 3050, 7 -> 7350, 8 -> 11150, 9 -> 7200, 10 -> 8150, 
  11 -> 8150, 12 -> 8400, 13 -> 8100, 14 -> 7400, 15 -> 7900, 
  16 -> 9800, 17 -> 9100, 18 -> 4750, 19 -> 3550, 20 -> 2850, 
  21 -> 2750, 22 -> 2450, 23 -> 2100|>, <|0 -> 1800, 1 -> 50, 
  2 -> 100, 4 -> 900, 5 -> 2500, 6 -> 3050, 7 -> 7050, 8 -> 9800, 
  9 -> 6450, 10 -> 7750, 11 -> 8650, 12 -> 9350, 13 -> 8750, 
  14 -> 7450, 15 -> 8250, 16 -> 9100, 17 -> 9550, 18 -> 6100, 
  19 -> 4800, 20 -> 3800, 21 -> 3450, 22 -> 3100, 
  23 -> 2550|>, <|0 -> 2250, 1 -> 350, 2 -> 150, 3 -> 100, 4 -> 150, 
  5 -> 2250, 6 -> 2550, 7 -> 2500, 8 -> 3500, 9 -> 4350, 10 -> 5200, 
  11 -> 6900, 12 -> 6600, 13 -> 6600, 14 -> 6150, 15 -> 6350, 
  16 -> 5650, 17 -> 6200, 18 -> 5400, 19 -> 4850, 20 -> 3750, 
  21 -> 3850, 22 -> 3400, 23 -> 2950|>}

I’ve created the following stacked BarChart. Each bar is a day of the week.
ChartLabels->Automatic labels the hours within each bar, but I’d also like to label the individual bars themselves as Sunday, Monday, Tuesday, etc.

BarChart(data, ChartLabels -> Automatic, 
 ChartLayout -> "Stacked", Joined -> True, ImageSize -> Large, 
 FrameLabel -> {Style("Day of Week", Bold, 12, Blue), 
   Style("Volume", Bold, 12, Blue)}, Frame -> True)

enter image description here

I.e., I’d like labels that are specifically associated with each bar, as seen below. But if I use ChartLabels to specify the days of the week, I loose the hour labeling. I want to keep both. How do I do that?

dow = System`DateObjectDump`$DaysOfTheWeek;
BarChart(data, ChartLabels -> {dow, None}, 
 ChartLayout -> "Stacked", Joined -> True, ImageSize -> Large, 
 FrameLabel -> {Style("Day of Week", Bold, 12, Blue), 
   Style("Volume", Bold, 12, Blue)}, Frame -> True)

enter image description here

Changing Charts Number Labels to Text not working (iOS Charts)

I’m plotting sunrise/sunset against time, so time goes along the X axis with iOS Charts.
If I display the x labels as numbers they manifest correctly: If I swap them over to text (Jan – Dec) only Jan shows up???

enter image description here

Associated iOS Chart code:

    // Setup X Axis
    lineChartView.xAxis.axisMinimum = 0
    lineChartView.xAxis.axisMaximum = 366
    lineChartView.xAxis.granularityEnabled = true
    lineChartView.xAxis.granularity = 30
    lineChartView.xAxis.labelCount = 12
    lineChartView.xAxis.axisLineWidth = 2
    lineChartView.xAxis.axisLineColor = .black
    lineChartView.xAxis.centerAxisLabelsEnabled = true

If I swap it over to literals then I only get Jan. All the values are populated. Any ideas?

enter image description here

Code:

     // Setup X Axis
    let months = ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sept","Oct","Nov","Dec")
    lineChartView.xAxis.axisMinimum = 0
    lineChartView.xAxis.axisMaximum = 366
    lineChartView.xAxis.granularityEnabled = true
    lineChartView.xAxis.granularity = 30
    lineChartView.xAxis.labelCount = 12
    lineChartView.xAxis.valueFormatter = IndexAxisValueFormatter(values:months)
    lineChartView.xAxis.axisLineWidth = 2
    lineChartView.xAxis.axisLineColor = .black
    lineChartView.xAxis.centerAxisLabelsEnabled = true

Run Charts off of Webform Submissions table?

I’m getting ready to hire a developer, and have an architecture question.

I’m setting up a Drupal 8 site (D9 soon) with a lot of charts. The charting software requires data in JSON format. The data types are basic — just Booleans, dates, and integers. There are no fields with multiple values.

I plan to use Webform to collect data from users, then run the charts off the Webform Submissions table. I’d like to use SQL to query the table, then use some PHP to convert to JSON.

I know Webform can export to JSON format, but think it would be easier to just query the Webform Submissions table using SQL.

I could run the charts through the Drupal DB API. But since the data just gets saved once and not updated after that, I don’t think I need the Drupal DB API, which would allow the data to be updated.

With Views, I think I’d need custom programming for granular control. SQL seems like it has tighter control of queries.

I realize I could have problems with forward compatibility if the structure of the Webform Submissions table is changed.

My questions:

— Is my analysis correct? Does the above approach seem reasonable?

— Any reasons to not run off of the Webform Submissions table? Scaling issues? Security problems?

— Advantages and disadvantages of using SQL instead of the Drupal DB API?

— Is there doc. or other discussion I should read? Alternate approaches to consider?