Jones01 Contributor

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?

@carthur Hi, even when the attribute is a list you don't get the option to do an IN in the PDP policy.

@kevintroxell When embedding make sure the option to show the filter bar is selected. At the top right of your embedded board the filter button will show like this Pop that down and you'll have access to the native date selector. The only time it won't appear is if you have deselected this in the main view of the board.

@Tamara There is a feature that can be enabled so users see the below. They can see the owner but not who it is shared with.

Hi @JohnMiller , thanks for getting back to me. The main use of the filter bar for our users would be the global data selector and predefined filters we have added. It looks quite bare when defaulted to closed as well. This would be a great addition for us.

In case this helps anyone we have noticed that domo are not using the Storage Access API at the moment when embedding Domo Everywhere. This means the page does not now require the user to click the request cookie access button. We have tested this with Edge (Storage Access is on by Default) and Chrome (Storage Access…

What does your beastmode look like? to calculate this you can do one of the following. ((sum(rev this year) / sum(rev last year)) * 100)-100 or ((sum(rev this year) - sum(rev last year)) / sum(rev last year) and then format your column as a % or ((sum(rev this year) - sum(rev last year)) / sum(rev last year) *100

@Mickey This can be achieved by using the HTML Table chart type.

@jimsteph something like this may work SUM(A) + SUM(B) - SUM(C) / sum(case when DAYOFMONTH('DateCol') = 1 then D else 0 end)