Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have fields named as Month 1, Month 2, Month 3, Month 4, Month 5.
Where Month 1 is current month and month 2 till month 5 are next months.
What i want is when i select Dec 2017 from filter pane, my month fields name should change according to selection in chart.
Example data
I select Dec 2017 the month fields name changed from Month 1 to Dec-17, Month 2 to Jan-18, Month 3 to Feb-18 and so on.
And when Jan 2018 is selected from filter then the months fields name should changed as per below snap.
Want this in bar chart
Is this possible? If yes then please help
Thanks
try this
get all the distinct year-month values in the script and assign them 1 to N in ascending order. I mean to say creat a dual field something like
load yearmonth,dual(year-month,value) as abc
value should be 1 to n and should be different for all months .
in the labels
use
text(concat(value)) or you can use getfield selection as well --1st expression
text(concat(value)+1) --2nd expression
.
.
.
.
try this out and let me know if it works.
hi Wajiha, just wondering how did you finally go about this,
Please let me know,
Cheers,
Luis
Hi Luis,
Yes your solution works fine.
Thanks a lot