Grouping based on a chart

<p>Hi ,</p><p> </p><p> </p><p> </p><p>I am working on a chart report where I need to show count ( workorders) for each month in a year took count(wokorders) on y axis and month on x axisalso took a commputed column odermonth whcih has been placed on xaxis sorting so that all months will appear in order besides enabling group, now I need to show my chart result based on siteid column , how can i do it . Please le tme know your inputs. Also please find the attached design file.</p><p> </p><p>Thanks.</p>

Find more posts tagged with

Comments

<blockquote class="ipsBlockquote" data-author="kalpana5" data-cid="120813" data-time="1380569386"><div><p>Hi ,</p><p> </p><p> </p><p> </p><p>I am working on a chart report where I need to show count ( workorders) for each month in a year took count(wokorders) on y axis and month on x axisalso took a commputed column odermonth whcih has been placed on xaxis sorting so that all months will appear in order besides enabling group, now I need to show my chart result based on siteid column , how can i do it . Please le tme know your inputs. Also please find the attached design file.</p><p> </p><p>Thanks.</p></div></blockquote>

<blockquote class="ipsBlockquote" data-author="kalpana5" data-cid="120813" data-time="1380569386"><div><p> now I need to show my chart result based on siteid column </p></div></blockquote><p>First of all if you have a date field you can group the data on months. Click on the edit grouping and sorting button to the right of Category (X) Series.</p><p> </p><p>Second what do you mean 'result based on siteid'? Do you want a parameter or an additional grouping by site?</p>

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="120815" data-time="1380570678"><div><p>First of all if you have a date field you can group the data on months. Click on the edit grouping and sorting button to the right of Category (X) Series.</p><p> </p><p>Second what do you mean 'result based on siteid'? Do you want a parameter or an additional grouping by site?</p></div></blockquote><p>Hi ,</p><p>Thanks for the reply, I have already sorted by clicking the button right next to Category axis, I am getting the result in my chart, but there is a column siteid which has two different values 'A', 'B', I need to filter the chart output based on 'A', 'B', for whcih I was grouping on the main table in th layout which did not return the result confined to the siteid based on whether 'A' or 'B'.</p><p> </p><p>Thanks.</p>

<p>Are you using a parameter? Is there a parameter on your data set? Or do you want it just on the chart? Is it really filtered or do you want one chart for each siteid?</p>

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="120827" data-time="1380580200"><div><p>Are you using a parameter? Is there a parameter on your data set? Or do you want it just on the chart? Is it really filtered or do you want one chart for each siteid?</p></div></blockquote><p>Hi ,</p><p> </p><p>Firstly thanks for the reply , there is no parameter for this report , I just want it on the chart, I used the filter option inside the chart but it is not working as expected, yes I do need seperate chart for each siteid I took two data sets one for each siteid but since the main table is bound to primary dataset, not sure if I can insert a table inside the grouping of siteid to display the second one and inside the table group it based on second dataset and drop the chart bounded to second dataset to display the result corresponding to second siteid. Also how can we show both the siteid's in one chart. Please le tme know your inputs.</p><p> </p><p>Thanks.</p>

<p>Why not simply group the report by siteid and then put a chart in the group header. You will then have a chart for each siteid.</p>

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="120854" data-time="1380638069"><div><p>Why not simply group the report by siteid and then put a chart in the group header. You will then have a chart for each siteid.</p></div></blockquote><p>It can be done but it will repeat the first siteid information for the second one also a sit is in the header. That is the reason I followed the second approach.</p>

<blockquote class="ipsBlockquote" data-author="kalpana5" data-cid="120858" data-time="1380642800"><div><p>It can be done but it will repeat the first siteid information for the second one also a sit is in the header. That is the reason I followed the second approach.</p></div></blockquote><p>I do not think so. Not if it is in the group header.</p>

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="120859" data-time="1380642886"><div><p>I do not think so. Not if it is in the group header.</p></div></blockquote><p>I am doing some manipulations inside my sql corresponding to each siteid for whcih it is mandatory as per my requirement to take two data sets, hence followed this approach, in order to get the chart based on second dataset. Please le tme know if you require the rptdesign file, so that you can le tme know your inputs.Thanks</p>

<p>Please provide your detail requirements so I can understand everything before I can provide a solution.</p>

