jessymarteen

Discussions

Distinct Count with Case statement not working
This is a bit of an odd issue, the below calculation ends up adding 1 when rolling up data: Distinct count of ID (if Flag=1)=COUNT(DISTINCT CASE WHEN Flag=1 THEN ID ELSE 0 END) ID Flag Distinct count of ID (if Flag=1) GRAND TOTAL 1 2 456123 1 1 123456 0 1 654321 0 1 Any ideas why this might be happening? This is a mega…
How do I use the XML Advanced Connector to return cdata?
The data I'm trying to pull in is from a URL and every piece of data is wrapped in cdata tags so Domo isn't recognizing it or returning any data. Is there a way I can pull this in? Here is a sample of how the data is set up in the XML: <allData> <unit> <Name> <![CDATA[ Group A ]]> </Name> <number> <![CDATA[ 123456789 ]]>…

Distinct Count with Case statement not working
This is a bit of an odd issue, the below calculation ends up adding 1 when rolling up data: Distinct count of ID (if Flag=1)=COUNT(DISTINCT CASE WHEN Flag=1 THEN ID ELSE 0 END) ID Flag Distinct count of ID (if Flag=1) GRAND TOTAL 1 2 456123 1 1 123456 0 1 654321 0 1 Any ideas why this might be happening? This is a mega…
How do I use the XML Advanced Connector to return cdata?
The data I'm trying to pull in is from a URL and every piece of data is wrapped in cdata tags so Domo isn't recognizing it or returning any data. Is there a way I can pull this in? Here is a sample of how the data is set up in the XML: <allData> <unit> <Name> <![CDATA[ Group A ]]> </Name> <number> <![CDATA[ 123456789 ]]>…