My chart has dimensions of DATE and expression SUM(EVENT_COUNT). In some cases there is a date that contains values much larger than all other dates -- this throws off my chart so bars are barely visible for all other dates. What expression could I use in my Static Max on the expression Axes to keep this outlier from skewing the axis maxium?
I'm really not interested in this being a logorithmic scale, I just want to remove the high outlier from skewing the chart, but still use a standard scale. In fact, applying a logorithmic scale here removes all bars from being visible.
The Dimension shoud be the field that gives the details of your Event_Count. Ideally it could be Event Name,Event Type,Event Id. To be more specific the field you are goint to keep in "X" axis.Always Dimension will provide the info for your Measures (Sum(Event_count) or Min() or Max () )