<blockquote class="ipsBlockquote" data-author="kalpana5" data-cid="120851" data-time="1380635266"><div><p>Hi ,</p><p> </p><p>Firstly thanks for the reply , there is no parameter for this report , I just want it on the chart, I used the filter option inside the chart but it is not working as expected, yes I do need seperate chart for each siteid I took two data sets one for each siteid but since the main table is bound to primary dataset, not sure if I can insert a table inside the grouping of siteid to display the second one and inside the table group it based on second dataset and drop the chart bounded to second dataset to display the result corresponding to second siteid. Also how can we show both the siteid's in one chart. Please le tme know your inputs.</p><p> </p><p>Thanks.</p></div></blockquote><p> </p>
<p> </p><blockquote class="ipsBlockquote" data-author="mblock" data-cid="120862" data-time="1380643814"><div><p>Please provide your detail requirements so I can understand everything before I can provide a solution.</p></div></blockquote><p>Sure, basically there are two siteid's corresponding to each siteid I need to show the count of workorders for each month for the following year( year in advance), also a table with the workorder and the asset beside the chart. Please find the below screenshot of how I need to capture the results( expected result). I need to group by siteid ( 2 sites are there and then by town). A red line as shown in graph will be added to show the line that needs to comply with.Thanks.</p>

<p>Some clarification questions:</p><p>1. Why do you need separate queries for each siteid?</p><p>2. Are the towns, locations in Maximo?</p><p>3. Can the list of workorders go beyond the height of the chart? If yes, what do you want to happen?</p><p>4. What version of BIRT are you using?</p><p> </p><p>Again, the more detail you can provide the more we (the community) can help.</p>

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="120866" data-time="1380645381"><div><p>Some clarification questions:</p><p>1. Why do you need separate queries for each siteid?</p><p>2. Are the towns, locations in Maximo?</p><p>3. Can the list of workorders go beyond the height of the chart? If yes, what do you want to happen?</p><p>4. What version of BIRT are you using?</p><p> </p><p>Again, the more detail you can provide the more we (the community) can help.</p></div></blockquote><p>Sure,</p><p> </p><p>1) The reason I took two sepearte queries for each siteid is I took first query and hard coded where siteid = 'IL' and took second query bounded to another dataset with where siteid = 'MO'</p><p>2) town is a custom field for now it can be assumed as location</p><p>3) yes it is what has been mentioned in the specification, want to show the list of workorders with associated assets.</p><p> </p><p>We are considering the workorders only for the following year lets say next year is 2014 need to run the report from 1st jan 2014 to 31 Jan 2014 that is how data is being restricted.</p><p>4) Birt 3.7.1</p><p> </p><p>Also attached the whole purpose of the report to be more specific.Please let me know if there is anything which is missing .</p><p> </p><p> </p><p> </p><p> </p><p> </p><p>Thanks.</p>

<blockquote class="ipsBlockquote" data-author="kalpana5" data-cid="120867" data-time="1380646363"><div><p>Sure,</p><p> </p><p>1) The reason I took two sepearte queries for each siteid is I took first query and hard coded where siteid = 'IL' and took second query bounded to another dataset with where siteid = 'MO'</p><p>2) town is a custom field for now it can be assumed as location</p><p>3) yes it is what has been mentioned in the specification, want to show the list of workorders with associated assets</p><p>4) Birt 3.7.1</p><p> </p><p>Also attached the whole purpose of the report to be more specific.Please let me know if there is anything which is missing .</p><p> </p><p> </p><p> </p><p> </p><p> </p><p>Thanks.</p></div></blockquote><p>Hi,</p><p> </p><p>Got the output as per the siteid, modifed the query and took the siteid as group and in the header kept the chart now it is giving the chart output for each siteid( by adding a filter), but I need to add the marker on y axis whose value is different for each siteid , is there any filter concept for markers to change as per siteid , please let me know your inputs.</p><p> </p><p>Thanks,</p>

<p>You can add a marker line (button at the bottom of the GUI) or add a computed field to the dataset and use that.</p>

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="120869" data-time="1380649863"><div><p>You can add a marker line (button at the bottom of the GUI) or add a computed field to the dataset and use that.</p></div></blockquote><p>Could you please explain a bit in detail. How can we use the dataset in the marker there is no option in the markers where we can access the dataset when I see could you please point me out there.Thank You.</p>

<p>OK, so I built the attached example. I hope it has everything you need. I did a bunch of things:</p><p> </p><ul class='bbcol decimal'><li>I am using the Drop-Detail on the cell with the chart (that is why it looks like the chart and details are together). </li><li>I created a marker </li><li>I added another series that is based on data for the line.</li></ul><p>I hope this helps.</p>

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="120879" data-time="1380658680"><div><p>OK, so I built the attached example. I hope it has everything you need. I did a bunch of things:</p><p> </p><ul class='bbcol decimal'><li>I am using the Drop-Detail on the cell with the chart (that is why it looks like the chart and details are together). </li><li>I created a marker </li><li>I added another series that is based on data for the line.</li></ul><p>I hope this helps.</p></div></blockquote><p>Hi ,</p><p> </p><p>Thanks for the file, I am not able to open the report design file, when I open it is erroring out saying clipse 3.2.23 is not supported , mine is eclipse 3.2.22. I also have have Eclipse 2.3.2 .</p><p> </p><p>Thanks.</p>

