Hi folks, 

Just wondering is there any ways we able to apply Filters for Cloudability's report in bulk? I need to filter off 200/900 items which its a long long list. Anyone have any better ideas to do it better/efficient way? 

Thanks in advance. 

The workaround for the lack of multi-select in the filters that I've used is to concatenate a string with your values into the report's URL. 

for example create a new report with a couple of the values already set:

https://app.apptio.com/cloudability#/reports/report?category=Cost&custom=true&dimensions=tagX&end_date=23%3A59%3A59&filters=tagX%3D%3Dvalue1&filters=tagX%3D%3Dvalue2&limit=50&metrics=unblended_cost&order=desc&sidebar=editor&sort_by=unblended_cost&start_date=7+days+ago+at+00%3A00%3A00&title=Custom+Report

then use excel or a code editor to add extra values of "tagX" to the URL and paste it in a new browser tab:

https://app.apptio.com/cloudability#/reports/report?category=Cost&custom=true&dimensions=tagX&end_date=23%3A59%3A59&filters=tagX%3D%3Dvalue1&filters=tagX%3D%3Dvalue2&filters=tagX%3D%3Dvalue3&limit=50&metrics=unblended_cost&order=desc&sidebar=editor&sort_by=unblended_cost&start_date=7+days+ago+at+00%3A00%3A00&title=Custom+Report

i've never used it for 200 filter values but it's worked for me for a couple dozen. 

clunky workaround for sure. I hope there's a better answer out there. :-)

Hi folks, 

Just wondering is there any ways we able to apply Filters for Cloudability's report in bulk? I need to filter off 200/900 items which its a long long list. Anyone have any better ideas to do it better/efficient way? 

Thanks in advance. 

I should add that i do this for ad hoc or outlier requests. If the use case could leverage Business Mappings to solve (i.e. the groupings of values are persistent), that would likely be a better long term solution.

The workaround for the lack of multi-select in the filters that I've used is to concatenate a string with your values into the report's URL. 

for example create a new report with a couple of the values already set:

https://app.apptio.com/cloudability#/reports/report?category=Cost&custom=true&dimensions=tagX&end_date=23%3A59%3A59&filters=tagX%3D%3Dvalue1&filters=tagX%3D%3Dvalue2&limit=50&metrics=unblended_cost&order=desc&sidebar=editor&sort_by=unblended_cost&start_date=7+days+ago+at+00%3A00%3A00&title=Custom+Report

then use excel or a code editor to add extra values of "tagX" to the URL and paste it in a new browser tab:

https://app.apptio.com/cloudability#/reports/report?category=Cost&custom=true&dimensions=tagX&end_date=23%3A59%3A59&filters=tagX%3D%3Dvalue1&filters=tagX%3D%3Dvalue2&filters=tagX%3D%3Dvalue3&limit=50&metrics=unblended_cost&order=desc&sidebar=editor&sort_by=unblended_cost&start_date=7+days+ago+at+00%3A00%3A00&title=Custom+Report

i've never used it for 200 filter values but it's worked for me for a couple dozen. 

clunky workaround for sure. I hope there's a better answer out there. :-)

Hi folks, 

Just wondering is there any ways we able to apply Filters for Cloudability's report in bulk? I need to filter off 200/900 items which its a long long list. Anyone have any better ideas to do it better/efficient way? 

Thanks in advance. 

The workaround for the lack of multi-select in the filters that I've used is to concatenate a string with your values into the report's URL. 

for example create a new report with a couple of the values already set:

https://app.apptio.com/cloudability#/reports/report?category=Cost&custom=true&dimensions=tagX&end_date=23%3A59%3A59&filters=tagX%3D%3Dvalue1&filters=tagX%3D%3Dvalue2&limit=50&metrics=unblended_cost&order=desc&sidebar=editor&sort_by=unblended_cost&start_date=7+days+ago+at+00%3A00%3A00&title=Custom+Report

then use excel or a code editor to add extra values of "tagX" to the URL and paste it in a new browser tab:

https://app.apptio.com/cloudability#/reports/report?category=Cost&custom=true&dimensions=tagX&end_date=23%3A59%3A59&filters=tagX%3D%3Dvalue1&filters=tagX%3D%3Dvalue2&filters=tagX%3D%3Dvalue3&limit=50&metrics=unblended_cost&order=desc&sidebar=editor&sort_by=unblended_cost&start_date=7+days+ago+at+00%3A00%3A00&title=Custom+Report

i've never used it for 200 filter values but it's worked for me for a couple dozen. 

clunky workaround for sure. I hope there's a better answer out there. :-)

Hi folks, 

Just wondering is there any ways we able to apply Filters for Cloudability's report in bulk? I need to filter off 200/900 items which its a long long list. Anyone have any better ideas to do it better/efficient way? 

Thanks in advance.