March 28, 2016 at 11:36 pm
Hello All,
I have below numbers that I need to show all in single chart in SSRS. Can you suggest me which Chart Type should I use. ?
The catch here is the column Total should stand out and should be visible among all the other counts. i guess i can use stacked bar chart type here but are there any other options that I have?
TimeStampTotalCntNetwaitCntActiveCntauthwaitCntdbwaitCntclntwaitCntcmitwaitCntCompletedCntfswaitCntKilledCntlbrwaitCntlckfwaitPurgwaitCntTrigwaitCnt
2016-03-28 22:33:03.3602482271900200000000
2016-03-28 22:32:03.1572772334000400000000
2016-03-28 22:31:02.6602722392810400000000
2016-03-28 22:30:03.4802812522320400000000
2016-03-28 22:29:03.0202982613120400000000
2016-03-28 22:28:03.0302782353801400000000
2016-03-28 22:27:09.0572702224510200000000
2016-03-28 22:26:02.5332822384110200000000
2016-03-28 22:25:02.7402452083410200000000
2016-03-28 22:24:02.6802201922600200000000
2016-03-28 22:23:02.83025620436140200000000
March 29, 2016 at 4:27 am
Not sure if I'm I'm just reading this wrong, but if you were using a stacked bar chart you would exclude the total value, as that would be the whole bar, i.e. the sum of the other parts, otherwise you will double to total of the bar size.
Given that this appears to be a time series I'd probably suggest a stacked area chart or stacked line if it's easier to read.
There is no stacked line chart type, but you can change a stacked area to to be a stacked line chart by setting the Series fill to No Color and setting the Border line type and color for the line.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply