Best Of
Re: Text unique values - only count for each option
Imagine you had
C-Suite , VP, Director | 19 | Enterprise, Supply Chain
You'd need to duplicate the row a total of 6 times.
take the first column and duplicate each row by the number of Commas +1 (because that's how many respondents there are
In this example ,you'd want to duplicate that row 3 times. then use split-part() to keep the 1st, 2nd, and 3rd value.
you'd be halfway there b/c now you'd have
C-Suite | 19 | Enterprise, Supply Chain
VP | 19 | Enterprise, Suppy Chain
Director | 19 | Enterprise, Supply Chain
So then do the same process again on the 3rd column
C-Suite | 19 | Enterprise
C-Suite | 19 | Supply Chain
VP | 19 | Enterprise
VP | 19 | Supply Chain
...
use @MarkSnodgrass video as an example:
Re: Day on Day Change Issue
Hey, sorry if not made clear.
At the moment, depending on when the user views the cards, some of the records that make up the overall DoD value are from the previous day and some from the current day. So for DoD, I want to take the records up to '23:59:59' for each day, creating an internal day view.
amehdad
Re: Day on Day Change Issue
Thanks dthierjung for the write-up. I'll have a look tomorrow to see if using the previous day calculation to get the internal day value works for me, and report any futher updates that I may notice. The dataset 'campaign_schedule_date_local' just has date.
amehdad
Re: Saving a Drill Down View as its own Card
Apologies, there's already an option to 'Save as' via the Share menu when one is on the drill path view.
amehdad
Re: Centering a Summary Number
The center tag here is referring to the column alignment option in 'Format', right?
amehdad