Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have some data on behalf of SubcompanyEntity wise FullUser Information with deploydate.
Now I want a bar chart SubcompanyEntity wise Max of Deployedate wise Sum of FullUser.
It Is giving me one output.
But I have 9 SubcompanyEntity.
Regards,
AA
Hi,
Try using below expression
=Sum({<[DeployedDate ] = {"=max([DeployedDate ]"}>} NoOfLicense)
Please check the output.
Name | #. of License |
Africa | 511 |
APAC | 50 |
AUS Bitumen | 150 |
AUS Neuuman | 245 |
Belize | 27 |
CENTAM | 346 |
Central | 71 |
Vietnam | 30 |
WEST | 80 |
Attached Out is not correct - I use the same - =Sum({<[DeployedDate ] = {"=max([DeployedDate ]"}>} NoOfLicense)
Thanks for reply
Both of your table are not linked to each other. am I missing something?
that's y its showing same value against all country
Please find the attached qvw for ref.