asked on December 6, 2021
I want to display values as per attachment please find attachment bellow
please give me a solution for this problem
⋅ December 7, 2021
Hello, Nithin,
Thank you for contacting us.
It seems that there's no attachment below. Could you please send it again?
Looking forward to your response.
Kind regards,
Nadia
⋅ December 7, 2021
Sorry for the mistake, can you please find now
⋅ December 7, 2021
Hello,
Thank you for your response.
Our team kindly asks you to provide us with some details about your use case:
It will help us to find the best solution.
Looking forward to your response.
Kind regards,
Nadia
⋅ December 13, 2021
Hi Nadia,
We are using these values to represent a comparison between planned and actual data on a particular data.
We are getting these values from our data set.
Attached is the screenshot of what we are trying to achieve to make it more clear
⋅ December 13, 2021
Hi Nadia, these are datasets containing values
{
date: "2021-09-01"
product: "DRK"
semifinished: "DRK"
seq: "DRK-1-DRK"
type: "FG"
value: 22992
actual_data:"2299"
}
⋅ December 13, 2021
Hello,
Thank you for the detailed information and the screenshot.
To achieve the desired result, you can use customizeCell and getData API calls. Kindly check a similar example in the following thread: https://www.flexmonster.com/question/columns-with-diffrent-measures/
Please let us know if it works for you. Feel free to contact us if other questions arise.
Kind regards,
Nadia
⋅ December 13, 2021
Nadia Khodakivska, Below code block ,im using for setting report format
this.report = {
dataSource: {
dataSourceType: "json",
data: this.wipData,
mapping: {
date: {
type: 'date string',
format: 'MMM-dd',
},
},
},
conditions: [
{
formula: "'violationcode' == 1",
format: {
backgroundColor: '#ff0000',
color: '#fff',
},
},
{
formula: "'violationcode' == 3",
format: {
backgroundColor: '#fbd300',
},
},
{
formula: "'violationcode' == 2",
format: {
backgroundColor: '#fff',
},
},
],
slice: {
rows: [
{
uniqueName: 'product',
sort: 'unsorted',
},
{
uniqueName: 'semifinished',
sort: 'unsorted',
},
// {
// uniqueName: 'violationcode',
// }
],
columns: [
{
uniqueName: 'date',
},
],
measures: [
{
uniqueName: 'value',
aggregation: 'sum',
format: 'jatin'
},
],
expands: {
expandAll: true,
},
},
options: {
grid: {
/* "showGrandTotals": "rows", */
showHierarchyCaptions: false,
"showGrandTotals": "off",
showTotals: "off"
},
"showAggregationLabels": false,
drillThrough: false,
showAggregations: false
},
formats: [
{
thousandsSeparator: '',
currencySymbol: ' Kg',
positiveCurrencyFormat: '1$',
negativeCurrencyFormat: '-1$',
},
{
name: 'jatin',
decimalPlaces: 2
}
],
};
If it is possible can I get the report format of the code block, I have to display different values I need to display in a single cell
⋅ December 15, 2021
please let me know if it is possible or not... if possible can you come with some solution.
⋅ December 15, 2021
Hello, Nithin,
Thank you for your question.
Our team prepared an example using your report. You can see it on the following JSFiddle: https://jsfiddle.net/flexmonster/Lcq2ets0/
Please let us know if such an approach would work for your case. Looking forward to your response.
Kind regards,
Nadia
⋅ December 22, 2021
Hello, Nithin,
Hope you are doing well.
We were wondering if the solution works for you.
Our team will be glad to hear your feedback.
Kind regards,
Nadia
⋅ December 29, 2021
Hello, Nithin,
Hope you are doing well.
Just checking in to ask if you found the solution helpful.
Looking forward to hearing from you.
Kind regards,
Nadia
