I have a number of stat (not single stat) panels where I had 3 different values with 3 different field titles.
E.g values were 559,1118,36282 and the titles were TODAY, MTD and YTD respectively. Now suddenly all three values have the same title (YTD).
Now I can’t get there to be a seperate Field Title again for each value
Using the following sql for example given;
select sum(TODAY) TODAY, sum(MONTH) MTD, sum(YEAR)YTD
from(
SELECT count(ORDERLINEKEY) TODAY, 0 MONTH, 0 YEAR FROM inforlog.infortmsorderdetail
where release_date = DATE(SYSDATE())
and category = ‘EDI’
union all
SELECT 0 TODAY, count(ORDERLINEKEY) MONTH, 0 YEAR FROM inforlog.infortmsorderdetail
where release_date >= DATE_FORMAT(SYSDATE(), ‘%Y-%m-01’)
and category = ‘EDI’
union all
SELECT 0 TODAY, 0 MONTH,count(ORDERLINEKEY)YEAR FROM inforlog.infortmsorderdetail
where release_date >= DATE_FORMAT(SYSDATE(), ‘%Y-01-01’)
and category = ‘EDI’
)t
result in table form looks like
|TODAY|MTD|YTD|
|559|1118|36282|
