nshively Member

Thanks for the suggestion @DashboardDude. I will check out your website later for additional tips. The problem you demonstrated is exactly my issue. Unfortunately, my internal customer did request multiple columns and only 1 of them be colored. However, they were fine with the numbers being positive (as long as the column…

Hi @GrantSmith, I don't see anywhere for a reverse color direction in the general options for either a standard table or heatmap table. I did use the -1 trick to reverse the order and the color is the correct now, but now I'm getting positive values (obviously). I annotated in the column heading that this was now an amount…

Thank you @MichelleH and @GrantSmith The solution was a combination of adding the partition and realizing I had made a simple mistake. I forgot I had filtered by only the last effective date, so the partition was trying to pull a value that didn't exist. The partition was the piece I was missing, though. The problem is…

Okay, I tried this, but now it's returning an empty value (the formula is not giving me an error). lag(('Annual Base Salary 50th'),1) over (partition by 'Job Title' order by 'Data Effective Date')

Here's an example of the table: Effective Date Job Title Annual Base Salary 50th 1/15/2023 Writer, Senior 123611 10/15/2022 Writer, Senior 119674 4/15/2022 Writer, Senior 118442 7/15/2022 Writer, Senior 118032 1/15/2022 Writer, Senior 105409 What Domo is returning: Job Title Current Salary Last Salary Writer, Senior…

So what my colleague recommended was something like this: Attrition + Lag(sum(attrition),1) over (order by date) + Lag(sum(attrition,2) over (order by date) + etc. for 12 months. I tried this using the actual formula and the validator accepted it, but it broke when trying to put it into a chart. This is where I left off:…

Nevermind, I realized it was a simple solution since I have the EOMDate: SUM(`TermCount`)/ ((SUM(`ActiveCount`))/COUNT(DISTINCT `EOM_DateKey`)) It just divides the total count of active employees per month per year by the number of months of data for that year.

Hi @GrantSmith, Thanks for the help so far, and my team is going to chat with the CSM about the window function. I did find a temporary solution for building out monthly attrition. It's not perfect, but it's the closest I think I can get without the Lag function: SUM(`TermCount`)/ (((SUM(`ActiveCount`))+(Sum(`ActiveCount`)…

Thanks @GrantSmith I feel like that should work, but Domo is not recognizing 'OVER' or 'LAG()' as functions in Beast Mode?

@MarkSnodgrass I appreciate the suggestion, but I would prefer doing it at the BeastMode level if possible. There are about a dozen factors I need to be able to slice this data by and aggregating it at the ETL level will remove that functionality.

@MarkSnodgrass @GrantSmith My table has a row for every employee for every month with all of their statuses and a count of total employees and total terminations. An employee who has been here 12 months has 12 rows of data. Example below:

@GrantSmith Alternatively, it looks like I can restrict access to only see cards/pages through the Groups settings under Admin, and not allow access to the dataset. However, users could still potentially filter down to sensitive information on card filters. It looks like I can lock Page filters but can I also lock card…

" I’d recommend a dataset view to not select the columns with PDP to restrict access to solve your issues" How does this work, or are you saying I should just remove the sensitive columns via ETL before sharing? I don't think that will work because I at least need those columns to do the calculations. Here's a basic…

Hi @MarkSnodgrass Thanks for the suggestion. Unfortunately, this didn't quite work out how I had hoped and was instead giving numerical values along the X-axes instead of the category names. At this point, I don't think that the table is built in a way that can support the type of visualization I'm looking for. I'll likely…

@GrantSmith Unfortunately, I don't need it in a table form. I already have it available in a table. I'm trying to join it to an existing table that is just 1 row per person. The end goal is to add this question data to a current dashboard that can be filtered using the same data set. That way I could simultaneously look at…

Ended up figuring it out. OneClickLeads = leads.

@GrantSmith Yes, you're correct, but I still cannot find a way to pull leads data, despite it being available in the Linkedin Dashboard.

Hi @GrantSmith I was curious if you knew how to pull in lead and CTR%. The fields I'm selecting in the Ad Analytics report aren't producing this data, and I don't see any fields related to CTR or lead generation. There is "externalwebsiteconversion" but I don't think that is correct, as it doesn't match up the Linkedin…

Hi @GrantSmith That's the current problem. The Linkedin Ad Analytics report only produces a single column for Account, Campaign Group, OR Campaign. There's no unique identifier for me to join them together using an ETL. Ideally, there should be an option to display all 3, so that I could join campaigns to the report for…

Thankfully, one of my developers was able to help me out. Here's the solution: ""not": "true"," has to go exactly before "operator": { "dimensionFilterClauses": [ { "filters": [ { "dimensionName": "ga:campaign", "not": "true", "operator": "EXACT", "expressions": [ "(not set)" ] } ] } ] }