0

1500 Data Points Per Series Restriction Workaround

When creating a chart in Data Discovery, it is possible to display up to 1500 items per series.

When selecting a larger number items for a particular series, a message will appear saying that the "Query is too big to be displayed"

Although this limitation is hard coded, it is possible to workaround it by creating a dynamic set that will randomly sample 1500 items from the larger set.

Since the set is random, it should accurately represent the general set.

Here is random Dynamic 1500 items set example:

{  {  TOPCOUNT(
{  {  EXISTS(
{
[Customer].[Custom Geography Zip].[Customer].MEMBERS
  }  ,  {  { [Measures].[Sales] }   }  , "Sales")  }
 }  , 1500 ,  (  [Measures].[Margin] * RND() * RND()) )  }
 }  

 

Chart:

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 yrs agoLast active
  • 466Views
  • 1 Following