Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to ignore date selection on a table

Hi,

I have a table which contains one dimension: [Nickname]&[Mode].

Now I have an issue that when I open the page, I automatically set the month to the current running month. Now this filters out some of the dimensions, because they might not have data yet for the current month. How can I make the table not care about the month selection and always display all the available [Nickname]&[Model] dimensions? Thanks in advance.

// Tuomas

3 Replies
Gysbert_Wassenaar

If the name of your month dimension is MyMonth then change your chart expressions to ignore selections in the MyMonth field. For example sum(Sales) would have to be changed to sum({< MyMonth= >}Sales). Change your chart expressions accordingly and don't use MyMonth, but the actual name of your month field.


talk is cheap, supply exceeds demand
taha_mansoor
Creator
Creator

Hi,

I have to achieve the same in a line chart but I have a drill group as a dimension in line chart i.e. Month>Day and I want to bypass both the field in the chart and its not working by doing the above mentioned set modifier. Any advise ?

Thanks

Taha

taha_mansoor
Creator
Creator

Also, I tried getcurrentfield() with if statement inside the set modifier but didn't work.