Jones01 Contributor

@Marc Aec, @DHo to my surprise this does work even though the validator says non existent function. concat('£', format(sum(somenumbercolumn), 2)) credit goes to Sam Chalvet for making me aware of this.

@Shalini hi, are you joining on property id and check in date? it looks like you may be only joining with the property id. on a dashboard the cards can be using different datasets but as long as the column names match then filters will works across all of them where it can find a column with the same name .

@DavidChurchman thanks, yes I think this will be the only way. This is just sample data but in my actual data the values are % increase on LY so it would be absolutely best to have on one card. (something we can easily produce with a snippet of sql and fusioncharts lib) so is very frustrating this can't be done.

@MarkSnodgrass thanks but this is an example data set and in reality Team consists of hundreds of records so needs to be a filter based on the data from the set. I don't think that fixed function would work would it? The line chart is grouped by months and not Team so would essentially sum up everything ignoring the fixed…

Sorry picking up this old thread. Does anyone know if this is possible now. Line chart with dates on the x axis but I want to only show the top n (from a variable) based on the total period? I still don't think you can get the rank based on the whole range as it is grouped by date?

@jrtomici so are you saying your resulting beastmode on that data would calculate the below.

@Parker_Lake if you connect with the cli tool Then run list-dataflow -i 96 -f mydataflow.json 96 being the id of your data flow found in the url when viewing it in domo. This will export the definition of the ETL into json. In the json you should be able to see the output dataset definition. You can then replace the…

@vaco take a look at the Amazon S3 Advanced connector. I think this will pickup multiple files. https://domo-support.domo.com/s/article/360043436353?language=en_US

@Parker_Lake I do this via the cli but agree would be handy to have it natively available

@abarrie23 what does your data look like?

@abarrie23 did you try my suggestion on your post? https://community-forums.domo.com/main/discussion/67998/domo-error-warning-multiple-errors-encountered-for-same-location-in-pivot-table-indicated-by#latest

@abarrie23 change the first when to SUM(case when Term Length (Months) >0 then Term Length (Months) end)

https://domo-support.domo.com/s/article/360042924094?language=en_US

@Taurance @Nick12 export at card level on apps from app studio can be enabled by making a simple call to your instance api. It involves making a PUT request to this url (but for your own instance). This URL can be found in the network tab of dev tools when enabling embed on the app. The instance and number will be unique…

@Mukhilan FLOOR((DAYOFMONTH(datecol) - 1) / 7) + 1 may do what you are looking for.

@ChrisGaffan can you provide a small sample of the data please?

have noticed the same. No workaround that I know of other than turning sorting off.

@AO3 can you post a small sample of the raw data please?

@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 ?