Jones01 Contributor

@MichelleH thanks, I thought it was an odd one. Unfortunately our users like to be able to flex the filters and the date range so I don't often revert to using ETL's for this sort of stuff. I need a pivot table as they want other data columns on display at the same time. I think they'll have to live without the "others".…

@MichelleH no sorting at all. I have never tried to "bucket" data using a rank in this way before so perhaps it isn't possible.

I have tried this with some simple data but still doesn't work. When converted to a normal table the problem can be seen

@ArborRose thanks but it didn't seem to help.

@Ken_Boyer Hi Ken, any luck with this yet?

@Gunjan probably need a bit more detail with your question but in is simplest form you can average a field within the card analyser like this or within a beast mode AVG('fieldname') or within an ETL

Please mark this as implemented as this is now working.

I have tried my idea again and it seems to now work. I can use the trusted attr in PDP when the trusted attr is an array of Integers.

My idea was this which allows the contains to work when the trusted attribute is a list.

@art_in_sky case when IFNULL(col) then 'blank' when col = 0 then 'zero' end

@art_in_sky Try. CASE WHEN New_Column_Name < 5 THEN 'Less than 5' WHEN New_Column_Name >= 5 AND New_Column_Name <= 10 THEN '5-10' WHEN New_Column_Name >= 11 AND New_Column_Name <= 20 THEN '11-20' WHEN New_Column_Name >= 21 AND New_Column_Name <= 30 THEN '21-30' WHEN New_Column_Name >= 31 AND New_Column_Name <= 50 THEN…

@art_in_sky can you post your beastmode please?

giving this a bump as this functionality is so important to us

this would be very handy. I am surprised it hasn't got more votes.

@dacorson hi have you got a link to your idea so I can add my vote?

this sort of thing would be a game changer for us. I also reference my other idea which allows you to change the start day of the week for the default calendar.

any news on this feature? we have clients that keep wanting this…

The client already has a fiscal calendar setup based on 4-4-5 but sometimes they like looking at Calendar based periods but like I mentioned above this always reverts to a Sunday start if they choose a Week period.

We have this need. Our clients have a "financial year" loaded into their instances but also like to view boards based on calendar year. This all works fine but their start day of the week is a Monday not Sunday. It would be good if in company settings you could specify the start day.

@ArborRose I want the chart to automatically produce the "Other" bar. Choosing maximum of 2 items and ordering by totals shows the top 2, or top n it is the "Other" bar that I am suggesting has the problem. @ArborRose sorry I just read your last post. I don't think you are understanding the issue. Why does the yaxis…

@ArborRose

@MichelleH sure. It is the same as the yaxis. sum(value)

Hi @MattTheGuru thanks again for your prompt reply. On point number 2. We have tested this in the past and can confirm that the dashboards embedded don't periodically refresh and also do not refresh (unlike boards on the instance) when the underlying dataset changes. Yes agree I think we can just refresh an iframe in the…

@MattTheGuru Hi again. We are going to go down the route of lazy loading the boards into iframe. If the iframe has been alive for a while we want to refresh the dashboard. Ideally we don't want to refresh the iframe itself. Do you know of a simple way to just call refresh on all of the content? I assume via the js api? I…

@MattTheGuru Thanks for your suggestions. Yes we had cached the access token and that does improve things a bit but on the second call the authentication is slightly quicker anyway. The dataset is quite large but the board is much faster when accessed within the instance itself. Possibly the programmatic filtering slows…

@ncelis try using this instead of a between AND Date Scaffold >= Event Date and Date Scaffold <= adjusted_end_date

@muhammadtalha ok. Obviously you know anyone would be able to view those boards if you haven't restricted the domains in your instance? Looking at the request I would have thought it would be doing an GET not a PUT. You could try removing the iframe completely and recreate it in javascript when you click a new tab then…

@muhammadtalha is this a private embed I assume? The fact you said it loads quickly now makes me think these are public embeds.

@Gunjan ideally you would group the table by month and the COLUMNS would include a date rather than text as you are doing. Saying that if you added a beastmode with a case statement like case when month = 'Jan' then 1 when month = 'Feb' then 2 etc etc If you stick that in the order by rather than the String month it may…

Hi, what does the underlying data look like?