sql server - SSRS chart labels -


i need figuring out how accurately display labels in stacked chart in ssrs; need single represenation of upper stack in below chart.

the chart has 2 states, can either based on red or green data, both in same data source.

at moment chart looks (this based on green data):

enter image description here

as can see both labels inside chart , legend absolutely cluttered. idea have legend have 2 items (late issues , not finished issues); 1 displays non-finished issues , 1 displays non-finished issues outside estimated due-date.

for reference: above chart should have 1 non-outstanding issue , 5 outstanding issues (3 ongoing , 2 open, see below further info stages).

enter image description here

inside chart want have numerical respresentation of above requirements. number representing outstanding issues , 1 shows non-finished issues.

this red representation looks like:

enter image description here

at point i'm not sure wrong anymore. mentioned both run on same dataset, different values.

the red tracker has simple true/false value runs of data whereas green tracker has numerical representation of 3 values (5-7). data represent is: 5 - open, 6 - ongoing, 7 - closed.

i've attempted green data both when series either of 3 above mentioned numbers, when it's getting un-closed (5,6 not 7).

this code set labels maroon part of chart (it's workable snippet.):

iif(count(iif(fields!outstanding.value = 1 ,  fields!trk_trackerstatus_lkid2.value <> 7, 1, nothing)) = 0, "", count(iif(fields!outstanding.value = 1  ,  fields!trk_trackerstatus_lkid2.value <> 7, 1, nothing))))

basically checking if there more 0 items outstanding , aren't finished (are not 7). if there more 0, sets label. if there 0 counted items, label should empty string.

i think wanting group series data based on status number. can either case statement in dataset query or can use expression in series group:

the expression have used there follows:
=switch(fields!status.value = 5, "group 1", fields!status.value = 6, "group 2", fields!status.value = 7, "group 2", true, "group 3")

this esentially assigns grouping value data based on values in field. in case, status of 5 becomes group 1, status of 6 or 7 becomes group 2 , other values become group 3 ensure bad data obvious on report.

what takes chart displayed raw data (on left) , turns think how want see (on right):

you need apply same logic chart labels well. reason recommend add column original sql script grouping you, have make changes once.


-

Comments

Post a Comment

Popular posts from this blog

java - SSE Emitter : Manage timeouts and complete() -

i writing web app multiple listeners(evcentsource sse clients js) connected server . want store sse emitter per connected listener : can done in memory or other means assigning id each client able achieve far now question ; how send response/event specific client connected web app ? while doing sseemmiters stored either getting completed or timed out. how prevent ? how keep sseemmiter available open infinite time (till client closes) , send events selectively .
Read more

jquery - uncaught exception: DataTables Editor - remote hosting of code not allowed -

i'm trying implement crud operation using datatableseditor using datatables.but i'm getting error messages: 1)uncaught exception: datatables editor - remote hosting of code not allowed. please see http://editor.datatables.net details on how purchase editor license 2)typeerror: a.editor undefined 3) $.fn.datatable.editor not constructor" what reason? here configuration: <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1"%> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> <title>insert title here</title> <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.12/css/jquery.datatables.min.css"> <link re...
Read more

java - InvalidDataAccessApiUsageException: Parameter value element did not match expected type -

i'm trying execute in query using spring data. model looks this: @entity @table(name = "customer", schema = "public", catalog = "postgres") public class customerentity { private int id; private string name; private int balance; private string bankid; @id @column(name = "id") public int getid() { return id; } public void setid(int id) { this.id = id; } @basic @column(name = "name") public string getname() { return name; } public void setname(string name) { this.name = name; } @basic @column(name = "balance") public int getbalance() { return balance; } public void setbalance(int balance) { this.balance = balance; } @basic @column(name = "bank_id") public string getbankid() { return bankid; } public void setbankid(string bankid) { th...
Read more