asked on November 4, 2021
Greetings,
we have assembled the test in javascript and before purchasing the software we would like to understand if it is possible to constrain in the rows in which there are not, as in the example, the information of columns G4 and G5 (blank) so that the system does not propose the arrow to go down a level but stop at the level where the data is present.
our problem is that in the same pivot some rows have all the levels while others have only a few.
our goal is not to make the arrow appear, and therefore the relative (blank) where no further levels of detail are foreseen
⋅ November 5, 2021
Hello, Daniele,
Thank you for reaching out to us.
We suggest organizing all the G fields into a hierarchy. In this case, blank leaf members will not be shown on the grid. Please note that "blank" members which contain children still will be shown and drillable.
Here is the JSFiddle we prepared for your reference: https://jsfiddle.net/flexmonster/8f3g9sou/.
Please let us know if it works for you.
Kind regards,
Illia
⋅ November 9, 2021
Ok Illia,
the visualization is perfect but now I can't see the columns with the possible months.
You can view my json data here:
https://goprofit.2digit.sm/gest/test.php?Azione=datashare
It's possibile to make this?
Thanks
⋅ November 9, 2021
Hello, Daniele,
You can specify the desired fields in the SliceObject of the report. For example, add the "Mese" field to columns to achieve the desired result: https://jsfiddle.net/flexmonster/f71ahgub/.
Please let us know if it helps.
Kind regards,
Illia
⋅ December 22, 2021
Good Morning Illia, thanks for your help.
I bought the license and I have 2 more questions.
the first:
if I set the display of the name of the month he sorts the columns alphabetically. would it be possible to sort the columns by date so that the months are properly sorted by number and not alphabetically?
second:
How can I disable the sorting arrows on the lines? is it possible not to display the various G1 G2 on the lines ... and perhaps replace them with + and - to expand the levels?
Thanks
Daniele
⋅ December 23, 2021
Hello, Daniele,
Thank you for your response.
"months": {
"april": "Aprile",
"august": "Agosto",
"december": "Dicembre",
"february": "Febbraio",
"january": "Gennaio",
"july": "Luglio",
"june": "Giugno",
"march": "Marzo",
"may": "Maggio",
"november": "Novembre",
"october": "Ottobre",
"september": "Settembre"
}
Alternatively, we suggest localizing the component with the Italian localization file from our CDN:
new Flexmonster({
container: "pivotContainer",
global: {
localization: "https://cdn.flexmonster.com/loc/it.json"
},
...
});
The detailed guide you can find in our documentation at the following link: https://www.flexmonster.com/doc/localizing-component/. After defining the localization, you should set the month field's type to "month" in the mapping object.
"sorting" property of the Options object to false. It is also possible to only show the sorting controls in rows or columns. Simply set the "sorting" to "rows" or "columns"."showHierarchies" property of the Options object to false.
Please let us know if it works for you. Feel free to contact us if other questions arise.
Kind regards,
Nadia
⋅ December 30, 2021
Hello, Daniele,
Hope you are doing well.
We were wondering if our response helped you with your question.
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ December 31, 2021
Hi Nadia,
I think that to set the type of localization I have to pass the date in a different format in the given object.
Now I pass the month value in string as you can see from the previous help of a colleague (https://jsfiddle.net/flexmonster/f71ahgub/)
do you have a example of what I have to do and set?
Thanks and happy new year
⋅ January 4, 2022
Hello, Daniele,
Thank you for the response.
If you set the month names in the data source with the numbers, they will sort alphabetically in the proper order. However, if you set the localization, you can leave month names without numbers, and still, the months will be in the correct order. Please check the example on the following JSFiddle: https://jsfiddle.net/flexmonster/wLak6hvm/
We hope it helps. You are welcome to write to us in case further questions arise.
Kind regards and Happy New Year,
Nadia
⋅ January 11, 2022
Hello, Daniele,
Hope you are doing well.
We were wondering if our response helped you with your question.
Our team will be glad to hear your feedback.
Kind regards,
Nadia
⋅ January 18, 2022
Hello, Daniele,
Hope you are doing well.
Just checking in to ask if you had a chance to try the suggested approaches. Could you please let us know if our response helped?
Looking forward to your response.
Kind regards,
Nadia