-
Create a date field from separate month and year fields
I have a data set that for some reason has a field for month and a field for year but does not have any date column. Is there a way to string this together in a beastmode to create a date by using the first of every month? Like "01/"&Month&Year?
-
Adding Sort to Custom Values
Hi, I have a card that identifies days since last activity date: Days Since Last Activity Date: DATEDIFF(CURDATE(),Enrollment Initiative: Last Activity Date) And I made a bar chart with a custom range using this beast mode: CASE WHEN Days Since Last Activity<7 then '<7' WHEN Days Since Last Activity<30 THEN '7-30' WHEN…
-
Create Bar Chart with Current Month Vs Previous Month?
Hello, I have a data set of invoices that I want to compare in a bar graph where one bar is March and the other bar is Feb. I think I can do this with a beast mode but I think my syntax is off. Case when Title LIKE '%OTT%' Then 'OTT' AND MONTH(Date) = CURRENT_DATE(MONTH(Date)) THEN 'Current Month' Case when Title LIKE…
-
Keep Columns After Using Group By Tile in ETL
I haven't played around with the group by tile yet so this might be a very simple answer I overlooked. But why do all of my columns disappear and leave only the columns I identified in the group by tile from my data after I use this function? I know I could join the data back in but I was assuming I was using it wrong.…
-
Identify percent of people attending current event
I am currently trying to gauge how many consistent event attendees are attending our upcoming show. For context, we have 2 events every year and every registration for an event is on a separate record which I have categorized by year between 2021-2024. I am trying to roll this up into a table that gives us a percentage of…
-
Flag percent of change when it goes negative
Hello, as the title says I am trying to figure out a beast mode or add an additional column in a view/etl to flag a member when they logged in fewer times this current month compared to the previous month. I manually upload the month's numbers at the end of the month so we are measuring trends and wanting to reach out to…
-
Transpose columns into multiple rows
I have this data set: Member ID 23-Jan 23-Feb 23-Mar 23-Apr 22-Jan 22-Feb 22-Mar 22-Apr 123 33 41 23 23 32 32 34 34 456 4 15 15 15 6 6 2 2 789 2 4 8 8 8 4 8 12 111 24 24 26 26 27 22 27 27 222 3 12 12 13 14 14 12 12 333 2 1 1 444 2 2 2 5 6 8 10 11 The date columns represent the amount of logins to their account by month. I…
-
Mimic Vlookup in Dataset?
As the title says, I am trying to mimic a vlookup on a dataset. I am using an ETL that is connecting different membership logs from SF. Basically every time a member leaves or joins it creates a new log. On one dashboard we are looking at data based on all the members who joined this year but also left this same time…
-
Making a formula that produces value from another column when conditions are met
Hi, I am trying to make a formula I feel like I have built a million times and for some reason, this is not working for me. Can someone tell me what is wrong with this formula? I am just trying to make a new column in a view that basically says if the "Current Log" checkbox is checked and if the "Website Status" is…
-
Can I make a grouped bar chart with 2 series/categories?
Hello! I am currently trying to make a grouped bar chart that is also stacked. In this scenario I want to compare our power and core members and within those groups how many of each are a website client with us. If they are a website client, I want that bar to be stacked to show what type of website that member has. This…
-
Has anyone used Illustrator to create an SVG for custom filter charts successfully?
I have been trying to create a custom chart for a few weeks with little success. I have used this guide found on a forum here to help me. I initially tried Inkscape, but it was less successful than Illustrator for me. I have gotten it so close at this point but I can't figure out why some of the regions are uploading…
-
Can I combine columns to create one column for a pie chart/bar graph visual?
In Salesforce, about 9 checkbox fields track whether a member signed up for that specific event. For example: But when creating a pie chart or bar graph, this becomes problematic because they are all separate rows. Is there a way to combine the data so I can have a member count for how many members signed up for Event 1…