Community Forums

Community Forums

A2024 Member

Overview

Overview
Roles
Member
Badges4

About Me

About Me

Analytics

29
123
21

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 !!
    in Help in Pivot Comment by May 2024
  • 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.
    in Number format Comment by May 2023
  • in Number format Comment by May 2023
  • 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.
    in Number format Comment by May 2023
  • @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…
Default Avatar

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

Badges

  • First Anniversary
  • 10 Comments
  • Name Dropper
  • First Comment