asked on September 14, 2022
I want to add two columns like shown in the screenshot
Code
public report: Object = {
dataSource: {
data:tableData,
mapping: {
Date: [
{
uniqueName:”Week”,
type:”datetime”,
interval:”w”,
format:”d-MMM”
},
{
uniqueName:”Month”,
type:”datetime”,
interval:”M”,
format:”MMM”
},
],
}
},
slice: {
rows: [
{
uniqueName:”Cell”
},
{
uniqueName:”Bucket”
},
],
columns: [
{
uniqueName:”Month”
},
{
uniqueName:”Week”
}
],
measures: [
{
uniqueName:”Price”,
},
],
expands: {
expandAll:true
}
},
options: {
grid: {
type:”classic”,
showTotals:”off”,
showFilter:false,
showHeaders:false,
showGrandTotals:”off”,
showAutoCalculationBar:false
},
configuratorButton:false
}
};
Data
[
{
“Cell”: “CANSTACK”,
“Price”: 697,
“Bucket”:”With < 5% addition”,
“Date”: “2018-02-28”,
“Data”:”123″
},
{
“Cell”: “BLDC”,
“Price”: 1118,
“Bucket”:”Newly Reflecting”,
“Date”: “2018-02-12”,
“Data”:”123″
},
{
“Cell”: “BUDC”,
“Price”: 698,
“Bucket”:”Part added within 4 weeks”,
“Date”: “2018-01-28”,
“Data”:”123″
},
{
“Cell”: “BLDC”,
“Price”: 880,
“Bucket”:”Newly Reflecting”,
“Date”: “2018-01-24”,
“Data”:”123″
},
{
“Cell”: “BLDC”,
“Price”: 938,
“Bucket”:”Newly Reflecting”,
“Date”: “2018-03-28”,
“Data”:”123″
},
{
“Cell”: “CANSTACK”,
“Price”: 966,
“Bucket”:”With < 5% addition”,
“Date”: “2018-02-06”,
“Data”:”123″
},
{
“Cell”: “BLDC”,
“Price”: 780,
“Bucket”:”Newly Reflecting”,
“Date”: “2018-01-19”,
“Data”:”123″
},
{
“Cell”: “CANSTACK”,
“Price”: 491,
“Bucket”:”With < 5% addition”,
“Date”: “2018-01-22”,
“Data”:”123″
},
{
“Cell”: “BUDC”,
“Price”: 327,
“Bucket”:”Part added within 4 weeks”,
“Date”: “2018-02-15”,
“Data”:”123″
},
{
“Cell”: “BUDC”,
“Price”: 938,
“Bucket”:”Part added within 4 weeks”,
“Date”: “2018-01-04”,
“Data”:”123″
},
{
“Cell”: “CANSTACK”,
“Price”: 774,
“Bucket”:”With < 5% addition”,
“Date”: “2018-01-03”,
“Data”:”123″
},
{
“Cell”: “BUDC”,
“Price”: 832,
“Bucket”:”Part added within 4 weeks”,
“Date”: “2018-03-30”,
“Data”:”123″
},
{
“Cell”: “BLDC”,
“Price”: 819,
“Bucket”:”Newly Reflecting”,
“Date”: “2018-02-08”,
“Data”:”123″
},
{
“Cell”: “BUDC”,
“Price”: 964,
“Bucket”:”Part added within 4 weeks”,
“Date”: “2018-03-31”,
“Data”:”123″
},
{
“Cell”: “BUDC”,
“Price”: 323,
“Bucket”:”Part added within 4 weeks”,
“Date”: “2018-03-10”,
“Data”:”123″
}
]
⋅ September 14, 2022
Hello, Sagar!
Thank you for your question.
Kindly note that in Flexmonster, each measure is repeated for every column value, in our case, for every week.
If you want to have two additional measure columns only at the end, as shown in the screenshot, we kindly recommend adding them as another HTML component outside the pivot.
Feel free to contact us if other questions arise.
Regards,
Solomiia
⋅ September 15, 2022
So how can we add that column as HTML component
⋅ September 16, 2022
Hello, Sagar!
Thank you for your swift response.
Kindly note that the approach we have suggested is not about creating exactly the same grid as in your screenshot.
For example, you can create two Flexmonster instances with their containers in a row and place the additional columns in the second one. It would look like a dashboard, with two separate pivots displaying all the desired data.
We hope it helps.
Feel free to ask in case of any other questions.
Regards,
Solomiia
⋅ September 27, 2022
Hello, Sagar!
Hope you are doing well.
Our team is wondering if you had some time to try the suggested approach and add the second Flexmonster instance to display the additional columns.
Could you please let us know if it helps?
Looking forward to hearing from you.
Regards,
Solomiia
⋅ October 4, 2022
Hello, Sagar!
Hope you are having a great week.
Just checking in to ask if the suggested approach of adding the second Flexmonster instance to display the additional columns works for your case.
Looking forward to your response.
Regards,
Solomiia
