A2024 Member

Yes @Sean_Tully . I need to calculate the "Frequency" field in Domo. I will need to check the Sale transaction to determine this. I tried using below calculation case when DateDiff(Current Date, Max(Trans Date) ⇐ 7) then 'Weekly' when DateDiff(Current Date, Max(Trans Date) ⇐ 14) then 'Bi-Weekly' Else 'Monthly' End But this…

Woww!! That was quick.. Thanks so much for great tip and quick video!! I was thinking that I will need to pivot the whole data set.. Glad that i asked this here.. Appreciate it very much!! Thanks @ColemenWilson !!

Sorry for the confusion. I will use a KPI box with the above calculation. It works great. Thank you both.

@GrantSmith @ColemenWilson Thank you for your response The original datatype is text. But then in beast mode I am trying to do count() which becomes numeric. Yes, the missing parentheses was a typo above. In Domo, I did not have any compilation errors. Thank you!

Thank you @ColemenWilson . As suggested by you, I tried this - COUNT(CASE WHEN Acceptance_flag= 1 THEN Students END))/COUNT(Students))* 100 It still gives me as 100% for every student which is true. Else 0%. Not sure if I am missing anything. It is not taking the total into consideration in denominator. I have done this in…

Awesome! This worked @GrantSmith ! Thank you for saving my time. Much appreciated!

Thank you @GrantSmith for immediate response. I will try this and let you know.

Thank you @GrantSmith This is very helpful. I will look into this link and will implement recursive data flow for my case.

Thank you @MichelleH and @GrantSmith! This worked!!!

Sure @MichelleH In DOMO, This is how it looks like when I look at the data section. Product Key (Floating decimal type) - ProductSale_TimeStamp (Time stamp type)-

Thank you @GrantSmith for your response. I am using MySQL transformation. The data type for the produtkey field is Floating decimal in Domo. I tried above formats and it did not work. Thanks for sending the link. I will check the same.

Thanks @GrantSmith for your quick response. I will need to do a matching on both the sources to get just the matched records. So I will need an inner join. Yes Thanks @GrantSmith . I will add a Group tile and output to a different dataset. The only issue I have with that approach is, in the dashboard I want to see both the…

Thank @GrantSmith . I tried doing the above. I first reset the type in configuration so it is back to Floating decimal. Then after formula tile I placed Alter tile to convert to Date type. Now I get an error after the join. The error says "An error occurred in Alter Columns" Column of type Floating Decimal cannot be…

Thank you @DashboardDude and @GrantSmith for the clarification . This is helpful

Excellent! That worked!! Thank you very much for your quick response @MarkSnodgrass ! Appreciate it.

Thanks @MarkSnodgrass. I am looking specifically for "Single Value" type card. I see there is a Number format in the Chart properties, but it does not work for me. Not sure what I am missing.. Please advise.

@Sayyed007 Thanks for your response. Yes, I forgot to mention that the dataset is shared with that group with "Can Share" option that is highlighted above. However, I am not seeing any options in Dataflows regarding sharing settings? I don't see any option to share a dataflow to specific group or role? Can you or someone…