jaeW_at_Onyx Coach 
-
Re: Aggregating Rows
I stand by my previous recommendation @user048760 instead of having one row per site with KPIs in columns i would recommend the schema Site, Date, KPI Name, KPI value This will be a much more flexibl…1 -
Re: Problem with showing top-n results in an horizontal bar chart with series
@danidiaz what you're trying to do, AFAIK cannot be done without a Window Function and RANK or ROW_Number to get your "other" category, you'll have to caluclate the rank inside of a Dataset…1 -
Re: Show all dates between start and end date columns on calendar card
@Jessemauser the MYSQL solution will work just fine provided you have a date dimension (just make sure your start date and end date are actually DATE columns not DateTime AND make sure the start and …1 -
Re: Conditional formatting
@faisalnjit 1) i would recommend a different visualization. consider the Bullet Chart which was designed to show target vs. actuals. by having data spread across two axis you force users to compare s…2 -
Re: Hide row in html table if column data is empty
There is a beta for filtering on aggregates. it has been in early beta for two years and works well enough. @MarkSnodgrass the feature at DP21 is an update to the UI. no idea where we are in beta on …1
