Comments
-
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…
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In