Ankur Member

Comments

  • Hi @JedP I am encountering similar issue with one of the card. My Beast Mode Formula is same but only in one particular category view it gives me the same error. What I have realized is that the error came where the category value is Blank. Just an example of the card where I am getting this error. Month 2024-Dec 2024-Nov…
    in Solution: Beast Mode & Pivot Table Aggregation Error Comment by Ankur December 18
  • Hi @Data_Devon, Thanks for your guidance. However, I can't do count of Date as the data is stored at Last Dat of the Month. So per grain, I will only have 1 row but in that grain the Headcount might be 23k or more. Below is a sample data example with only few dimensions I have added. I have more than 20 Dimensions/…
    in Show Headcount based on Date Range Selected Comment by Ankur December 18
  • Hi @DavidChurchman, Thanks for your response. Few clarification - By mistake I showed the output table as Country. Please consider it to be Cost Center Family. Now Cost Center Family is a Superset of Cost Centers, or you can say it is a group of cost centers. For example, we can have HR cost centers by Location & sub…
    in Variance % formula not working correctly at Grand Total Comment by Ankur October 18
  • @ArborRose What we want is to show all the Feedback if total count of unique feedbacks are >=5 and not just indifidual feedback. Here is an example of final feedback snapshot for 2 countries. For Country C1 unique feedback is 3, so it should not show any feedback in the table. However for Country C2 we have 5 unique…
    in Beast Mode Calculation used to view data in Table Comment by Ankur September 10
  • @ArborRose, Yes we do have such rule and that is taken care.
    in Dynamic Organization (Span) View Comment by Ankur July 31
  • Thanks @ArborRose for the tip. Let us give it a try. Will get back to you. Just one clarification - Our survey is also anonymous. We too just know the respondent as an Unique ID but the reporting hierarchy of the respondent is available. Anyways, we have some direction to work on now. Thanks once again for your time and…
    in Dynamic Organization (Span) View Comment by Ankur July 31
  • Hi @ArborRose , Thanks for the guidance. But the only challenge is that our actual data contains 131 rows and 1+ million rows. We will have around 30k Leaders and multiple layers. Some migth have 5 level of down hierarchy and some might have 14 layers of down hierarchy. So, we want a solutin which will work for all and at…
    in Dynamic Organization (Span) View Comment by Ankur July 31
  • @GrantSmith I know it because Employee Headcount Table contains Country List column against each Employee. I am not sure how the Relationship between Tables work in Domo. In PowerBi we have to manually build the relationships. So, what would you suggest I should do?
    in How to bring certain data from one Table to another Table Comment by Ankur November 2023
  • @MichelleH you are correct. My Country Mapping Table has duplicate rows but for a reason. But still the row counts should not increase from 6.6M to 132M. My country Table has 679 rows of data. Country List Country Region Sub Region USA USA NA NA United States of America USA NA NA US of A USA NA NA UnitedStatesofAmerica USA…
    in How to bring certain data from one Table to another Table Comment by Ankur November 2023
Default Avatar