I want to create a Card/visualization in DOMO which will fetch data from Excel

Dheeraj_1996 · 2023-07-21T16:41:40+00:00

There was an error rendering this rich post.

Dheeraj_1996

I want to create a Card/visualization in DOMO which will fetch data from Excel for a PPT and show the info in the below format. How can this be done?

Find more posts tagged with

Visualization

Cards

powerpoint

Accepted answers

ColemenWilson

This is something I have done both with a DDX brick and a standard text card. The text card is probably easier.

Here is the beastmode:

CONCAT(`Title`,'<br>','•',`Value1`,'<br>','•',`Value2`)

There are a variety of bullet symbols, some can be found here: https://www.symbolcopy.com/bullet-points-symbol.html

Additionally I would play around with the chart properties:

Screen Shot 2023-07-21 at 11.25.42 AM.png

That should get you something looking pretty nice.

All comments

MarkSnodgrass

You can use the new Office add-in to have your Excel file be a dataset in Domo. You would then power your card off of that dataset in Domo.

Dheeraj_1996

that I am already using. but I want to create a card or a visualization in the below format from the dataset which is fed from the excel. Data with bullet points

MarkSnodgrass

There isn't a native chart type that would provide that layout. You might want to look at the Domo Bricks to see if there is something that would do that. If you are familiar with Javascript, you could use the Domo Blank Brick and build the bullet list array to pull this off.

You could also look at the notebook card, but I don't think that will meet your needs, but thought I would mention it.

Dheeraj_1996

I tried the domo notebook, but I was not able to add the data from the dataset in it. is there a way this can be done? and does the DOMO PPT plugin fetches notebook in the PPT?
where can I find the DOMO blank Brick?

ColemenWilson

This is something I have done both with a DDX brick and a standard text card. The text card is probably easier.

Here is the beastmode:

CONCAT(`Title`,'<br>','•',`Value1`,'<br>','•',`Value2`)

There are a variety of bullet symbols, some can be found here: https://www.symbolcopy.com/bullet-points-symbol.html

Additionally I would play around with the chart properties:

That should get you something looking pretty nice.

Dheeraj_1996

But in the text card, the issue was that, only the 1st row of the dataset is being fetched. not all rows.

ColemenWilson

How is your data formatted? If it is not formatted properly it could easily be reformatted to meet your needs.

Dheeraj_1996

thanks, through this I could achieve a part. but not the entire stuff. I used test dataset

and this is what your solution achieved

How would I be able to fetch row 2?

ColemenWilson

Okay, if your data is structured that way you can use the pivot tiles in Magic ETL to put your values that are currently rows as columns and then use the beastmode provided above.

I also got it to work this way:

CONCAT(MAX(CASE WHEN name1 = 'dheeraj' THEN name2 END),'<br>','•',MAX(CASE WHEN name1 = 'sandhanshi' THEN name2 END))