Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am creating a text box within a dashboard with a count function within.
I require this function to be based on all of the current selections apart from the date fields.
In other words I want to detach it from all calendar based selections, but remain attached to all others.
Lets assume your count function currently is "count(OrderID)" and you want to exclude the fields Year and Quarter from having effect on this expression. If so, this is how the expression would look like:
= count({$ < Year=, Quarter= > } OrderID)
The extra curly brackets that you see and everything in between is something called "Set Analysis". You can manipulate the data set used for your expression with using that. Search for Set Analysis for a lot more information.
Another option could be this:
=Sum({<$(='[' & Concat({<$Table = {'MasterCalendar'}>}$Field, '],[') & ']')>}Sales)
NOTE: The above will show syntax error in expression editor, but will work as expected
Thanks for that trick, sunindia. I sure am going to make some customers happy with that.
Thank you. This was the simplest solution.
I am a newcomer, but am aware of set analysis.