Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to select data of Year 2008 only for my Table in Sheets, how can I achieve that. Please guide.
As you can see currently data of all the years are present I want to reduce them to data of only 2008.
I tried using ({$<Year={2008}>} with Measure values Promised Delivery Date and Actual Delivery Date
Looks like they are dimensions, may be try this If(Year = 2008, [Promised Delivery Date])
Looks like they are dimensions, may be try this If(Year = 2008, [Promised Delivery Date])
Date columns are measures, How can I ignore null values?
on if they are measures, try this... this should also exclude nulls for [Promised Delivery Date]
Only({<Year = {'2008'}, [Promised Delivery Date] *= {"*"}>} [Promised Delivery Date])
I tried using it but didn't work out as expected and it shows null values too.
Then I tried creating a line chart and tried applying it there too, but didn't worked out. Dimensions aren't taking many expressions in it like measures do.
I am trying to limit the chart for 2008 [Invoice Date] Year only. and I am not able to make any selection based on date for selection I have to click Invoice Number which is a dimension, may I know why? Please
Which of the two charts are you trying to do this in? Would you be able to share a sample qvf to see what you have to help you better?
Line chart I want [Invoice Date] with month and year of 2008 only in x-axis
Dimensions: Group - [Invoice Date], Line - [Invoice Number]
Measures - Delay in Delivery , calculated using =([Actual Delivery Date])-([Promised Delivery Date])
May be change your Invoice Date dimension to be a calculated one like this
If(Year([Invoice Date]) = 2008, [Invoice Date])
and then uncheck Show Null Values for this dimension