Best Of

Formatting Numeric Values within CONCAT functions to Currency

Hi there!

In one of my graphs, I have created a few beast modes involving nested CONCAT functions so I can capture many fields in a hover text. Some of the fields in the CONCAT are numeric but I would like them displayed as currency. After running the beast modes, the numbers are displayed as a long integer with no thousand separator etc. I understand that using my quantitative fields in this way means that I cannot use the 'Display as' format option in the Analyzer. I was wondering if there is something I can do prior to the Beast Mode CONCAT, such as an ETL node or mySQL code?

Cheers

amehdad

9

Re: Dojo Contest is LIVE!

Dojo is a great forum to find inspiration for a new card, dashboard, beast mode or ETL setup or search for answers to annoying questions during one's build. I love using Domo, and I appreciate this space to collaborate and learn off one another.

amehdad

7

Re: Dataset/Card Certification History

Hi @Jmoreno, from what I understand, this feature is not currently available on any of the DomoStats connectors. It's worth checking with your CSM

amehdad

3

Re: Dashboard performance problem

One another note, I made an idea suggestion around having the ability to pinpoint areas around dashboard performance: https://dojo.domo.com/main/discussion/53832/dashboard-performance-report. Please upvote if you agree

amehdad

9

Re: Dashboard performance problem

Hi @Jones01, one suggestion is get your dataset, which powers your dashboard, to only have the relevant data for those views (as opposed to fetching all the possible records from those 7 inputs datasets). This can be done on the ETL v2, where you can filter records or remove columns, so that the processing time is reduced.

amehdad

4

Re: Mod please remove

Commenting to remove from 'Unanswered' category

amehdad

7

Re: SharePoint Writeback Connector

Hi @yli_2596, it may be that the SharePoint site you've used (using the Site and Group Site ID) only has the one place recognisable by the connector to store data (i.e. The external sharing settings, permissions for your other featured sites are not the same as your root/base level site).

amehdad

10