Sam_Y

@ST_-Superman-_ Also - thanks for responding!!!

@ST_-Superman-_ To answer your question yes and yes. I think I found the issue. I have a Rank function earlier in the data flow that uses End Date to rank the rows in the partition. In this example, there were two rows with the same End Date so it ranked them both Student Enrollment # 6.

Additional Information: When I filter the data flow down to a single Student Index, the function works fine. When I remove the filter to include all rows, the function presents itself as shared above

I just tried the Advanced Connector and it gives the ability to enter a partial name for the Subfile. That may work for me.

@jaeW_at_Onyx We were able to combine the files into 1 json within the Amazon bucket, however, the JSON file name will change every day within the zip. Today's file is 2020-09-21_nl_replica.json Tomorrow's file will be 2020-09-22_nl_replica.json Will the Discovery option automatically pull the 2020-09-21_nl_replica.json…

Thanks @GrantSmith ! I ended up creating a flag in the data set to leverage.

Issue was that I could not send to myself.

I should have mentioned that I am not receiving those either.

This also worked. Thanks!

I stumbled upon this same thing today. Thanks for the input!

Thanks!!!

Thanks for the response. So in your solution, the person receiving the report would need to have a DOMO license?

I found that the Transpose option on the Table Chart Type met my needs. Thanks for the advice

I tired the Pivot Table but defaults to Count Aggregation for non-numerical fields like Address or State. Do you have any other suggestions?