A clustered and stacked chart has clusters of columns or bars, with a stack in each column or bar. Similar to the example shown below: This type of chart can be used to compare actual vs. budget by category, for example.
Charts: Colour codes, fill/border, line formats and positioning should be dynamic
All colour codes, fill/border, line formats and positioning on charts should be able to be passed in from a range, named range or variable. This would essentially bring a basic "conditional" formatting to charts and cover the main things the users...
As already stated in JS-I-1711 I am a fan of global subsets. To obtain the dynamical size of such subset, it would be great to obtain it via a formula like PALO.SUBSETSIZE.
When opening a report fails or is too slow, for example, due to a macro running on startup, it would be helpful to have a safe mode to open the report ignoring actings, macros, etc. This could help fix the report.
Improve handling for creating arrays on merged cells
MS Excel doesn't allow to set an array formula (e.g. PALO.SUBSET, but also non-Jedox arrays) on a cell range with merged cells. Jedox Web Spreadsheet does accept input of array formula on a range with merged cells, but the output will then - depen...
Provide support for creating Box-and-Whisker Chart (aka “Box Plot”): a more generic and robust version of a Candlestick Chart meant to illustrate different dispersion ranges of data (e.g., quartiles, deciles) around a mean or median. Please review...
Keep the button properties (background, font) when clicking on it (web and Canvas)
I'd like it if, when the user clicks on a button, that same button could keep its properties (background, font, etc.) and not be displayed again by default. A bit like checkboxes that keep the tick displayed when you click on them.