How to count the number of tracks in Deneb using a dataset with multiple tracks per row

[edu_210981]

Hello, I am using Deneb to create a chart that shows the number of tracks in my dataset “Spotify Dataset (3)”.

The problem is that my dataset has multiple tracks per row, separated by commas. For example, row 1 contains the information for the tracks “Shape of You” and “Perfect”, by the band Ed Sheeran. I tried to use the measure _Track = count('Spotify Dataset (3)'[track_name]), but it only returns the number of rows, which is 953.

I want to count the number of tracks in my dataset, not the number of rows. How can I do that in Deneb? I have tried several types of measures, but none of them worked. Can anyone help me? Thank you.

In short:

I want to create this Deneb HeatMap with Park bars, link:
https://www.youtube.com/shorts/E2wjo4FaVjk

Code Github:

https://github.com/PowerBI-tips/Deneb-Templates/blob/main/templates/heatmap%20with%20bars%20-%20red%...

on line 41 I changed the KPI to the measure name _Track, but it doesn't work either

Thank you very much for any help!

[giammariam · Accepted solution]

Hey @edu_210981, let me know if the logic in this spec will help.

The important part:

  "transform": [
    {"calculate": "split(datum['track'], ',')", "as": "track"},
    {"flatten": ["track"]}
  ],

If this is enough to get you going please consider liking this reply and choosing it as the solution. Otherwise, I'm happy to help further.

[giammariam · Accepted solution]

Hey @edu_210981, did this end up working? Happy to help further if not. 

[edu_210981 · Accepted solution]

Madison, Thank you very much for all your contribution and sharing knowledge to the entire community. I got the resolution, it worked here, after taking it easy and analyzing it, it was actually simple, lol.... Hugs, Edu | São Paulo | Brazil

[giammariam · Accepted solution]

Hey @edu_210981, did this end up working? Happy to help further if not. 

[giammariam · Accepted solution]

Hey @edu_210981, let me know if the logic in this spec will help.

The important part:

  "transform": [
    {"calculate": "split(datum['track'], ',')", "as": "track"},
    {"flatten": ["track"]}
  ],

If this is enough to get you going please consider liking this reply and choosing it as the solution. Otherwise, I'm happy to help further.

[edu_210981 · Accepted solution]

Madison,

Thank you very much for all your contribution and sharing knowledge to the entire community.

I got the resolution, it worked here, after taking it easy and analyzing it, it was actually simple, lol....

Hugs,

Edu | São Paulo | Brazil

[edu_210981 · Accepted solution]

Madison, Thank you very much for all your contribution and sharing knowledge to the entire community. I got the resolution, it worked here, after taking it easy and analyzing it, it was actually simple, lol.... Hugs, Edu | São Paulo | Brazil