How to make Card title dynamic
Hi All,
I want to make my card title dynamic. I have last two year of data month-wise for which i want to make my cards title dynamic respective to the quick filter selection (already put years and months on quick filter).
For example : if some one choose 'Dec' in month and '2018' in the year in the card title same should reflect.
Is any way out to implimate this. Kindly help if anyone has any idea on it.
Regards
Priya
Best Answers
-
It's true that the titles are plain text, but you can do some really cool stuff with the summary numbers. it can take some cajoling, so I am providing a sample that I have verified works.
Friends and I have found that tect must be concatenated for it to work, even if only one value is present in the concatenation. I think it also needs to be part of a case statement. Basically, the beast mode you create will show up as an option as a summary number if it is set up right.
(CASE when
min(`Event_Time`) = max(`Event_Time`)
then DATE_FORMAT(MAX(`Event_Time`),'%b %Y')
else concat('Invalid selection, please select only one month at a time')
end)You can also use colors!
***Note - The color will not render until you save and close.
(CASE when
min(`Event_Time`) = max(`Event_Time`)
then DATE_FORMAT(MAX(`Event_Time`),'%b %Y')
else concat('<div style="color:#FF0000"<p>','Invalid selection, please select only one month at a time','</div>')
end)DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Hi DataMaven,
Thank you for sharing this code. I can use it in my Dashboard.
Regards
Priya Raj
@DataMaven wrote:Hello @user18811 - Did my response meet your needs? I am close to my next badge for solutions, and would love to earn it before Domopalooza! Thanks!
0
Answers
-
I do not believe this capability exists in Domo, it would show in the date section when interacting with the card and you could make a calculated field to make sure it shows somewhere in the data, but not the title.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
It's true that the titles are plain text, but you can do some really cool stuff with the summary numbers. it can take some cajoling, so I am providing a sample that I have verified works.
Friends and I have found that tect must be concatenated for it to work, even if only one value is present in the concatenation. I think it also needs to be part of a case statement. Basically, the beast mode you create will show up as an option as a summary number if it is set up right.
(CASE when
min(`Event_Time`) = max(`Event_Time`)
then DATE_FORMAT(MAX(`Event_Time`),'%b %Y')
else concat('Invalid selection, please select only one month at a time')
end)You can also use colors!
***Note - The color will not render until you save and close.
(CASE when
min(`Event_Time`) = max(`Event_Time`)
then DATE_FORMAT(MAX(`Event_Time`),'%b %Y')
else concat('<div style="color:#FF0000"<p>','Invalid selection, please select only one month at a time','</div>')
end)DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Hello @user18811 - Did my response meet your needs? I am close to my next badge for solutions, and would love to earn it before Domopalooza! Thanks!
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Hi DataMaven,
Thank you for sharing this code. I can use it in my Dashboard.
Regards
Priya Raj
@DataMaven wrote:Hello @user18811 - Did my response meet your needs? I am close to my next badge for solutions, and would love to earn it before Domopalooza! Thanks!
0 -
So glad I could help, Priya! (Is this Priya from GOSC?)
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive