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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive