How can i different calculations when you combine columns and rows?

Jaehong Yang asked on May 16, 2019
  1. Is it possible to calculate the sum when merging rows and the average when merging columns?

    2. Is it possible to set only one calculation in a cell?

Attachments:
sample.PNG

4 answers

Public
Vera Didenko Flexmonster 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

Public
Jaehong Yang 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.

Attachments:
sample.PNG

Public
Jaehong Yang May 17, 2019

add report.json

Attachments:
report (11).json

Public
Vera Didenko Flexmonster 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

Please login or Register to Submit Answer