🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Using complex data structure as field

Answered
Gregory asked on February 18, 2021

Hi Flexmonsters,
Found you product almost ideal for currently developing application, but stuck with one particular case. Could you please help me?
The case. I need to display amount of books sold grouped by author per month, by following data:

[{
id: 123,
title: 'Rolling Stones',
author: {
id: 345,
name: 'O. Henry'
}
},{
id: 865,
title: 'Some book',
author: {
id: 883,
name: 'Jim Smith'
}
},
...,{
id: 981,
title: 'Another book',
author: {
id: 884,
name: 'Jim Smith'
}
}
,...]

The problem. There are two books written by different authors with the same name and these books must be in different groups. Is it possible to do so?
Looking forward to hearing from you

2 answers

Public
Milena Pechura Milena Pechura Flexmonster February 19, 2021

Hello, Gregory,
 
Thank you for the kind words about our component and for describing your case in detail.
 
Please note that the nested JSON format is not supported in Flexmonster. Therefore, our team kindly suggests preprocessing your data to the plain format.
 
Talking about your issue, we recommend adding an identifier to the author’s name. This will help distinguish different authors with the same name.
We have prepared an example for illustration: https://jsfiddle.net/flexmonster/pk6bjorw/.
 
Please let us know if it helps and if any other questions arise.
 
Best regards,
Milena

Public
Gregory February 22, 2021

Thank you Milena. That solves my problem.

Please login or Register to Submit Answer