Is there a way to restrict the output of a chart to only those values that are not null, when the above() function is being used?
Short Version:
Consider a table with MonthName as the dimension and above(count(Policies), 6) as the expression. It might look something like this:
Header 1
Header 2
Jan 2013
-
Feb 2013
-
Mar 2013
-
Apr 2013
-
May 2013
-
Jun 2013
-
Jul 2013
100
Aug 2013
110
Sep 2013
105
Oct 2013
100
Nov 2013
115
Dec 2013
120
If the display type is switched to Line Graph, there is a large blank space at the start of the graph, and I can't for the life of me seem to get rid of it.
To make matters worse, the actual dashboard I'm making uses a much more complex expression than count(Policies), so using pick(match()), while it works, is very slow (45 -75 second response rate on a large server.) Has anybody else encountered this before, or happened to build a dashboard for displaying Survival Triangles?
