Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
I have two variable vstart and vEnd . when i give date range in my chart like below..
Name, sal ,daterange
raju,5000,30
ramu,6000,20
i am expacted o/p ...
What ever given date range in filter level it showing chart like below..
Name, sal, 01-01-2018-01-06-2018(This date fields show by labes)
raju,5000,30
ramu,6000,20
i tried this expression(=Concat(Date($(vStartDate)-($(vEndDate)))))
how to do above thing?
Thanks,
Nani
May be this?
let vStartDate = '2018-05-01';
let vEndDate ='2018-06-10';
T:load * inline [Name, sal ,daterange
raju,5000,30
ramu,6000,20]
Label : =(vStartDate) & '-' & (vEndDate)
May be this?
let vStartDate = '2018-05-01';
let vEndDate ='2018-06-10';
T:load * inline [Name, sal ,daterange
raju,5000,30
ramu,6000,20]
Label : =(vStartDate) & '-' & (vEndDate)
You can increase your Height of Header from presentation tab? and for that, You can use this?
=Concat(Date($(vStartDate)-$(vEndDate)), '-')
Thank you:)
Glad to know it worked