asked on May 16, 2019
2. Is it possible to set only one calculation in a cell?
⋅ May 16, 2019
Hello, Jaehong Yang,
Thank you for writing to us.
1) It looks like at the moment Flexmonster doesn't have this feature, but it seems we may have something close to it.
In Flexmonster you can add a few aggregations to one measure:
measures: [
{
"uniqueName": "Revenue",
"aggregation": "sum",
"format": "2sfou03a"
},
{
"uniqueName": "Revenue",
"aggregation": "average",
"format": "2sfou03a"
}
]
Here is a JSFiddle example for illustration.
2) Regarding setting only one calculation in a cell, could you please give us more details about it?
We are looking forward to hearing from you.
Best Regards,
Vera
⋅ May 17, 2019
If you look at the attached screenshot, each cell is already aggregated as average as weekly data. In this situation, clicking 'EC2' merges the row and is recalculated to the average value, which is the aggregation set. What I want to implement is I want to calculate as sum when I click 'EC2'. The average value is calculated by merging daily data into one week. In other words, I would like to sum up by merging columns and calculating average value.
I'd like to see the calculated results without additional row or column.
⋅ May 17, 2019
add report.json
⋅ May 17, 2019
Hello, Jaehong Yang,
Thank you for providing more details about the desired output and for sharing a sample report.
This helped to understand the case better.
In Flexmonster at the moment only one calculation is possible in a single cell.
Please let us know if you have further questions.
Best Regards,
Vera
