Trying to allow a property control to switch binning on single date column between calendar year and fiscal year.

I need something like:

 

<($esc(${DisplayByFyVsCy})[created_date],"Year.Quarter.Month.Day",${HierDate})>

but that gives me error message:     The expression is not valid after '[BinByDateTime]' on line 1 character 3.

 

I'm modifying what I found at:  https://techgoje.wordpress.com/2014/11/30/spotfire-changing-time-hierarchy-when-using-multiple-date-columns/

 

It works great to switch between two different dates, but I want to use the same date, just bin it differently.

 

Screen shots attached of my property controls.

 

 

Attachments

AttachmentSize
File propertycontroldatebin.docx137.07 KB

(1) Answer

Login