How can I isolate a Dimension so it does not get limited

Anonymous — Wed, 24 Jan 2018 16:18:02 GMT

Hope this is just some simple step or syntax I am missing here, but I am working with a 2 dimensional pivot.

The first dimension is row-level and denotes a type of widget, the second dimension is in columns across the top denoting a month. The pivot simply shows count of widgets completed each month.

The problem is however, that when a user selects a month using the 2nd dimension, the data is limited to ONLY widgets completed within that month, where I need it to show the nulls. Basically need the equivalent of adding {1} to a measure to ignore selections (ideally i only want it to ignore the date dimension, not other dimensions available to filter by).

Any help would be greatly appreciated.

Thanks!

Re: How can I isolate a Dimension so it does not get limited

Anonymous — Wed, 24 Jan 2018 20:55:30 GMT

This set analysis should ignore any selections on field [Date]

Count ( {< [Date] = >} [Widget] )

topic Re: How can I isolate a Dimension so it does not get limited in App Development

How can I isolate a Dimension so it does not get limited

Re: How can I isolate a Dimension so it does not get limited