michiko Contributor

I suspect the browser is blocking the JS. If you change the code FROM <a href="javascript:domo.navigate('https://developer.domo.com/', false)">Sales</a> TO <a href="https://developer.domo.com">Sales</a> that should work and it avoids changing the browser's setting

Hi - Those columns are auto-generated for auditing purposes. Are you open to creating VIEW on top of of DDX Dataset? With a view, you can select only the columns you want.

The beast mode creates the respective offset date so that the date align back to FY

Supposed your data is stored as below 2) create a beast mode called Offset Date case when FY = 'FY' then Date when FY = 'FY+1' then DATE_SUB(Date, INTERVAL 1 year) end 3) Construct a crosstab like below. 4) You will need to tweak the beast mode a little bit more if you want to be able to select other FY values

I can't find a way to remove the extra DS as well but I have been using this work-around. Try using DDX "Unique List Sorted App" There is only DS in there. All you need to do is to replace the HS, HTML & CSS

SIgn up ! :)

Create regex: REGEXP_replace(sText,'(?!T\d.?\d)[A-Za-z]*', '') Preview: 2) Split the text into column Preview: You may need to do a lil bit of formatting clean up the null Col1-Col4

I hope I understood your question correctly. Here's my attempt. Assume Defect DS has these values. ie 01 Jan ~ 30 Defects, 02 Jan ~ 48 Defects Machine Volume DS has these values. ie 01 Jan ~ 6000 vol, 02 Jan ~ 15000 vol Parts per Million (no of def (each day) / vol * 100000) - 01 Jan = 30 / 6000 *100000 = 500 - 02 Jan = 48…

I got the same behavior when trying to exclude Null / NaN value from Integer. My workaround is to use the beastmode below to exclude the Null Example unfiltered data When is NaN = 0

#1 - Structure your data like this ( ie add a column called LY Amount ) #2 - Create some fancy beast mode calcs #3 - Define the color rules #4 - And finally… hack the hell out of the Line + stacked bar chart. Tadaaaaaa

Check out the DDX Form and Dataset and tweak lil if you have the time. Below is the sample data set. If the user knows what to look for, say "Shell", then type in shell ( case insensitive ) in the search box. If the user do not know what to search for, try incorporating the dropdown selector as a lookup ref ( to integrate…

After you removed the values on the dashboard filters, did you click on the SAVE FILTERS ?? If it is still acting weird, delete the Filter and reconstruct it and save it.

You need Jupyter Worspace to be enabled in your instance ( Speak to your CSM - I think it is a paid feature ). The button to create a NEW WORKSPACE is located on the top right-hand corner. If it is not enabled, this is what you will see :(

Depending on how you structure your data. For simplicity, assume each row is already summarised like the below In the beast mode, the formula is defined as below. Note I am using Avg() with the assumption that row is already summarised. Output:

Are you trying to show 28.586,84 as 28,586.84 ?? 🤔 Cheap Trick: cast(replace(replace(europe, '.', ''), ',', '.') as double) Result

Not too good with regex but how about this 2 step process?

If you pivot your data into the structure below, you might be able to achieve that.. Date, Column Name, Value render using a pivot table and set the Column Name as filter

@GrantSmith Wowee !! That was it, the lock & release. Thanx for the tips :)

Thanks for that @GrantSmith, that was really helpful. Took me a while to realize the v# on my instance is different :( Whilst I managed to get a 200 response, the title on the dashboard remain unchanged even after running the PUT & refreshing the page. Is below the right way to update the Page Layout ?

@GrantSmith - Thanks again to your replies above, I was able to extract the card definitions into JSON files, repoint the datasetId and import the cards into another instance. However, I have been stuck for a few days trying to reconstruct the card back into the original dashboard layout. 1) I looked at the Page API but it…

@GrantSmith, I saw and read many of your blogs - Many thanks for sharing the tips & tricks with the community !! 👍️ Yes correct, a different data structure will definitely work although I was reaaaaally hoping for a cool pivot table function calculation feature 😛. Instead, I ended up with a cross-join structure as below.

Cheers for replying - Flex won't solve the problem as the end result is to complicate the table structure even further by nesting year under another dimension. ie