How do i do a beast mode formula to get the response value of a record that was completed most recently? If this is my data i want to just take the bottom row. My groupings cant be changed in magic etl just need to take response value with highest or most recent time Name Location Time Response value Ben A 2:07PM 5 John A…
I have a beast mode that is comparing actual performance to a target (by categories) by taking the sum of actuals - sum of targets over an arbitrary date range, defined by user input into variables on the dashboard page. This works great as a quick filter control for an individual card, but when I make a filter card using…
I need to calculate failure rates using two different date columns but the Fixed by calculation doesn't work for this. All calculations go by the date field selected on the chart, but I need a Beast Mode that ignores the default date on the chart. For instance, if I want to show units sold by Sales Date but also show units…
I am trying to find a way by which when a user view the Dashboard, then based on his/her PDP, s/he must see his/her own score and must see his/her Direct Reports entire span/ org score. I have attached a dummy data creating the scenario and along with it I have added Org Chart and the Views that is expected. Any help in…
I'm working with a dataset that contains daily level data, including a date column. I've created a calculated field based on this date column. However, when I try to aggregate the data by 'week' using 'graph by= week', I'm only able to see the values for each individual date rather than aggregated weekly totals. I've tried…
I have a multi-selection attribute with 19 selection options within it. I am trying to group these 19 selection options into 5 slices on a pie chart with this code: case when Impacted Business Division_p LIKE '%Biologics%' then 'Biologics' when Impacted Business Division_p LIKE '%CGT%' then 'CGT' when Impacted Business…
Hi gang! I've done a mockup here to try and explain what's going on with my dataset and what I want to achieve. The first table below shows my dataset. We don't need the month column for this, but I wanted to include it to explain why each project has multiple rows in the dataset. Essentially, I want to SUM the PlannedCost…
I have the following on a dashboard: I want the user to be able to filter the left and right charts using the slicer for different time periods, without resetting one when the other is used. Meaning, I want the left chart to show me FM6 and the right to show FM7. Any ides how I can go about this? The charts are already…
Hi there, I recently saw this video on DOMO Variables from Zack Cameron and around the 17:30 mark he's using variables to control the Time Range (YYD,QTD,MTD,WTD) and Time Comparison Option (YoY, PoP). This functionality would be perfect for the dashboard I'm building out, but I'm having trouble recreating it. The code for…
I have ingested a data which is regarding the Employee HC. Its per month. I have uploaded first 6 months of data in my ingestion dataset. In my dataset, I have used the append method to update. I have to prepare an ETL to power a new dataset. The dataset is supposed to have data for all months of all clients. The ingestion…
It looks like you're new here. Sign in or register to get started.