Best Of

Re: Grant to Share Cards and Page, but not Edit

In general, it would be helpful to separate the actions of 'edit', 'create' and 'delete' into separate grants (across cards, pages and datasets).

chrissweeney92

3

Re: Is there a way to nest beast modes in another beast mode without exposing the full calculation

Unfortunately, the beast modes will expand out when you include them in another beast mode. I agree that it would be really helpful if they did not do this, as it would make the code a lot cleaner and more efficient.

I'm not sure if it has been submitted in the Ideas Exchange section of the Dojo, but I will definitely vote it up if you posted it there.

MarkSnodgrass

1

Re: Aggregation on Lag/Lead functions

This isn't possible as you can't aggregate a window function within a beast mode. What you'd need to do is perform your lag in an ETL and then calculate the average in your card. You may lose some filtering abilities as it's going to be pre-aggregated.

GrantSmith

2

Re: Custom Sorting

Update - I was able to correct the Day of Week to make it sort in order.

I made a new beast mode called "Day of Week Transform" where it just contained

DAYOFWEEK ('Date')

Then I dragged that beast mode into the sort and I was able to sort Day of The Week correctly.

The dayparts (hours), I'm still stumped on...

user32470

1

Re: Date Add Formula

@Ashleigh

You are missing the word interval

DATE_ADD('DateCol', interval 12 day)

MarkSnodgrass

2

Re: Adding values to a custom chart

Thanks, @MarkSnodgrass The goal was to set the ID of each square of the chart as a concat of its x & y categories and then assign a count against each cell of the 5 x 5 matrix (25 cells). If the colour of each square were pre-set, the only thing I would be missing would be the data label, as I could just put a count against the concat categories. I will play with it tomorrow and see what happens.

However, you have presented an excellent example of how it could look if the requirements were simply a gradient of colours. If I can't get it to work, I will regress to this process as I've managed to fix my sort by including dummy 0 values when no data is available and "checking" show 0 values, too.

It's a shame there aren't more options for colour logic in these charts because overriding and filling a cell with a specific colour is almost impossible but could be incredibly valuable.

Samuel.

1