linechart trend

[markgraham123]

Hi all,

In a line chart,

I'm using Month and Year as dimensions and COunt(Distinct()) function in expression.

I'm was trying to get the trend for 2014 and 2015 one above the other. But, my years were seperated and eventually consuming more space on the front end.

Can someone look into this.

Please find the screenshot for current trend.

[krishna_2644]

you can use a scroll bar.

[markgraham123]

Hi Krishna Chaitanya,

Im looking for a chart something like:

but my chart is seperated with trends like:

[antoniotiman]

Use 2 Dimensions (Month and Year) and 1 Expression  : Count()

[krishna_2644 · Accepted solution]

the month-year values are different hence the lines are not merging..

share the sample qvw.

[markgraham123]

Thanq Krishna Chaitanya,

I will load them with same month name seperated by year.

Thanq verymuch.

[markgraham123]

Thanq Antonio.

[krishna_2644]

You Welcome.

You can try something like this:

Put these in your chat

Dimension :   Month or Year

Expressions : Sum({<year={$(=max(year))}>}field)    //for current year

                     Sum({<year={$(=max(year)-1)}>}field)  //for previous year

output: