Best Of
Re: ETL Field Search Capability
Wanted to update you that we haven't lost sight of this and will be reviewing again soon.
Re: Having Multiple Group By tiles?
- To have 2 independent groupings (Group By) , you will definitely need 2 separate grouping tiles
- The reason why Minimum and Maximum is not showing up in the aggregation type is due to the field type you are using. Min and Max option only show when aggregating not TEXT fields… if you use an INTEGER , TIMESTAMP, FLOATING DECIMAL or any other different to TEXT, the min and max option will be available
Godiepi
Re: Additional Options for Multi-Factor Authentication
Looks like this was Archived? I'd love to see this further considered…
Re: JSon file in Domo
There are a few connectors you could look at:
JSON No Code Connector:
JSON Advanced Connector:
Re: New Dataflow Run Options
@ArborRose settings appears when you are viewing the dataflow. If you are on the dataset click the 3 dots then view dataflow.
Ashleigh
Re: Issues with changing cast dataset to date
During the append, the matching fields being appended default to the most compatible data type between the appends sources. So if you change one source to Date, but the other is Date Time, it will change the data type to Date Time. You'll need to ensure that the data type for all inputs to your append are cast to Date. Add an Alter Columns tile here:
Alternatively, you could cast to date after the append.
Re: Grand Total Beast Mode not calculating correctly
@jtrollinger the image isn't great quality but try removing the field you have in the Sort section.
Jones01
Re: How to get 2 decimal places only
Try:
CONCAT(ROUND(Sum(CASE WHEN `To Step` = 'Forward to HM' THEN 1 ELSE 0 END)/(COUNT(DISTINCT `Requisition Number`)),2), ':', ROUND(Sum(CASE WHEN `To Step` = 'Hire' THEN 1 ELSE 0 END)/(COUNT(DISTINCT `Requisition Number`)),2))
Re: How to get 2 decimal places only
You can wrap each of the two parts of your concat with ROUND().
CONCAT(ROUND(Sum(CASE WHEN To Step = 'Forward to HM'THEN 1 ELSE 0 END)/(COUNT(DISTINCT Requisition Number)),2) , ':', ROUND(Sum(CASE WHEN To Step = 'Hire'THEN 1 ELSE 0 END)/(COUNT(DISTINCT Requisition Number)),2) )