Hello, I'm working on a App with multiple cards, all with the same date column in the data. I would like to take the custom date range that's available in the filter options: And add this to a Control at the top of the App: Thegoal being the users can filter all the cards by any date range they want. I figured out how to…
I have a dataset which holds transaction data. I have dates, i have derived a week column from date which has values like “2024/17”, etc. and I usually filter data based on weeks. My use case is when I select a week using 2 variables- one will pick year and other will pick week number, I want to subtract lets say past 4…
Hey! I wasn't sure if this went in Variables or Beast Mode questions. I have data that is currently structured: Opp Name - Value - Date Updated A - 100 - 3/15 A - 80 - 3/30 A - 120 - 4/5 B - 50 - 4/1 B - 75 - 4/7 The outcome I'm looking for is for a User to be able to input a Date (say 4/1) as a Variable and then have the…
As far as I know Variables can only have Controls that are single selection, is there a way to create mult-select variables and by extension multi-select controls?
I'm using variable as the filter for a dashboard. Basically I created variables named "timeframe" with values of Month, Quarter & Year On the breakdown, it works perfectly with timeframe as dimension. However, for the summary card, i used timeframe as the filter with the below SQL Funny thing is if I pull out sum('Budget')…
I am trying to create a card that will properly look back in time so that the dates being filtered reflect that look back in time. Here is the situation We get ratings from customers and want to wait a certain amount of time to measure the 'response rate' We do this by saying that it, on average, takes customers 75 days to…
I am building a dashboard that analyzes what the specific categories of items in any given transaction. For this example, let's assume there are 4 potential categories [Milk, Eggs, Bread, Fruit] on any given order. The end goal is to allow the user to select one or more of these categories in a slicer card (or similar),…
Hi, I have created a variable that I am using on the y-axis of a bar chart. With the toggle letting switch between categorical and date values. I would like to be able to alternate how the y-axis is sorted based on which variable value is currently on the chart: Date values: The date values are calculated by year and I…
I am trying to create a lookup using a variable where the user can type in the ID of a record and then the information for that record will display in a textbox card. Everything seems to work as expected other than pickheaderId will only search on the first record and not the whole dataset. Here's my variable calc: When i…
I'm trying to create a card where a user can switch between different aggregation groups for their x-axis. So if they select "Race/Ethnicity" they get something like this: and if they select gender: I successfully set up the variable: And the BeastMode referencing the variable: But when I try to graph using that BeastMode,…
It looks like you're new here. Sign in or register to get started.