Khan Member

@GrantSmith Thank you. In Group By, Ticket ID is aggregated by Count, Select What columns identify the grouping shouldn't include Ticket ID else it will be 1 per row. If I do not include Ticket ID in Select What columns identify the grouping, while joining I have to join using matching values i.e., Ticket ID in Rank and…

Thanks for the additional information, @GrantSmith , I prefer %contains% for the current scenario.

Thanks @GrantSmith , makes sense, will give a try.

Thanks @GrantSmith. I would like to share an example of the beast mode we have in our instance. Example: case when `Project` like '%AMC%' then 'Auro Medical Center' when `Project` like '%SYS Sol%' then 'Syndia Solutions' when `Client` like '%Benjamin%' then 'Benjamin Research Group' end Likewise, we have more than 350…

Thanks @jaeW_at_Onyx !

Hi @jaeW_at_Onyx , I have connected the file using SharePoint connector and the data gets updated on daily basis, so I cannot use File upload connector. ""filter out row 2, and then set the remaining rows using a SELECT statement and then set the DATA TYPE with an ALTER COLUMNS tile.""" - Can you please elaborate - also,…

Hi, I have figured out that I haven't shared the card to the social user(it is mandatory to share the card with the user). Now the social users are able to see the card. I just went through the below article and fixed.…

Thanks @TheLookout , I am an editor, so I am not able to see Security->Authentication in Admin Settings.

Hi, There are few datasets which are deactivated, I want to know all the datasets which are deactivated, there might be some which we wish to delete based on the status(active/inactive).

Hi @jaeW_at_Onyx , I have set the date range to Last 12 months in analyzer. When I filter to Current year, last year months are visible but with no data. In general, when we filter for Current year, only current months should be displayed. I did not add the card to dashboard. Anyway, the filters are working fine now even…

Thanks @GrantSmith ! I did not restart the workbench service but I am aware that restarting the workbench is an option to make the job workflow return to normal. I am still a newbie to workbench and was curious what happens if I delete a job and recreate it and how does my old datasets get updated. Also, I followed your…

Hi @GrantSmith , The below article on Command Line Interface (CLI) Tool says this option ONLY works with 'User Name' authentication. That is when I opted to connect through username and password. get-certified-contentGet a list of certified content. Note: This option ONLY works with 'User Name' authentication.…

Hi @jaeW_at_Onyx , I tried Domo CLI to get certified content, I got an error as Unauthorized using the below command. "connect -u jim.smith@xyzcompany.com -p abc123 -s xyzcompany.domo.com" We use SSO to login to Domo instance and the error makes sense. Is there a way where we can get certified content? Are there any…

Hi, The date filters are working fine now, check on your end.

Thanks @GrantSmith ! Using below Query, I can see the decimal part now. (UNIX_TIMESTAMP(`ResponseTimeUTC`) - UNIX_TIMESTAMP(`CreatedTimeUTC`)) / 60 ResponseTimeUTCCreatedTimeUTCRESPONSETIME(Min)2020-02-01 00:14:362020-02-01 00:03:4010.9333 Earlier the TIMESTAMPDIFF(MINUTE,`CreatedTimeUTC`,`L1_ResponseTimeUTC`) was rounding…

I think I accomplished what I needed using below query, but is there a way to get the decimal part? SELECT `ResponseTimeUTC`,`CreatedTimeUTC`, TIMESTAMPDIFF(MINUTE,`CreatedTimeUTC`,`ResponseTimeUTC`) AS RESPONSETIME from table;

Hi, I am facing the same issue with presets, did you have any luck? Thanks

Thanks for the quick turnaround @Neeti ! ?

Thanks @Jarvis !