nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Grouping time data in a dashboard

Ben Sztucki

Hi Guys hope you will be able to help me with my problem, 
 
I currently have a Birt dashboard set up that has a number of charts and tables on it. Currently i have a number of filters set up mainly using the checkbox gadget. The main problem I'm having is that I can't filter the results by time properly. At the moment I can add a gmt_time column to a filter gadget but it then includes EVERY gmt_time result and in some cases this could be 100,000 + results. 
 
Is there a way for me to group them into days and have two calender gadgets start/end to determine the time period more appropriately.
 
If you need any more details or have questions let me know. 
 
Thanks in advance,
 
Ben

Find more posts tagged with

Comments

GLO_FR

Hi,
 
for the moment, there is no gadget which allow you to select a period.
 
The only way I know is tricky because you need to modify the dashboard/gadget manualy.
 
1) in your datadesign, you have to duplicate the date column
2) on your dashboard, create 2 date selector gadgets. Name the first one "Start date" and use the first date column of your BDO.
Name the second one "End date" and use the second column
3) Edit the .dashboard file (=xml) with the xml editor and search the operator of the first date selector. By default it is 
<pre class="_prettyXprint _lang-xml">
<property name="operator">eq</property> </pre>
Change it to "ge" or "gt"
4) Repeat this with the second date selector and change the operator to "le" or "lt"
5) Save and launch your dashboard normally
 
Unfortunatly, if you edit/modify the date selector afterward, the operator will be change/reset to "eq".

Ben Sztucki

Thats great thanks I will have a look into it

Could you also have a little look at another question that I have posted: 
 
<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/35501-setting-number-of-plots-on-a-line-chart/'>http://developer.actuate.com/community/forum/index.php?/topic/35501-setting-number-of-plots-on-a-line-chart/</a>
 
If you could that would be awesome

I have managed to do this using reportlets the problem is that by doing that it then refreshes the cache as it is going back to the query and executing it which may not be very scalable depending on the number of users. Which is why I want to do it like this. 
 
Thanks