search

humdek-unibe-ch / sh-shp-formula_parser

The plugin is based on (MathExecutor)[https://github.com/neonxp/MathExecutor]. It supports all the operators and functions that are supported in MathExecutor. The plugin uses (MathPHP)[https://github.com/markrogoyski/math-php] for additional math functions
0 stars 0 forks source link

Additional formula for arrays #3

Open NS21fpsy opened 3 months ago

NS21fpsy commented 3 months ago

Bild

In the picture we can see that the days without data entries have no markers or bars, which is correct in itself.

Plotly connects the data point of 15 March 2024 with that of 19 March 2024 because the traces for the X and Y axes look like this using the example of stress (red line):

entry_dates_formatted -- ["2024-03-13","2024-03-14","2024-03-15","2024-03-19"] question2 (stress) -- ["2", "6", "5", "4"]

From the data config we simply obtain existing entries from the survey. So for this survey and this user there are entries on 13.03, 14.03, 15.03 and 19.03

Problem:

However, it can be problematic to connect the line from 15.03.24 to 19.03.24, it can lead to an incorrect interpretation of the graph. So that Plotly would not connect the line, the traces arrays must look like this:

entry_dates_formatted -- ["2024-03-13", "2024-03-14", "2024-03-15", "2024-03-16", "2024-03-17", "2024-03-18", "2024-03-19"] question2 (stress) -- ["2", "6", "5", null, null, null, "4"]

Question:

Can we have a way to create a new array based on some input? Or can this already be done with "calculations_on_rows", for example?

Kodzhabashev commented 3 months ago

I guess the best thing it will be to create a new style inside this plugin that can manipulate data. Then the style can propagate the data to its children.