asked on September 16, 2021
Hi there,
I want to reopen this ticket...
https://www.flexmonster.com/question/non-aggregation/
We want to ask for same functionality (Non Aggregated) values in Compact Forms.
From our experience this is actually most wanted option for our users, and your proposals are not quite what they would find intuitive.
Also, I must add that we are using server side FlexMonster MongoDB connector.
This is for us really option which makes difference if FM can be useful or not at all.
⋅ September 17, 2021
Hello, Aleksandar,
Thank you for writing to us.
An alternative solution to the ones suggested in the referenced support discussion is to use calculated values.
With this approach, you can create formulas to display non aggregated values when using the compact layout.
For example:
if( count("Price") > 1, , sum("Price"))
We have prepared a JSFiddle for illustration: https://jsfiddle.net/flexmonster/uf3padx9/.
In the example, we defined a calculated value named "Price (Non Aggregated)". As a result, under "Price (Non Aggregated)" Flexmonster will only display non-aggregated values.
Please let us know if this would work for you.
Kind regards,
Vera
⋅ September 17, 2021
Hallo Vera,
We know about this workaround, but this is not what user needs from data-evaluation tool.
Problem with this is that it doesn't show multiple values for same dimensions: e.g:
Japan 2019 50.00
Japan 2019 40.00
Japan 2020 45.00
USA 2018 56.00
USA 2018 59.00
Also in some cases (specially for time (or time-like) series), line charts visualization without aggregation is the only one which is needed and meaningful.
From our perspective, this is very very needed overview. Before user even know what to aggregate, it is needed to preview data in a raw/table way. Then he can decide how to create report.
⋅ September 20, 2021
Hello, Aleksandar,
Thank you for your response.
According to the example you provided, it seems the flat layout would work for your case (see demo).
In flat form, Flexmonster displays raw data without applying aggregations. Such a layout allows previewing non-aggregated data before proceeding with creating the report.
In addition, you can configure Flexmonster to display the data in flat form on initial load. This can be done by setting the grid.type option to "flat" in the initial report configuration.
Also, you can switch between layouts during runtime via the UI using the Toolbar Options Tab or programmatically with the setOptions() API call (see our setting report options guide).
Regarding charts:
Flexmonster provides built-in pivot charts, meaning the data is aggregated and visualized on a chart. For creating chart visualizations with raw data, we suggest using third-party charting libraries. At the same time, it is possible to integrate Flexmonster with the chosen charting library to provide additional chart visualizations alongside Flexmonster.
Please let us know if this would work for you.
Kind regards,
Vera