How to filter the specific month (take the data from the last month of the period?)

Hello, Randolph,
 
Thank you for writing to us.
 
Our team has investigated all your questions and came up with several ideas.
However, to suggest an appropriate solution, we need to understand how your data is organized (years, months, etc.).
 
Could you please send us your data structure or just some sample data?
This will greatly help us to understand your case better.
 
Looking forward to hearing from you.
 
Best regards,
Milena

Hi, Randolph!
 
Thank you for preparing the example.
Please find our suggestions below.
 

1. To filter a specific month, the filter object should be specified for the field in the slice. Here is a code snippet for your reference:

   "slice": {
     "columns": [
       {
         "uniqueName": "Datum",
         "levelName": "Datum.Year",
         "filter": {
           "members": [
             "datum.[2019].[december]"
           ]
         } 
       }
   ],
   ...
   }

   We have also modified your example by adding mentioned filter: http://jsfiddle.net/flexmonster/7udwe6ka/.
   The filter can also be configured via UI: click on the field name on the grid and select a desirable month.

2. For the last month of the current year, our "Last..." filter can be used: http://jsfiddle.net/flexmonster/m8s2whcg/.
   Please read the details about conditional filters for dates here: https://www.flexmonster.com/api/conditional-query-object/?target=date.
   To specify this filter using UI, click "Datum" -> "Filter by dates" -> "Last..." and "Month".
3. To show the data by quarters, define the year/quarter/month/day type in the mapping:

   "mapping": {
     "Datum": {
       "type": "year/quarter/month/day"
     }
   }

   Then specify Quarter in the levelName of the field in the slice:

   "columns": [
     {
       "uniqueName": "Datum",
       "levelName": "Datum.Quarter"
     }
   ]

   After this, filter the last months of the quarters. 
   Here is a sample for illustration: http://jsfiddle.net/flexmonster/6x4rjk5a/.
   To clarify, Flexmonster provides an option to filter a particular month, however, the component cannot find the last month of the quarter by itself. Therefore, months should be filtered as in the example above.

Please note that all mentioned filter options can also be defined via the setFilter() API call. 
 
Let us know if the suggested approaches would work for you.
We are looking forward to your response.
 
Kind regards,
Milena

Hello, Randolph,
 
Thank you for providing further information about your case.
 
We would like to explain that a parent level of the hierarchy can show only the aggregation of its children's values.
Therefore, it's impossible for a year which contains 4 quarters to show the value of one quarter.
The best solution for this case is to create a mechanism that will change the slice according to user's needs.
 
Please have a look at the example we prepared for you: http://jsfiddle.net/flexmonster/k9qs58fg/.
In the context menu, we added two items, which are responsible for changing the chart. The click on the "Drill down" button will show the data by quarters, "Drill up" – by years.
More details about customizing the context menu can be found here: https://www.flexmonster.com/api/customizecontextmenu/.
 
Do not hesitate to contact us if you have any questions regarding the example.
Also, please let us know if the suggested approach would work for you.
 
Best regards,
Milena

Hello, Randolph,
 
We are glad to hear that our answer helped.
 
Our team would like to confirm that it is possible to customize labels on the chart.
For this purpose, Flexmonster provides customizeChartElement API call.
 
Please see the example we have prepared for you: http://jsfiddle.net/flexmonster/tuyLxzcg/.
In the customizeChartElementFunction (lines 209-215), we took the year from the data object and added it to the element.
 
Let us know if the provided example would work for you.
 
Best regards,
Milena

Hello, Randolph,
 
We are reaching out to ask if the provided approach works well for you.
 
Looking forward to your feedback.
 
Regards,
Illia

Hi, Randolph,
 
Thank you for your question.
 
Our team has modified the following example according to your needs: http://jsfiddle.net/flexmonster/v89s5khz/. Please try to select the measure via UI, then drill down or up.
Find some explanations regarding the example below.
 
In the showQuarters and showYears functions (109 and 219 lines correspondingly), we took the selected measure using getOptions() API call and set a new report with this measure.
Please note that the selected measure is specified in the options.chart.activeMeasure object of the report:

"options": {
  "viewType": "charts",
    "chart": {
      "activeMeasure": {
        "uniqueName": "Marktwert",
        "aggregation": "sum"
      }
    }
  }

 
Let us know if our answer helped.
 
Kind regards,
Milena

Hello, Randolph,
 
Hope you are doing well!
 
We were wondering whether our response was helpful.
Could you please let us know if our example worked for you?
 
Waiting for your answer.
 
Regards,
Milena