How to make Card title dynamic

user18811

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 

DataMaven

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)

 

user18811

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!

---

 

guitarhero23

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.

DataMaven

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

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!

user18811

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!

---

 

DataMaven

So glad I could help, Priya!  (Is this Priya from GOSC?)