Best Of
Re: Counting or Grouping?
@Domolex welcome to the forum (and there are no bad questions here). It is certainly smart to first try and build what you need off the source dataset and see if you can skip the ETL execution.
To count distinct event ids you can create a beast mode that looks like this:
COUNT(DISTINCT eventid)
You can put your date on the x-axis and this beast mode on the y-axis and set the date range filter to graph by month and you would have your events by month.
Re: Is there a way I can see what dashboards a card is on from the card details page?
@ksmith If you click on the information icon next to the card name, it will open a dialogue that lists all the dashboards where that card resides
Re: Any ideas how to best visualize boolean data?
Perhaps a horizontal bar chart to see what the top selected values are for a group of participants? Or do you want to see individual responses?
Re: Any ideas how to best visualize boolean data?
You could use an HTML table and then create a beast mode that pulls in an image of a checkmark
CASE WHEN `myBool`
then
CONCAT('<div style="text-align:center"><img height="20px" src="https://banner2.kisspng.com/20180715/klo/kisspng-check-mark-emojipedia-computer-icons-symbol-cek-5b4bdef7a0b662.6919404015316989356583.jpg">','</div>')
end
Re: Filter does not work on all cards in an App
Ensure that the name of the beastmode is identical in both datasets. Also check that you don't have any filter exceptions in place for that card.
Re: Color rules based on today's date instead of a static date
Hi Sridhar,
If I understand your question correctly, something like this in a beastmode might work:
case
when `date` <= CURDATE()
then CONCAT('<div style="background-color:#bbe491; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', `date`, '</a></div>')
end
Is that what you're looking for?
![[Deleted User]](https://us.v-cdn.net/6032830/uploads/defaultavatar/nZ5X977MOM3Z6.jpg)
Re: SALT LAKE CITY CONNECTIONS TOUR CHECK IN
Hey hey! Loving the Connections Tour so far!
Re: Working with hh:mm:ss values
I took your sample times and was able to add them up using the following in Magic ETL:
Your group by would likely look different than mine, likely some sort of event id or something.
I used split_part to break out the individual time elements and get a total number of seconds and then use the group by to sum it up. The next formula tile breaks it back out to the individual time elements and the concatenate them together. I use Floor to get the highest whole number and then convert it to an integer so that it is a whole number.
Re: Unpivot
Hello @verytiredgirl,
You can do it in several steps. Here is the example data:
First, make Dynamic unpivot:
Split the unpivoted column into two columns: one for dates and one for types:
Change the format of the 'Date' column into Date with the Alter Columns tile:
And finally, pivot the 'Type' column:
Here is the result:
I hope this answers your question ;)
