Dynamic Segments
Good Afternoon,
I am needing assistance with making a segment on my line graph dynamic based on the applied filters. Currently, I have a segment that sums the total spend by paid ad sources. However, when I apply filters for different sources the total segment number remains unchanged. Ideally, I would like this segment to reflect the total spend of the filtered sources.
For example, the initial graph displays various sources with a total segment shown in black. (Screenshot provided.) Suppose the total segment indicates $400,000 on 6/9, and the individual sources add up to this amount. If I filter to only include Amazon and Facebook, I want the total segment to update and reflect the combined total spend of those two sources, instead of maintaining the original $400,000.
Similar to how a nested bar graph works. Is there a chart property or setting I might be overlooking that would enable this dynamic update based on the filters applied?
Best Answer
-
I was able to figure it out. It was because on the Segment I created I selected all of the sources; however, that prevents them from being dynamic. So, just had to make sure it looked like this.
0
Answers
-
It sounds like you're trying to create a dynamic segment that updates based on filters, reflecting the total spend of filtered paid ad sources in your line graph. Assuming you have a dataset that includes columns like Date, Paid Ad Source, and Spend.
CASE WHEN Paid Ad Source IN ('Amazon', 'Facebook') THEN Spend ELSE 0 END
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Yes, I want the total segment to update based on when I filter the card to the particular source. So, for example if I have the source filtered to Amazon and Facebook - I would want the total line to only reflect Amazon and Facebook spend.
Are you saying to use that formula as a beast mode and use that on the Y-axis? Because I don't see an option to make the segment as a formula.
0 -
My formula was an example to show you how you might replace spend with a formula based on specific paid ad sources. If you want a dynamic total that updates based on filters, you don't need a specific formula just for filtering if the existing data.
On the card with your graph, make sure your filters are applied to the entire dataset and not to a limited series or segment. Put the [spend] field on the Y-axis. [date] on the x-axis. And [paid ad source] to the series or category axis. When you use filters on the card and select sources (Amazon, Facebook, etc), this should automatically update the entire graph, including the total.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Make sure your filters are based on the same dataset as the graph. Filters work across cards, based on common fields with exact same naming.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Unfortunately, it doesn't which is the issue I'm running into. This is an example of how the data is being broken down.
Here is a screenshot of the fields I'm using on the card and the chart type I'm using.
No matter what sources I have selected and deselected the total segment line is staying constant of the overall total. The black line is the total.
0 -
I was able to figure it out. It was because on the Segment I created I selected all of the sources; however, that prevents them from being dynamic. So, just had to make sure it looked like this.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive