Avatar

Andy Son

  • Total activity 33
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 11
  • Subscriptions 12

Activity overview

Latest activity by Andy Son
  • Avatar

    Andy Son commented,

    Hi Jessica, The others tab is used when there are too many categories to properly explicitly display all of them in a pie chart. Would it be possible to filter out the N\A or some of the categories...

  • Avatar

    Andy Son commented,

    Hi A N, Have you checked out our plug-in Table with Aggregation? This will aggregate the measure for the rows instead of creating a new row for each.  See: https://www.sisense.com/marketplace/aggre...

  • Avatar

    Andy Son commented,

    Hi Huang, This is best accomplished through the elastic data hub. You should create a custom column that describes whether a train is an express train or regular train. CASE WHEN LEFT([train], 1) =...

  • Avatar

    Andy Son commented,

    Hello, Designers should be able to view starred filters when dashboards are republished, but viewers cannot. Possibly something that can help is the notion of bookmarked filters.  Please see link b...

  • Avatar

    Andy Son commented,

    Hi Dennis, I understand completely. Sometimes I have that issue as well. I think what can help would be to change the css of the "Clear Selection" button on the dashboards. Remember you can use our...

  • Avatar

    Andy Son commented,

    Hi Tomer, Try performing a multi-pass aggregation with the formula MAX([step_index], [Max agent_storage]). This is grouping the step_indexes before performing the max function which I believe is wh...

  • Avatar

    Andy Son commented,

    Hi Marc, I tried to replicate the issue you were running into and couldn't. Some troubleshooting I can think of is to: - Make sure a widget has a Title within the widget editor to have the style w...

  • Avatar

    Andy Son commented,

    Hi Alex, I was able to find this community post that may help you change the column order of your pivot. Please refer to the comments section of this post: https://support.sisense.com/hc/en-us/comm...

  • Avatar

    Andy Son created a post,

    Flattening JSON Objects in SQL Server

    In instances where tables within SQL Server contain JSON objects within a column you can use the import sql query editor feature in Sisense to flatten these objects into individual fields. For exa...

  • Avatar

    Andy Son commented,

    Hi all, Here's a geojson file you can use for any 3-digit Canadian postal code. You can download it here: https://github.com/andyson23/Custom-Map-Widget.git Cheers