<p>edit the file in a text editor and replace this line at the top with one from your designer</p><p> </p><div> <property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20121022-1705 Build <3.7.2.v20121022-1705></property></div>

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="120879" data-time="1380658680"><div><p>OK, so I built the attached example. I hope it has everything you need. I did a bunch of things:</p><p> </p><ul class='bbcol decimal'><li>I am using the Drop-Detail on the cell with the chart (that is why it looks like the chart and details are together). </li><li>I created a marker </li><li>I added another series that is based on data for the line.</li></ul><p>I hope this helps.</p></div></blockquote><p> </p><p> </p><blockquote class="ipsBlockquote" data-author="kalpana5" data-cid="120880" data-time="1380659443"><div><p>Hi ,</p><p> </p><p>Thanks for the file, I am not able to open the report design file, when I open it is erroring out saying clipse 3.2.23 is not supported , mine is eclipse 3.2.22. I also have have Eclipse 2.3.2 .</p><p> </p><p>Thanks.</p></div></blockquote><p> </p>
<p> </p><blockquote class="ipsBlockquote" data-author="mblock" data-cid="120881" data-time="1380659848"><div><p> </p><p>edit the file in a text editor and replace this line at the top with one from your designer</p><p> </p><div> <property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20121022-1705 Build <3.7.2.v20121022-1705></property></div><p> </p></div></blockquote><p>Thank You, I was able to open the file, but as shown in screen shot when I click the Current chart is invalid if you wish button it brings up empty chart. I can see the code if (row["cOUNTRY"] == "UK") {5} else{7}, my doubt is how do I associate it to maker on yaxis ( as I am not able to see the chart).</p>

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="120881" data-time="1380659848"><div><p> </p><p>edit the file in a text editor and replace this line at the top with one from your designer</p><p> </p><div> <property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20121022-1705 Build <3.7.2.v20121022-1705></property></div><p> </p></div></blockquote><p> </p><blockquote class="ipsBlockquote" data-author="mblock" data-cid="120881" data-time="1380659848"><div><p> </p><p>edit the file in a text editor and replace this line at the top with one from your designer</p><p> </p><div> <property name="createdBy">Eclipse BIRT Designer Version 3.7.2.v20121022-1705 Build <3.7.2.v20121022-1705></property></div><p> </p></div></blockquote><p>Hi ,</p><p> </p><p>Thanks for the reply , I am able to see the query and the computed column where it was set as if country = 'UK' {5} else 7, but how will I associate to MArker, I am not able to see the chart, when I click on the red box current chart is invalid empty chart pops up, could you please send me a screen shot of how you have added the marker if you do not mind I am missing the chart part.</p><p> </p><p>Thanks.</p>

<p>Hope these images will help you create the chart. Note the additional series on the first image.</p>

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="120885" data-time="1380661135"><div><p>Hope these images will help you create the chart. Note the additional series on the first image.</p></div></blockquote><p>Thank You so much will implement this one in report.</p>

<blockquote class="ipsBlockquote" data-author="kalpana5" data-cid="120886" data-time="1380661262"><div><p>Thank You so much will implement this one in report.</p></div></blockquote><p>Hi,</p><p>When I add new series and add marker value of 10 on y axis marker button it is hsowing value 10 on both the charts for both the siteid's as shown below in the place of 10 I need two different values to show up, could you please let me know your inputs.</p><p> </p><p>Thanks.</p>

<blockquote class="ipsBlockquote" data-author="kalpana5" data-cid="120900" data-time="1380724299"><div><p>Hi,</p><p>When I add new series and add marker value of 10 on y axis marker button it is hsowing value 10 on both the charts for both the siteid's as shown below in the place of 10 I need two different values to show up, could you please let me know your inputs.</p><p>The line which I striked out with blue arrow is the marker value it is showing interms of plots as new series has been added I want to show marker in place of that as shown in below screenshot.</p><p> </p><p>Thanks.</p></div></blockquote>

<p>OK, I put an example here. I know you cannot open the chart, but the code is in the DevShare detail</p><p> </p><p><a data-ipb='nomediaparse' href='http://www.birt-exchange.org/devshare/_/designing-birt-reports/dynamic-marker-line-based-on-data-r1558'>http://www.birt-exchange.org/devshare/_/designing-birt-reports/dynamic-marker-line-based-on-data-r1558</a></p>

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="120913" data-time="1380747407"><div><p>OK, I put an example here. I know you cannot open the chart, but the code is in the DevShare detail</p><p> </p><p><a data-ipb='nomediaparse' href='http://www.birt-exchange.org/devshare/_/designing-birt-reports/dynamic-marker-line-based-on-data-r1558'>http://www.birt-exchange.org/devshare/_/designing-birt-reports/dynamic-marker-line-based-on-data-r1558</a></p></div></blockquote><p>Thank You much , it worked.</p>