-
1. Re: URL Action specific to a single cell
Shinichiro MurakamiSep 6, 2018 7:20 AM (in response to Mark Westendorp)
Please attach sample data as twbx format and illustrate what kind of action you expect.
Thanks,
Shin
-
2. Re: URL Action specific to a single cell
Mark Westendorp Sep 6, 2018 7:47 AM (in response to Shinichiro Murakami) -
3. Re: URL Action specific to a single cell
Shinichiro MurakamiSep 6, 2018 7:50 AM (in response to Mark Westendorp)
Need to see the data, could you please attach.
Shin
-
4. Re: URL Action specific to a single cell
Soham Wadekar Sep 6, 2018 8:02 AM (in response to Mark Westendorp) -
5. Re: URL Action specific to a single cell
Mark Westendorp Sep 6, 2018 8:04 AM (in response to Shinichiro Murakami)Here is the dashboard with sample data.
-
6. Re: URL Action specific to a single cell
Mark Westendorp Sep 6, 2018 8:07 AM (in response to Soham Wadekar)Yes a URL per row will work
-
7. Re: URL Action specific to a single cell
Soham Wadekar Sep 6, 2018 8:13 AM (in response to Mark Westendorp)I guess, you will have to create an additional field in the database which will hold the URL,
So if you want to have different URL`s for different departments, then create an additional column URL- which will hold the actual URL for each department.You can then create your table and include the URL column something like this
and then lastly just hide the URL field from the actual view(you can keep it if you want to). This will get you here
and you will have different URL`s for different rows
Let me know if this helps.
Soham
-
8. Re: URL Action specific to a single cell
Shinichiro MurakamiSep 6, 2018 8:30 AM (in response to Mark Westendorp)
Hi Mark,
Action required trigger, which is always "Dimension".
In your case, the cell is consist of "Dimension" and "Measure value(Measure name)", not dimension.
So assigning action to respective cell is not available.
To make that happen, you need to convert Measure name to dimension with Pivot.
However, that will break all the formula you already created and the book creation need starting over.
You can judge the starting over is worth paying to add this function or not.
If you think it is, you can start from here, and if you have questions, you can post new one.
Pivot Data from Columns to Rows
Or if you really need this function, please reply so, I will assist as much as possible, but please remember all the works you made need to be redone.
Thanks,
Shin
-
9. Re: URL Action specific to a single cell
Mark Westendorp Sep 6, 2018 8:45 AM (in response to Soham Wadekar)My issue now is that when I select <URL> and test the link, it is being linked to a URL that isn't on the selected row.
-
10. Re: URL Action specific to a single cell
Soham Wadekar Sep 6, 2018 8:50 AM (in response to Mark Westendorp)can you upload the latest workbook? one with this issue?
-
11. Re: URL Action specific to a single cell
Mark Westendorp Sep 6, 2018 9:15 AM (in response to Soham Wadekar)