Line Chart

[smilingjohn]

Hi All,
I am trying to get a line charts ,
for daily dates by severity .

after implementing the chart i just get one single line with different colors for all the severity
I have four Severity and my requirement is to show all the 4 lines in the chart how do i get this .

Please find the sample data attached .

[Surya]

Right ow you are taken dimension date and severity remove dimension date u got output

[smilingjohn]

Hi Surya ,

This is the sample data i have shared with only two fields , in real i have many fields and i need to show the line chart 

using date and severity . 

If i remove the date then it will show by severity for all the keys, 

but my requirement is to show it by date and severity  . 

Thanks in advance 

[Surya]

Your requirement is not clear., every day having one one value...so as per your provided data its working fine for ex today date taken 1 ..expression u return count(today) that s also 1 so thats y u got single line

[Surya]

you just try dimension date expression count(seviertry)

[raman_rastogi]

Hello,

For four different lines based on severity you need to create four expressions.

Something like this

Dim- Date

Exp

1-count({<Severity ={'Severity 1'} > }Dailydate)

2-Exp1- count({<Severity ={'Severity 2'} > }Dailydate)

3-........

Regards

Raman 

[smilingjohn]

Hi Raman

Thanks for the reply , I used four expression but still i see single line ..

please find the attachment of the QVW file 

[raman_rastogi]

Hi,

it is creating one single line because values of all expressions are same , all lines are overlapping .

Once try with actual data if issue still persist use different chart like stack bar chart.

Thanks,

[smilingjohn]

I converted it to a bar chart , please look into the attachment in which for severity 3 it is showing three times for 23 Sep 2019

it show 3 counts right ?  why is not the date showing one time , why is it repeating for all the severity . 

I am really confused 

[smilingjohn · Accepted solution]

Got the solution , 

Actually i have to convert  the  date format  like date(floor(date),'DDMMYY')as Date and this resoved the issue