Forum Discussion

dogcat's avatar
dogcat
Regular Visitor
8 years ago
Solved

Modify YoY% quick measure to filter data points in the future

The quick measure YoY% is giving me results for the future 12 months.  I want the YoY% to only match the dates for which there is data (Purchases).  My data ends in 12/2017 and I want the YoY% to sto...
  • MFelix's avatar
    MFelix
    8 years ago

    Hi dogcat,

     

    You are using a calendar column on your graph right?

     

    Just go on the visual filter and all non blank on the Purchase values will filter out all the dates that are blank in the purchase.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi dogcat,

 

You are using a calendar column on your graph right?

 

Just go on the visual filter and all non blank on the Purchase values will filter out all the dates that are blank in the purchase.

 

Regards,

MFelix

dogcat's avatar
dogcat
Regular Visitor
8 years ago

Yes on the calendar table.  I was trying so hard to filter by date it didn't occur to filter by presence of or lack of a value.  Thanks.