Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I am scripting the popup content in SVG map extension. The content I am going to show is like this (as follows):
Sales: $2000
Quantity: 300
# of customers: 60
Since the total sales, quantity and number of customer need expressions, how can I combine the text and expression together using script? Thank you so much!!!
Best Regards,
Gloria
Something along the lines of:
='Sales: '&sum(sales)&'<br/>'&
'Quantity: '&sum(quantity)&'<br/>'&
'# of customers: '&count(distinct customer)
The <br/> is the html equivalent of the ascii chars that are used in standard QV chart text.