How to add two columns in the end of table

Answered
Sagar Ninave 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″
}
]

Attachments:
2.png

5 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 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

Public
Sagar Ninave September 15, 2022

So how can we add that column as HTML component 

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 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

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 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

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 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

Please login or Register to Submit Answer