Comments
-
@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…
-
@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.