ozarkram Member

Thanks @MichelleH

Hi @MichelleH : Really appreciate your help!

Also my data looks like 2019-12-18 2020-01-21 ie of the format: yyyy-mm-dd

Hi @MichelleH : I am using ETL

Thank you so much @GrantSmith and @MichelleH ..Really appreciate your help!

Thank you so much @mhouston!..Really appreciate your help!

Thank you so much @mhouston !..really appreciate your help!

Thank you so much @GrantSmith !..Really appreciate your help!

Hi @MichelleH : The DOMO dataset comes from a query in the DOMO workbench which runs everyday and it is snapshot data...The data I am trying insert into it is in excel and it is for couple of weeks missing in 2021...

Thank you so much @RobSomers !..Really appreciate your help!

Thank you so much @MichelleH ...This works!..Really appreciate your help!

Hi @ST_-Superman-_ Please find below the data...Also attached the excel file.. Input data Expected output

Thank you so much @ST_-Superman-_ ...Really appreciate your help!...

@MichelleH : I am using the chart under vertical bar ->Symbol + Grouped bar..I will share the sample data soon

@MichelleH : No I hadn't applied any aggregation...I tried applying the average of week number too...Still the week numbers appear thrice

Hi @mhouston : I am sorting by the field Week number in fiscal year...

Hi everyone, Any help on this will be appreciated!

@kdeike ..Thank you so much!...Really appreciate your help!

Hi @GrantSmith , I used redshift sql finally..I have to get used to the rank and window tile..

Thanks @TheLookout !..Really appreciate your help!

Hi @MarkSnodgrass :Yes I have checked the same..I have used only ifnull

@MarkSnodgrass : I am getting the following error when I try to do the code below: Error : For 'isnull', types date and varchar are inconsistent Do you have any suggestions DATE( CASE WHEN LEFT(`description`,5) = '*SLD ' THEN IFNULL(TRY_CAST(SPLIT_PART(`description`,' ',2) AS DATE),`orddate`) WHEN LEFT(`description`,4) =…

@GrantSmith : the below function that you shared is not looking for *SLD at all.. Can you please let me know REGEXP_REPLACE(`description`, '^.*(\d{1,2}\/\d{1,2}\/(\d{2})|(\d{4})).*$', '$1')

Thank you so much @MarkSnodgrass and @GrantSmith ...Really appreciate your help!

The other two possibilities are only *SLD5/17/22 jilo (no space after SLD ) and then no date *SLD owell23451 ( here I should consider the ord date)

Hi @MarkSnodgrass : Thank you so much for your response!...I have also cases when data is like *SLD5/17/22 jilo ( here there is no space between SLD and the date ) Also does this formula append 2022.... In some cases the field has data like.. *SLD owell23451 In this case I should consider only the orddate...Is this…

Thank you so much @Recluz and @GrantSmith ..Really appreciate your help!

HI @GrantSmith : I am referencing Adrenaline data flows

Thank you so much @MarkSnodgrass ..Really appreciate your help!

Thank you @GrantSmith and @mhouston ..Really appreciate your help!