Best Of
Re: Reconnecting Disconnected Output DataSets and Cards
@Tow solving it yourself is always good and either way you've made @GrantSmith a happy man :P
amehdad
Re: How to build card|total headcount based on the Hire date and termination date
Hi @Abhijith, for your first Q, as a start, this is an option to get total employees active:
COUNT(
CASE
WHEN status = 'A'
AND 'Hire Date' <= DATE_FORMAT(CURRENT_DATE(),'%d/%m/%Y')
AND 'Termination Date' IS NULL
THEN 'ID Number'
ELSE 0
END)
You could use 'COUNT(DISTINCT ... ' in the front instead.
To get the graph view by month, an option is to bring in another date field as a check of activeness (such as a 'login date' field or similar). This is where ETL comes in, a dataset that has a daily log of employees, that you can join by ID number.
amehdad
Re: How to add percentage in the pivot table?
Have you had your Customer Success Manager switch on the feature for Window Function in your instance?
amehdad
Re: Setting Default Datasets for Page-Level Filters
Hi @cassandra_cook1, so checking that after this setup below,
did you check if all the users have the correct PDP [https://domohelp.domo.com/hc/en-us/articles/360042934614-Creating-and-Deleting-PDP-Policies] to access your intended dataset?
amehdad
Re: Where I can find the "Saved post" metric in Facebook Advanced Ads Connector.
Hi @nbrx, in your connector settings, have you tried using the 'Custom Insights' report and searching in 'Columns' for "Post Saves" or similarly names fields?
amehdad
Re: Is it possible to create a graph with categorical levels?
Hi @ramoshe, for the graph you've selected, the x-axis needs to have some sort of measure field so perhaps it's better to represent that categorical levels information through another chart type (e.g. Pie chart), and the users can filter between the options based on your y-axis field.
amehdad
Re: Adobe Illustrator - Design App Studio
It's odd that this is still showing as 'Unanswered'
amehdad