Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
the month-year values are different hence the lines are not merging..
share the sample qvw.
you can use a scroll bar.
Hi Krishna Chaitanya,
Im looking for a chart something like:
but my chart is seperated with trends like:
Use 2 Dimensions (Month and Year) and 1 Expression : Count()
the month-year values are different hence the lines are not merging..
share the sample qvw.
Thanq Krishna Chaitanya,
I will load them with same month name seperated by year.
Thanq verymuch.
Thanq Antonio.
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: