0 Replies Latest reply: Jan 2, 2014 3:56 PM by Yala RSS

How to split the report into different versions view 1 agent delivery

Yala Newbie
Currently Being Moderated

Hello

 

I have a scenario where I need to send a dashboard to multiple users. The user information are stored in the table like the following:

 

USER    Day     Car                  Pay Type                    Cost   Email

USER1-10-2HondaCustomer Pay500USER1@GMAIL.COM
USER2-4-1AUDICustomer Pay + Warranty1000USER2@GMAIL.COM
USER2-4-1PORSCHECustomer Pay + Warranty1000USER2@GMAIL.COM

 

Now I have a dashboard call Car, on this dashboard I have prompts like Date, Car, Pay Type, Cost, pretty much the same name as the columns in the above table. I have also set up session variables to pick up users based on the log in.

 

Now for user2, he is getting 1 email, which is the dashboard with both Audi and Porsche on there. Instead, he wants to 2 attachments, 1 for Audi and 1 more Porsche. Is there a way to achieve this using 1 agent?

 

Please let me know how to split the result sets based on user records in the table

 

Thank you

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points