Jones01 Contributor

@timehat Thanks both. We use the Oracle SSH connector. In Oracle dates do have a time component so I don't think this can actually be removed hence why they end up as timestamps in domo. We have scenarios where we would like to keep the time element so a timestamp is fine but when the time element to the date is 00:00:00…

@DanBrinton having a separate grant for scheduling reports would be perfect for us. we have users that want to be able to export to excel etc but shouldn't have the ability to schedule emails.

@david_cunningham we need this feature. Currently we have a table with top n and then we have a whole new table below just for the "Others". Our clients love tables!

any news on this feature?

@akshat7j a lot of the visual customisations you mention can be achieved in the new domo app studio

ticket has been raised.

@MichelleH Hi, I believe a fix for this went live last night. All looks good to me.

@mberkeley @Luka_V I can confirm this is a feature switch and that we've had this enabled on all of our instances. This is a great update for us.

@NewsomSolutions i think there is a feature switch so other users can't see who else can see a particular board.

@Luka_V the option would be better but 99% of the time going to Excel is best and then users can go to CSV from that if they really need to

@mberkeley thanks very much for confirming. This sounds like another feature switch. I have requested this to be switched on for us.

@mberkeley so you can receive a native Excel file and definitely not a csv that you use Excel to open ?

@TMonty0319 first thing to check would be to make sure you don't have something in your sort order that isn't being used in your pivot table.

Thanks. Yes ticket is raised and being investigated.

Hi, I've worked out that the card must be shared with the user for them to be able to see it in a scheduled email.

Yes when I share the board the email is filtered by the PDP policy perfectly

Hi, sorry for the confusion. The dataset has a PDP policy so I needed to explicitly add them to the dataset. The trouble is adding them by group or by name to the dataset still causes a "Private Dataset" message in the email. It is only when I share the whole board with them that the email works correctly. Once I unshare…

No I'm trying to allow them to receive it by adding the "Default" (contains all users) group to the dataset permissions. I can only get it to work by sharing the actual board with them.

@ColemenWilson Thanks. I have the dataset shared with everyone via the Default group. Oddly when I share the actual dashboard the email comes out fine. This added them to the dataset by name rather than via group. I then removed the board from them and removed them from the dataset by name and just left as above by group.…

I can see this has been marked as implemented but I don't think this is correct. The original post asked for Excel attachments when sending scheduled reports. Currently the only option is CSV.

@pshull we are a bit off topic but I am interested in this as private embedding is incredibly slow so anything to skip the authentication stage would be great. Are you saying people log into your portal and then access an iframe with the public embed URL set as the src? If so I would still not be happy that there are URLs…

would love an update on this, We roll out boards to multiple clients and some of the table cards have a ridiculous amount of white space.

@pshull apologies I must have misunderstood how you are securing the data but I always thought (perhaps wrongly) that public embed URLs can be accessed by anyone without authentication. Regarding exporting someone asked something similar here I think but more about exporting the entire board. Hopefully this helps. 👍

@pshull is your data sensitive? If it is then you really shouldn't be using the public embedding mechanism. Anyone with the URL can view the content. Much safer to use the private embed option. With regard to exporting from app studio I think I had read that currently you can't export anything from app studio. Hopefully…

@jtrollinger the image isn't great quality but try removing the field you have in the Sort section.

@Elnaz as far as I am aware you can not change the default calendar to a Monday - Sunday week. You can however contact domo support and request that they upload a fiscal calendar which can be customised to your needs including a Monday - Sunday week. This will then enable this option when creating cards.

this probably covers why

@Samuel. apologies I misunderstood your message. I've tested on my instance and I get back Week 7.

@Samuel. Have a look at using the function Week and pass into it whatever mode fits your needs. WEEKOFYEAR(date[,mode]) WEEK(date[,mode]) Both do the same thing. Modes are 0: First day is Sunday, range is 0-53, first week has a Sunday in this year. 1: First day is Monday, range is 0-53, first week has more than 3 days this…

as @jaeW_at_Onyx rightly pointed out to me domo can't do 2 group bys within cards. This would require a query to do the rank and then another group by on the result of that, along the lines of this. select case when rank <= 3 then country else 'Others' end, sum(sales) from ( select RANK() OVER (ORDER BY SUM(sales) desc) as…