Hua Member

@ST_-Superman-_, Thank you for your response. The solution you described can be (and is) used as a workaround. Since DOMO doesn't provide a "no fill" option, so the "revert" color rule on underneath drillpath cards cannot be completely reverted. The closest color I can choose is the lightest grey, which is not desirable.…

Thank you for the response. Yes, for simple views as in my example, heatmap can be a solution, but my tables usually have more information. So, still, a feature like what Excel Pivot table has is most desireable. Thanks, Hua

How about having two variables, one for dept. name and the other for position name? if (4) then deptName = obj2.value; posName = ''; if (5) then deptName = ''; posName = obj2.value; Then addCell using values in these two variable?

Thank you, @zcameron. Do you happen to know the performance of that API? If I have something, say, close to 20k rows of data, is this a good practice to upload using this API? Thanks, Hua

While "PRINT" gets all rows, it only prints header row once on the first page. So it may be hard to read for longer reports. It will be nice if this feature can be enhanced to repeat header row on each page. Regarding export to Excel, it should be a good option unless you have HTML tags used in any beast mode columns (in…

I still see Facebook sample there on my view: https://developer.domo.com/builder/#!/edit/4812a950-c949-4bb4-8231-f044651d4c60 Can you see it? If not, it needs to be raised to DOMO connector support. Good luck!

Great! It indeed showed up with color and font size change after saving the card. Thank you!

Thank you. The status change on the posts you suggested was from Jan. It will be helpful to know more info about the implementation timeline.

I tested this out, but it didn't work for me. The summary shows with all the tags there....... Code: CONCAT( '<div style="background-color:#bbe491; color:#000000; font-weight:bold; width: 100%; height:100%; margin:-20px; padding:20px">', '+$',MAX(`ReleaseName`), '</div>') The output is as shown in the attached image.…

I'm writing my own custom connector. Please see attachement.

It is good to know. I remmeber trying HTML tags in a beastmode field created for summary, but not working. Can you please share a working example? Thanks.

This is what I learnt from DOMO support and developer: " Updates cannot be scheduled from an unpublished connectors. What the Connector Dev Studio provides should be considered more of a preview of what they can expect their data to look like if the connector were published today. To schedule updates it needs to be…

Thank you, @DarrelR. It worked after changing data type as you suggested. I hope this type of unsurpported data types can be errored out during test run without Send to Domo option checked.

Thank you for your help. Yes, I still have the issue. Here is the link to my connector: https://developer.domo.com/builder/#/edit/4fd0d6e5-714f-41dc-887b-48f99a1dacb8 To clarify, I haven't published my connector yet, and only testing how it works. What I did is to check "Create/Update DataSet" option, exposed by clicking…

I would like to know if there is any solution to this too.

Thank you for the offer. I worked around it and now don't have a good example for this scenario. I will come back to this thread if I run into this issue again.

Thank you for your reply. However the data I provided was only partial of what we need. As an end goal, we would need to have a 100% stacked bar showing completed, WIP and Not Started. Data label should show %_VALUE (count). Here is the end result I'm looking for (generated using excel), and data used for this chart.…

Thank you for your reply. However the data I provided was only partial of what we need. As an end goal, we would need to have a 100% stacked bar showing completed, WIP and Not Started. Data label should show %_VALUE (count). Here is the end result I'm looking for (generated using excel), and data used for this chart.…

Thank you for your reply. However the data I provided was only partial of what we need. As an end goal, we would need to have a 100% stacked bar showing completed, WIP and Not Started. Data label should show %_VALUE (count). Here is the end result I'm looking for (generated using excel), and data used for this chart.…

Actually, no. While it is a solution to use beast mode to display distinct count, there is no way to use it in a bar chart......In my example, I would like to see "6" for the WIP portion of the bar, not "71" shown currently.

I find SQL has better capability processing such data. Or you can try to use BeastMode when building cards. IFNULL($Col, $Value) I hope this helps.

Thank you, @JJ. I am aware of Sumo card type and do use it for some of my metrics. However the limitation of Sumo card not having drill-down capability is something I would like to workaround using normal table cards. When the rows are getting longer (too many column), I would like to be able to display the table with…

Thank you, JJ. I attached the file here.

I'm also having this requirement. I don't think the Uncollapse Columns helps me (went through the doc & test). So, here is what I want to achieve. Can you please help elaborate detailed steps? Domo Arigato! -- Hua

I will give it a try. In theory the calculation part is easy through beastmode. I will need to see how it can be displayed on the chart. "Goal" line in bar charts seem to only take constant. If you have any suggestion on what chart type should be used, that'll be great! Thanks, Hua

That is exactly what I'm using now. Thank you.