Query Dynamic Dates (Month / Week)
Hi, we’ve purchased a license and interested in deploying the Pivot table as a reporting dashboard.
- Is there a way we can display data based on ‘Last Week’ or ‘Yesterday’ instead of selecting a specific date/month?
- Is there any way we can pass custom MDX query through the Pivot Table?
If it’s not possible, any plan to incorporate these feature in the upcoming releases?
Just to clarify we’re using the pivot table to connect to Mondrian data source..
Thank you for your question.
1.For now, there are no features which allow doing that. We have added your request to the customer’s wish list. I am afraid I cannot provide you with an estimated time frame right now. However, we will notify you when the situation is changed. As a workaround, you can make the pre-filtering using our setFilter() API call. Here are the links on our doc – http://www.flexmonster.com/api/setfilter/ and the jsFiddle example http://jsfiddle.net/flexmonster/mq32shu2/.
2. There is nothing we can suggest you here. We have also added this request to the customer wish list, but there is no estimated time frame. We will notify you when the situation is changed.
Please let us know if you have additional questions.
That clears it up, thanks!