-
Removing Duplicates and making sure only the one with the most recent move in stays
I am working on an ETL where I am transforming some unit rental records. I am trying to only include the most recent rental for the unit not historical data but the input dataset includes historical data. When using the remove duplicates tile I do not have control over which ones are removed or added as they arent…
-
BeastMode code to take one value from each category
This question is going to be really difficult to describe, but I will try anyway. I am trying to get a unit count for each facility, the problem is that bc we filter by time and different facilities can gain units over time, I can not just have one row per facility, I have a row for each month. That being said I need it to…
-
Combining Multiple columns into one column using beastmode
I am making a table card that uses multiple different rows. The way I am doing it is creating a variable named 'unit type' that when set to specific values returns a specific column. It then sets all the rows for which that column is blank to null and finally I filter out any null values. bellow is the beastmode I used,…
-
Trying to show Churn (%) as a percentage and Churn (#) as a regular number
Basically What the title says, I'm trying to figure out what I need to add to my beast mode to be able to switch between the unit type on the axis. I want to display Churn (%) as a percentage (without multiplying by 100) and show Churn (#) as a number. Attached is the beast mode that I have so far
-
Writing a Beast mode for a table card that selects a column and only displays rows with values
Hello, I am trying to write a beastmode for a table card where it picks a specific column based on a variable then only displays the rows in which that column has values. I know how to make a variable to select columns, but I can not get it to leave out the rows in which that column is blank. The first three images are…
-
Include Variable modifiers inside a filter card
I have my dashboard set up so that the filter options displayed are modified by the value of the variable. EX: notice how the filter by time options change depending on the time frame adjuster value in the screenshots. This is the best way I have found to do it, but my employers find it still extremely unintuitive. I think…
-
Default Value change from the dashboard
One of the big parts of our dashboard is allowing our users to set goals and track their progress toward their goals. I am currently using a textbox variable to let them change the goal, but whenever they refresh the goal goes away. So they end up having to go into the card to change it. While this isnt the hardest thing…
-
Y axis categories not interacting on dashboard
I am working on a dashboard, and I have been able to easily link my x axis categories like date quarter or region to where if I hover over one it highlights it on all the other cards in the dashboard. If I select one in a check box it filters out on all the cards. But the same is not true for the y axis. If I hover over…
