NateBI Contributor

@MarkSnodgrass Yep I understand, this is essentially what I've achieved with 'Select columns'. When there are 40+ columns per table and multiple tables being joined, having to rename each column makes for a slow day. It may be one for the feature suggestion then!

Hi @MarkSnodgrass unfortunately, when the columns have 'no conflictions found' it doesn't include the table name as a prefix by default (see the rename input box empty): I'm looking for the option to add a prefix for conflicting and not conflicting columns.

@GrantSmith Thanks I'll give it a try and update this thread.

Update: Adding the table name to the end of the Odata URL will display the data from that table - included 'value' for the data tag.

@jaeW_at_Onyx thank you. This would have been a real time saver 🙃

Hi @ST_-Superman-_ Thank you - I thought this was a Beast Mode only function. Plus SUBSTRING for the reverse - using position to extract from a string. Thanks!

Example of simple solution ^

Ticket for this is live with Domo - it was identified as a scrolling issue.

Ok @RobSomers thanks

Update: It seems to happen when I'm in edit mode for more than one dashboard

@RobSomers That worked thanks !

Hi @MichelleH Ok thanks

Update: (@MichelleH) It works now, I removed both dates, added the created date first then added the batch date. It must take whatever the last date field added is and auto set this as the date range field filter for some reason. Thanks for the help!

Hi @MichelleH yeah I did tried this, this is the order: Even when I remove the create date it stays as a filter greyed out. I have to 'undo' until it returns to latest update (alias for batch date)

Hi @MichelleH - here I want the 'created date' field in the card because I want to see when the record was created at source however I want the card to remain filtered by the 'batch date' - the date it was appended into Domo.

Hi @GrantSmith, I want to avoid unpivoting the dataset in this scenario for various reasons but thank you. I found a work-around here: Update: To achieve a similar result I dragged the Clean Type columns onto a bar chart. I used one of the Clean Type columns as the X-Axis and hid the X-Axis label, then included the…

Hi @RobSomers, OK that makes sense. Thanks for explaining

My comment is disappearing post edit apologies Ok, @MichelleH that is very helpful. @RobSomers sure: Status Name = Current Status of ID Implementing = Total Hours spent in Status Implementing Filter on card: Status Name = Implementing My expectation here would be that the SUM() BM matches the Implementing Measure. Despite…

Thanks @MichelleH so the filter is applied first, then the BM is calculated. Sure @RobSomers an example with SUM(). Context: Dataset has distinct IDs, a Measure called 'Implementing' showing the number of hours each ID spent in the Implementing status and a Status Name categorical field showing the current status. (worth…

Hi @MamtaBolaki not in this scenario but I have noticed that Sorting properties affect figures. If we could add this to the list of how BMs handle external filters that would be great.

@MichelleH Ok this is helpful, so it applies the filter first (even within a card) then calculates the BM. @RobSomers , sure the one I have to hand is this SUM(Implementing) BM: The dataset has Distinct IDs . 'Implementing' is a Measure field showing the hours each ID has spent against the Implementing status. The 'Status…