Dynamically show Dates

juliannarenaud1
juliannarenaud1 Member
in Archive

We have a collection of cards that all look like the image below, each for a different KPI (Demand, Traffic, etc). These cards are built utilzing beast modes that pull in MTD data based on a fiscal month. As a result the date ranges for each bar change daily. I'd like to add a card to the collection that dynamically populates the dates being pulled. For example, today the card would read something like "2016: 1/31/16-2/9/16 & 2017: 1/29/17-2/7/17". Then tomorrow the card would need to say "2016: 1/31/16-2/10/16 & 2017: 1/29/17-2/8/17." How can I make this possible?

MTD Image.jpg

Comments

  • dougstewc
    dougstewc Domo Employee

    Hi @juliannarenaud1.  I want to make sure I understand your question correctly.  Are you looking to have a new card that is only there to show the range for each year?  If that is the case, would you be comfortable showing what the MTD beast modes look like? Thanks!

    **Say “Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • juliannarenaud1
    juliannarenaud1 Member

    Sure, here is the formula for MTD 2016 Demand: 

    SUM(
    CASE WHEN DAY(`Date`) <= (DAY(SUBDATE(NOW(), INTERVAL 5 HOUR))+1)
    AND YEAR(`Date`)+`Days to Add to Put Into Proper Fiscal YEAR` = (YEAR(SUBDATE(NOW(), INTERVAL 5 HOUR))-1)+`Days to Add to Put Into Proper Fiscal YEAR`
    AND MONTH((`Date`)+`Days to Add to Put Into Proper Fiscal MONTH`) = MONTH((SUBDATE(NOW(), INTERVAL 5 HOUR))+ `Days to Add to Put Into Proper Fiscal MONTH`)
    THEN `Transaction Revenue`
    END)

     

    Here is the formula for MTD 2017 Demand: 

    SUM(
    CASE WHEN YEAR(`Date`)+`Days to Add to Put Into Proper Fiscal YEAR` = (YEAR(SUBDATE(NOW(), INTERVAL 5 HOUR)))+`Days to Add to Put Into Proper Fiscal YEAR`
    AND MONTH((`Date`)+`Days to Add to Put Into Proper Fiscal MONTH`) = MONTH((SUBDATE(NOW(), INTERVAL 5 HOUR))+ `Days to Add to Put Into Proper Fiscal MONTH`)
    THEN `Transaction Revenue`
    END)

  • dougstewc
    dougstewc Domo Employee

    Thanks @juliannarenaud1.  Have you tried creating a beast mode to identify the start and end dates and concat them together into a range and then show that in a table card?

    **Say “Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • juliannarenaud1
    juliannarenaud1 Member

    No, thoughts on what that might look like?

  • dougstewc
    dougstewc Domo Employee

    Do you have a dataset that defines the fiscal calendar within your instance?  Something that shows each day, and what fiscal month that day is in?

    **Say “Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • juliannarenaud1
    juliannarenaud1 Member

    Yes, it's even already connected to the GA data used to populate the cards.

This discussion has been closed.

Categories