Query Dynamic Dates (Month / Week)

Resolved
Izzat asked on March 27, 2017

 Hi, we've purchased a license and interested in deploying the Pivot table as a reporting dashboard.

  1. Is there a way we can display data based on 'Last Week' or 'Yesterday' instead of selecting a specific date/month?
  2. 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? 
Thanks.
 

3 answers

Public
Izzat March 27, 2017

Just to clarify we're using the pivot table to connect to Mondrian data source..

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster March 28, 2017

Hello,
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/nuaez7bh/.
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.
Best regards,
Dmytro.

Public
Izzat March 29, 2017

That clears it up, thanks!

Please login or Register to Submit Answer