Report Row Coordinates
답변함Is it possible to make "View Row Coordinates" visible by default in a report? I am frequently looking at the number of records in reports and have to toggle on Row Coordinates, it would be very helpful to make row coordinates permanently displayed.
-
Hi Christopher!
Great question. Unfortunately, at this time the ability to View Row Coordinate is not available in Workiva. However, if a count of records is what you are looking for, we CAN do a count for unique values and all values (if there are duplicate records in the report). You can the save the count as a view and can always go to the view to see the number of records without having to add it each time. Does this make sense?
Hopefully this is of some help. Let me know what questions you have for me, or if you need anything else. Thanks much and have an awesome day!
0
Hey Mike!
Tagging onto the above - is there a way for us to use a formula to do a count for unique/distinct values in Wdesk? My Excel formula works in Excel and returns a value of 13 for example (i know you don't see the data here but just wanted to make the point that it works in Excel) but I have no luck getting the same formula to work in Wdesk
=SUM(1/COUNTIFS(C2:C161,C2:C161))
where the range of data is C2:C161
0
Hi Gaby!
Hmm.... good question. A COUNTIFS should work to help find a distinct set of criteria, though I don't think Workiva will allow a COUNTIFS with a range as the criteria. I do find some requests for the function COUNTUNIQUE which I'm happy to add you too as well.
0댓글을 남기려면 로그인하세요.
댓글
댓글 3개