Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
How to show Max Date record(text) in map chart by default?
Expected result: -
should default to max date record instead of select the date 02/07/2018(selection).
Attached qvf file & kml file.
[Data]:
Load * inline
[
Block, Date, Quantity, Status,
B1, '01/07/2018', 100, 'In Progress'
B2, '01/07/2018', 200, 'In Progress'
B3, '01/07/2018', 300, 'In Progress'
B1, '02/07/2018', 100, 'In Progress'
B2, '02/07/2018', 200, 'In Progress'
B3, '02/07/2018', 300, 'Completed'
]
;
Hi Chris,
Your Expression may like below:
In Progress:Sum ({<Date={'$(=max(Date))'}Status={"In Progress"}>}Quantity)
Completed:Sum ({<Date={'$(=max(Date))'}Status={"Completed"}>}Quantity)
Thanks,
Arvind Patil
Thank for your reply,
What I want to display is the status( In Progress or Completed ) not the quantity.
Hi Chris,
From the property add lable what you want.
Thanks,
Arvind Patil
Thanks,
That's what i am doing now, any help is appreciated.
1) This is my expected result. but should be without the date selection(default to max date)
2) This is my output now.