Question

Tile query alias miss underscore

  • 23 June 2021
  • 0 replies
  • 6 views

Hi there,
 
I am getting error whenever I try to edit the settings on a Donut Multiples tiles. It crashes and any work not saved on the dashboard is lost. After checking the sql, I find one of the alias z__rank is missing a underscore. Is this a known bug? any workaround? Thanks!
 
SELECT * FROM (
SELECT *, DENSE_RANK() OVER (ORDER BY z___min_rank) as z___pivot_row_rank, RANK() OVER (PARTITION BY z__pivot_col_rank ORDER BY z___min_rank) as z__pivot_col_ordering, CASE WHEN z___min_rank = z__rank THEN 1 ELSE 0 END AS z_is_highest_ranked_cell FROM (
 

This topic has been closed for comments