Get Free Trial

3 doubts (1- Export all data from dimensions pre selected, 2- How to pre define the dimensions from the filter box and 3- How to set max or min values in the Y axis from graphs).

María Andrea Pérez asked on November 16, 2016

Hello, my name is María Andrea. I contact you because I am a developer who works on the url web site that I wrote in the optional label, the purpose of this message is because I need to know how I can export in different formats all the information it is contained in the graphs or grid because I can export them well but there is no aditional information of the filters, columns, rows and so on…for me it is very important to know how can I fix this so when I decide to export it by graph or grid in any format I could read the whole informacion of the report I designed previously; also I want to know if in tha graphs I can set max or min value in the Y axis so I can decide wich number it has to appear in it. And I would like to know if there is a way to pre define the dimensions that goes on the filters section, I mean the first box that contains the filters of the report, if someone can guide me in these 3 doubts I will be so glad to know it so I can fix it. Thanks for your time and support. Let’s be in touch, I will be waiting for you answer. Regadles, María Andrea Pérez H.

6 answers

Ian Sadovy Ian Sadovy Flexmonster November 18, 2016

Hello María Andrea,

Thank you for your questions.  

1- Export all data from dimensions pre selected
Exporting to PDF, Excel, HTML, etc. is created to save only that you see on the grid or graph.
Also, you can save report in JSON format, it will save all the information and can be opened with Flexmonster Pivot component later.  

2- How to pre define the dimensions from the filter box
Yes, you can pre define filters using slice.pages property of the Report Object.  

3- How to set max or min values in the Y axis from graphs
Min and max values are calculated automatically for our charts and there is no option to specify them manually.  

Please let me know if you need any further details.  


María Andrea Pérez November 21, 2016

Heyyy!!! Thank you very much Ian Sadovy, I’m gonna do it so we can stay in touch in case I need more guidance.
I really appreciate your help and time..
María Andrea Pérez Hernández.

María Andrea Pérez December 5, 2016

hello Ian, how are? I’m writing you again because I have some doubts about your answers but may be I didn’t express myself corecctly so here I go:

  1. I want to export the report previously selected with dimensions, filters and so on; in a pre selected format (image, excel, etc) but I want to read the whole information selected in the report, I mean when I choose image format I can’t read the dimensions, filters and so on that I selected previously because now I just can read like in general terms but what I really want is to read the whole information I choose right there on my screen and the same when I export it so…how can I add the whole text into my different formats so I can be aware of the content of my report.
  2. Then I already programed the dimensions that belong to the 3 boxes that are in the fields option (Row, columns and values)… but I can’t program the 1st box that contains Report Filters because I try with the options you gave me but It does not work I mean it does not appear the dimension I programed there, so my doubt is do you have a special name to do it like in the 3 boxes I mention before?

So those are my questions for you, I will wait for your answer thanks for you guidance.
Have a nice afternoon.
María Andrea

Ian Sadovy Ian Sadovy Flexmonster December 7, 2016

Hello María Andrea,
Thank you for the questions.

  1. Actually, there is no option to save dimensions, filters and so on by exporting to an Image, Excel, etc. Please check this video, it shows how to save full reports with all data using JSON format – Does it work for you?
  2. I have prepared a live example for Report Filters – Please note that it uses version 2.3 API (if you are using version 2.2 API, the code might be different).

Please let me know if it works for you.

Claudio Gambetti April 30, 2018

Hello Ian,
we’ve a similar request to the point 3 coming from María Andrea.
Our client is trying to use the Pivot Charts to display effectiveness data, so it’s important for them to format the axis with fixed minimum (e.g. 0) and maximum (e.g. 100) like they use to do with Pivot Excel.
Can you evaluate to strengthen the configuration features for Pivot Charts?

Ian Sadovy Ian Sadovy Flexmonster May 1, 2018

Hello Claudio,
Thank you for the question.
As for the charts, min and max values for Y axis are still calculated automatically. If data is prepared properly, you may achieve the desired result (i.e. Please note, there is autoRange option that controls min/max logic for Y axis.
Also, since we released integration with third-party charts you can create more advanced visualizations using Highcharts, FusionCharts, etc.
Hope it helps.

Please login or Register to Submit Answer