Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is there any way I can get the line chart based on below data,
YearMonth | Date | Value |
201507 | 20150703 | 0.4 |
201507 | 20150710 | 0.6 |
201507 | 20150717 | 0.9 |
201508 | 20150807 | 1.2 |
201508 | 20150814 | 1.4 |
201509 | 20150907 | 1.5 |
201509 | 20150911 | 1.6 |
201510 | 20151002 | 1.7 |
201511 | 20151106 | 1.2 |
201511 | 20151113 | 0.7 |
201511 | 20151120 | 1.4 |
201512 | 20151204 | 1.8 |
201512 | 20151231 | 2 |
201601 | 20160108 | 2.5 |
201602 | 20160205 | 1.5 |
201602 | 20160212 | 0.9 |
201602 | 20160219 | 1.3 |
now, my requirement is on my x axis there will be only YearMonth but, values should get plotted based on date wise value. Which means for YearMonth 201507 there should be three data points.
Please see attached image as reference.
Regards,
Vijeta
Message was edited by: vijeta sharma
Why three points needed? If so, I can say Add these two dimensions and disable the Legend
H !i Vijeta,
This is how you can do.Please see screenshot and attached qvw.
H
Regards,
Mayank Raoka !
This I have already tried but, it's not showing lines connecting the data points
because for 201507 we have 3 dates values.Though I disable the legends my x axis will show dates only but, i need yearmonth.
Take First Dimension as YearMonth and Second dimension as Date
That I have tried but, it's showing chart as mayankraoka shown it's not creating line which will connect my data points
Hi Vijeta,
this is what you want.Try the workaround i have provided in attached qvw.
Regards,
Mayank
In your application i can't see x axis labels. Even I have copied same chart into my application but on X-axis its showing all dates