Jones01 Contributor

Is there any news on this feature? we have tables that have over 100 rows and then get filtered to say 5 rows. The amount of white space looks awful and makes it hard to navigate the board. Just seen this post is from 2021!

I would remove the UTC tile and the filter tile. do the rows then appear in the final output? if not. Filter each set at the begining before the Select tile by the one orgunitid. Do you see 30 rows for 1 set and 2640 for the other in the preview? if you do then get a distinct list of dropboxids from the submission set. Are…

this is causing massive confusion with users and gives the appearance that something isn't working. User filters on filter 1 ⇒ filter 2 ⇒ filter 3 then at some point adjusts filter 1. bang the board is broken.

@jrtomici yes its an embedded app (not dashboard) with programmatic filtering. I'd raise a ticket as sounds like a bug just on your instance.

yes this one

@jrtomici i don't have this issue. Once the app is filtered then the export to Powerpoint or Excel shows only the filtered data for me.

absolutely need this. an addition to this would be to also not allow a filter to be cleared as we have boards where the visualisations don't make sense when looking at looking at all of the data without it being filtered. @SherryR out of interest what was your workaround. was it a complete new filter made in a brick or a…

@art_in_sky sorry I don't know how to do that but I agree there shouldn't be a difference between app studio and embed.

@art_in_sky this was all enabled in domo in a release quite a while back. just tick allow export in the embed dialog.

it likely just needs enabling on your instance. may also depend if you are on consumption as it was a paid option before.

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