Report to loop through Sales People that have Sales in the selected period (and ignore those that don't).

[canoebi99]

Hi all, 

I am trying to create a report using the application automation to be emailed to all the Sales People that have sales in a given month. 

I have tried to do this by creating a report, then adding the sheets required and then adding a selection to the report for the current year and month (using the get variable block to collect the current year and month from the app). 

The challenge I am having is how to only loop through the Sales People that have sales for that period. 

If I use the "List values of Field" block or the Get Straight table block these both seem to ignore the selections I have placed on the report so I can only get a list of all the Sales People rather than just those with Sales for the period selected. 

Am I right in thinking that the add selection to report does not affect those blocks? If so is there a way to return a list of only the sales people with sales in the current year and month so that I can then use that list to loop through and select each sales person for sending out the emails? Essentially I want to return a list of the possible values from the Sales Person field once the year and month selections are in place?

Thanks in advance. 

[canoebi99]

Update: I managed to acheive this by adding a straight table into the app that had the required filtering (sales year and month) and Sales Person name so that I could use that and the get straight table block for my list. 

I suspect there is a better way so I would still appreciate further comments because I don't really want to clutter the app up with straight tables which I will have to doing things this way. 

[MBardy]

i all,

I am facing the same problem, how can we use "List values of field" based on previous selection in the report.

For the moment, "List values of field" output all possible value for a field, no matter if a selection was made before.

Example  : 

i want to generate a report with a first page "Region" and loop after on town of this region.

Even if i set a selection to the report on the "Region" field, "List value of field" on Town field will ouput all possible Town in the app.

Thank's

[Ramina]

Having the same problem

[lvdbrink]

If you make sure to create a master item for the dimension you want to list the filtered values for, you can use the "List Dimension Values" block after applying a selection using the "Select Field Values By Query" block.

[Ramina]

it doesn't make sense, what you wrote. I don#t want to put a hard selection on a field or dimension, but to loop through different values that are possible and not through all values.

[lvdbrink]

That is exactly what my proposed solution does, from the post I was responding to:

"i want to generate a report with a first page "Region" and loop after on town of this region.

Even if i set a selection to the report on the "Region" field, "List value of field" on Town field will output all possible Town in the app."

You can achieve this by applying a selection for "Region" to your dataset by using the "Select field values by query" block and then use the "List dimension values" block on the Master item that holds the "Town" dimension.

The "List values of field" block will not respect an applied selection, the "List dimension values" block will.

[Ramina]

I swaped to Tabular Reports and could solve my problem the other way: I just concatenated two Fields in one: in your case it would be REGION_TOWN. And it worked. I think the same should work in automations. 

[salmankojar]

HI @canoebi99 you can use the straight table data from the app and apply the selections as shown in the Automation Json attached. Make the necessary changes as per your requirement..just try this automation and let me know if i can help.