Avatar

Richard Stubbs

  • Total activity 13
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 1
  • Subscriptions 6

Activity overview

Latest activity by Richard Stubbs
  • Avatar

    Richard Stubbs created a post,

    Pivot table - hide value in specific sub-total cells

    Hi, I have a pivot table with some monthly numbers and quarterly sub-totals, and a yearly grand-total at the bottom. For two of the columns, there isn't a way to compute any sensible numbers for th...

  • Avatar

    Richard Stubbs created a post,

    Prevent filter from being disabled

    One of our dashboards has a text filter which users to specify the data that they want to see. However, the user could toggle the little button to deactivate that filter, and this would cause the d...

  • Avatar

    Richard Stubbs commented,

    Hi Is it possible to show only the date part of this, hiding the time. For example, to have it show just 6 Dec 2018 instead of 6 Dec 2018 13:04:25 ?  

  • Avatar

    Richard Stubbs commented,

    Hi, Assuming you want the dashboard to always show the data from the previous working day, we achieved this by creating an custom query in the Elasticube that identifies the previous working day at...

  • Avatar

    Richard Stubbs commented,

    Hi, If I've understood the problem correctly, I believe there is a simpler way to achieve what you want. Assuming the table that contains owner_type and owner_id is an imported table (rather than a...

  • Avatar

    Richard Stubbs commented,

    Hi, seconddiff(human_date, create_date(1970,1,1)) This will give you the Unix time (assuming your human_date uses UTC). If it's not in UTC you'll need to add or subtract the number of seconds corre...