AnwarBham Contributor

i have found a solution if anyone is intreseted. you get the embedded card URL place this in an iframe in a ddx card . in the ddx you use load a webform with the same filters you would like to apply the values can be empty or null. you apply a page filter "Pfilter" to the embedded card URL . now you can pick and choose…

is there any way in a slicer card we can set a default filter.

id be very carefull with write backs we found it was not copying rows where the keys were duplicates. column1 and column2 are the key identifier columns, column 3 new values to bring ie old dataset column 1 column2 column3 Date1 AAA 23 Date2 BBB 23 Date1 AAAC 24 new dataset column 1 column2 column3 Date1 AAA 27 Date2 BBB…

i managed to figure this out just remove the original output dataset and use the copy dataset created by the writeback tile

Never mind … you have to change the format of the output to 'array-of-objects' and then you can call the individual elemenets bythe respective column name

This will be a great addition

I Refactored the dataflow creating alias slicers and filters as to not affect the page filters and card filters. Thans for your help

@ST_-Superman-_ i have treid this option and it does not work. because its a page filter and not a card based selector. the KPI i have has a filter Value type = YTD but the page has a diffrent filter Value type = MTD the Page filter is affecting the Kpi Filter. @GrantSmith if i include the Fixed (Remove Value Type) i…

Un Place in a ddx and set the div border via css

Any update on this. I also noticed the ppt plugin is on .net 4.5 is this a trend

There is an api call we’re you can hide the columns. And show columns, rename columns on the fly and change the descriptions. Not documented

You can achieve this via ddx, pfilters, embedded iframe cards and a bit of JavaScript and css. Only issue is place holders won’t disappear

This can be done Via DDX . you need to make the card into an embedded card via the shared icon. get the URL . place into a ddx HTML with your styling and use the JS call domo.onFiltersUpdate(Data); to traverse through the filters on your dataset ie data[0].column == 'myfilter' then check the values data[0].values =…

can you not use a window rank with row number include all the columns the and order by then create a filter to remove row number 1 im assuming its magic ETl you are using

@wdenny this whould be ideal we have over 300 fields and keeping track of the impact when a field is renamed or removed will be very useful. But is this a Domo Tool or a third party Tool.

You can do this via the API STEP 1 Create a POST request to "https://YOURDOMAIN.domo.com/api/query/v1/datasources/YOURDATASETID/wrangle" in the header include the KEY - x-domo-authentication with the API key you get via POST REQUEST STEP 2 "https://YOURDOMAIN.domo.com/api/content/v2/authentication" Body of Post will have {…

convert the image into base64 and store it in a var in javascript , you cannot store it in a dataset as DOMO has the wisdom of limiting the columns to 1024 Chrs. then in Js create a function to call the image based on the the ID ie a page filter. i have done the same with logos and country flags.

@guitarhero23 can you elaborate on your response. are you saying you created a local admin group called Domo Workbench Users in active directory and assigned the user to this group. You should be able to run/use Domo without Admin as long as your windows (assuming you're windows) user is added to the "Domo Workbench Users"…

was this ever fixed or is this another unanswered question in the black hole of domo

2 years later and i still fail to see domo updating the api docs https://developer.domo.com/docs/dataset-api-reference/dataset#Query%20a%20DataSet

Awesome thanks buddy

thanks but seems too manual. i was looking for an automated low maintenance solution

are you using the domo javascript function javascript:domo.navigate('');

raw['VEEVA Entity ID'] = raw['VEEVA Entity ID'].astype('category', errors='raise') does not work but raw['VEEVA Entity ID'] = raw['VEEVA Entity ID'].astype(str, errors='raise') does work leads me to believe some sort of problem between numpy datatype and a dataframe datatype this happens on the write_dataframe(raw) some…

Thanks @Ashleigh this solution means going through all the datasets and extracting the source and name of the file and adding them to the description. until domo improve the governance dataset i guess this will be the only option

i have used the python API before with domo , can i invoke a method datasets.get or what pydomo library does the attribute reside in thanks.

Thanks for your response , but i just want a list of azure datasets in domo and the source file names that are being used.

Thank @mhouston i have used the domo SDK with python before using the pydomo library. documentation was scarce so we did not go ahead with it . i was not aware you can get tagging data from data sets . i will take a look thanks

Thanks Mark we are using tags , but im finding users who create data sets and they forget to include the tags so im having to manually add the tags. but filtering one by one each user is painfully slow.

my apologies it was domo who agreed to do the heavy etls outside. but jae i can see you have created a few datasets and dataflows in our environment we can set up a call in future to discuss cleaning these and keeping the house clean . thanks