Let the user select a date range in Cockpit view without filtering

Question

Hello,

I have a bar chart with events. Users should select easily a time frame for which the events should be displayed.

The filter option in the edit mode shouldn't be used for it as I don't want the user to have to go into edit mode.

So I basically want a selection at the top of the chart where the user can select a start point and a end point.

Any advice how to achieve this is welcomed.

THx

Comments

Hi! Where you able to create the range filter ?

Answer 1

Hi Telopk,

There are several ways to accomplish your task.

I would first suggest you to develop your chart inside the cockpit area (so you should develop a cockpit document).

I would suggest to add a range column to the dataset on which you develop your chart.

For instance, let us suppose that your (query) dataset returns the product_name, the_date, store_sales, unit_sold (of 2017).You  can extract (using the corresponding function) the_month from the_date column .

Now you create your cockpit document using that dataset.  Your chart shows store_sales and unit_sold on product_name.

Then add a selector widget that filter the dataset on the month column. Therefore, selecting the_month values from selector widget all widgets based on that dataset are filtered too.

Otherwise if you want to develop only a chart document you must create ad-hoc LOV and Analytical and associate them to the chart document.

I based my answer thinking of a query dataset but the procedure can be the same for other dataset types.

I wish I was of service.

Regards,

Nunzia

Comments

Hello,

I have the same problem as Telopk. But I need to inform start and end date. The filter per month does not solve me.
The date option in the selector allows me to select several dates, but I cannot enter a period, with start and end dates.
I tried to use Analitycal Driver and Parameters, but then I can only indicate the period once, and I cannot change it.
Is there a solution for me to simply inform a start and end date?

This would be very important for many users who use the knowage.

Answer 2

Hello,

I have the same problem as Telopk. But I need to inform start and end date. The filter per month does not solve me.
The date option in the selector allows me to select several dates, but I cannot enter a period, with start and end dates.
I tried to use Analitycal Driver and Parameters, but then I can only indicate the period once, and I cannot change it.
Is there a solution for me to simply inform a start and end date?

This would be very important for many users who use the knowage.