Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a diagram with "date" as one of the dimentions. Additionally i have a filter with DateFrom (the copy of the date column). I want to pick a date from and show dates from this filter and onwards in the diagram. For this i have written this expression
=if(Date([TableD.Date], 'DD.MM.YYYY')>GetFieldSelections(Date(TableD.DateFrom, 'DD.MM.YYYY')), Date([TableD.Date], 'DD.MM.YYYY'))
why doesnt this work? And how can i fix it?
Thanks
Date should be a column, Datefrom you're using for your selection should be a column in a data island.
Date Fields should be in separate unlinked tables.
dimension for your chart should be the Date field the filter on your date should be the Datefrom field.
I can't give any more help than that.
Good luck.