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-
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...
-
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...
-
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 ?
-
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...
-
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...
-
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...